MySQL Forums
Forum List  »  NDB clusters

poor performance on load data to NDB
Posted by: Andy Kwong
Date: October 05, 2006 11:07PM

I have been testing mysql 5.1.11 with the NDB on 2 nodes. I'm comparing load data to a table and the loading is extremely slow. Here are the results on a cluster of daul Xeon with 6G RAM on each box (2 ndbd, 1 mysqld)
10K rows - 3.2s
100K rows - 33s
1000K rows - 340s
They look fairly linear.

I tried to stop one of the NDB node and the result improve a lot:
10K rows - 0.82s
100K rows - 9s
1000K rows - 93s
So, the Sync-cluster is really slowing this down.

Then I tried to use myisam on just ONE node:
10K rows - 0.05s
100K rows - 0.51s
1000K rows - 6.5s

It looks to me either I did not get the NDB tune correctly or the cluster engine has a very servere penalty on HA vs performance. Can anyone point me to any info to improve the NDB performance?

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
poor performance on load data to NDB
2130
October 05, 2006 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.