23 messages in com.mysql.lists.clusterRe: MySQL Cluster is slow
FromSent OnAttachments
Mindaugas18 Oct 2006 23:23 
Jon Stephens18 Oct 2006 23:49 
Mindaugas19 Oct 2006 02:50 
Hartmut Holzgraefe19 Oct 2006 02:54 
Einar Rustad19 Oct 2006 04:47 
Mindaugas19 Oct 2006 05:44 
Hartmut Holzgraefe19 Oct 2006 05:55 
Stewart Smith19 Oct 2006 06:09 
Mikael Ronström20 Oct 2006 05:28 
JM20 Oct 2006 05:31 
Mindaugas20 Oct 2006 06:49 
Kevin Burton23 Oct 2006 00:08 
Kevin Burton23 Oct 2006 00:12 
Einar Rustad24 Oct 2006 12:06 
Dirk Dunger25 Oct 2006 07:02 
Mindaugas25 Oct 2006 07:16 
Dirk Dunger26 Oct 2006 05:45 
Brendan Bouffler26 Oct 2006 18:10 
Mikael Ronström26 Oct 2006 21:35 
Mikael Ronström26 Oct 2006 21:52 
Stewart Smith26 Oct 2006 22:45 
Mikael Ronström27 Oct 2006 06:34 
Dirk Dunger28 Oct 2006 03:05 
Subject:Re: MySQL Cluster is slow
From:Mindaugas (mi@bi.lt)
Date:10/19/2006 02:50:57 AM
List:com.mysql.lists.cluster

Why MySQL Cluster is so slow? Below is some simple test which shows that cluster is more than 5 times slower than MyISAM. Why? Cluster tables should be in memory,

Correct. However, there's the fact that your data's moving over the wire. No nonessential traffic should be moving over the same subnet being used by the data nodes to communicate with the management node(s). Gigabit Ethernet is also highly recommended for serious usage.

There is Gigabit Ethernet between nodes.

But what for this traffic between nodes? I'm only doing SELECTs.

In any case - maybe it is possible to reduce traffic? Remove one management node? What else could be done?

Thanks,

Mindaugas