we have upgraded our cluster to a gigabit network and it doesn't seem that it has
increased the performance very much.
on cluster:
select count(*) from gmargin where gm_quote > 0;
1 row in set (29.09 sec)
count(*) = 3786401
on normal mysqld:
select count(*) from gmargin where gm_quote > 0;
1 row in set (17.51 sec)
count(*) = 3798781
this is about the same performance as we had on our 10/100 network...
the records are 100 bytes, and each of those records has to be sent to the mysql server
for counting, as I understand. so, 378,640,100 bytes are being sent in 30 seconds, which
is 12,621,336 bytes/sec. or 100,970,693 bits...100 megabit.
Mikael suggested that the bottleneck was the network connection, since all the records had
to be returned to the mysql server. but we are now using a gigabit connection between the
4 machines involved, and we get the same speed.
is there some kind of special setup for the mysqld server to be able to handle gigabit
connections? we're running that mysqld (API node) on the same machine as the first DB
node, could that have something to do with it? do these speeds seem normal? or is the
bottleneck perhaps something else besides the network?
we're very excited about using cluster, but figure the performance should be on par or
better than a regular mysql server or we'll have to go to regular replication or
something else...
any ideas?
thanks again,
-L
