2 messages in com.mysql.lists.clusterRe: crash| From | Sent On | Attachments |
|---|---|---|
| Frank Cases | 25 Aug 2005 08:57 | |
| Stewart Smith | 25 Aug 2005 21:23 |
| Subject: | Re: crash |
|---|---|
| From: | Stewart Smith (stew...@mysql.com) |
| Date: | 08/25/2005 09:23:30 PM |
| List: | com.mysql.lists.cluster |
On Thu, 2005-08-25 at 15:57 +0000, Frank Cases wrote:
ok .. so BOX A has a 1.5 meg DB all tables are primary key (id) auto incr.
execept one wich has a 'name' field as primary key..
nowEACH time i put a bit of traffic on BOX A
Traffic goes up to 15 MEG/S and node 1 4MBS node 2 8MBS node 3 2MBS
It will depend on what queries you are running. A table scan requires the whole table to be sent to the mysqld[1].
[1] Unless you're using 5.0 with engine_condition_pushdown enabled
any special setting to put like RedoBuffer=128M
MaxNoOfConcurrentTransactions=4096 MaxNoOfConcurrentOperations=32768 MaxNoOfAttributes=2500 MaxNoOfTables=1600 MaxNoOfTriggers=10000 LogLevelStartup=5
etcetc for hight load ?
It depends on what kind of load you're going to have. Maybe you should consider some consulting on this? Then there can be detailed analysis of your setup, tables and queries.
ALOT of traffic between thisbox and port 2202 etcetc
for 4.1, this is where cluster data goes between nodes (well, starting at port 2202... then going up a few.)
-- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: 66...@sip.us.mysql.com Mobile: +61 4 3 8844 332
Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html