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.
Subject
Views
Written By
Posted
poor performance on load data to NDB
2130
October 05, 2006 11:07PM
1192
October 06, 2006 05:30AM
1305
October 06, 2006 08:42AM
1330
October 06, 2006 05:43AM
1114
October 06, 2006 09:08AM
1391
October 06, 2006 10:13AM
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.