MySQL Forums :: Cluster :: Bad performance in comparison with myisam
Bad performance in comparison with myisam
Posted by: fasdf asdfasd
Date: January 14, 2013 10:17AM
I have this setup
- baremetal Xeon quadcore 48gb RAM , 1gbps interconnect with Ethernet
- ndbd - 12GB memory usage (8GB data + 3GB index + 1GB operations)
- 1x 1TB HDD 7200rpm
1x virtual machine on RAID6 storage
Results of my testing are horrible, and I cannot find any bottleneck. There are numbers:
Executed on ndb_mgmd machine (testing ndb):
perl test-insert --server=mysql --create-options=ENGINE=ndbcluster --server=mysql
Total time: 341 wallclock secs (11.26 usr 0.63 sys + 0.00 cusr 0.00 csys = 11.89 CPU)
Executed on ndb_mgmd machine (testing myisam):
perl test-insert --server=mysql --create-options=ENGINE=MyISAM --server=mysql
Total time: 25 wallclock secs (10.40 usr 0.84 sys + 0.00 cusr 0.00 csys = 11.24 CPU)
I know there is synchronous writing in ndb, but come on, it cannot be 15x times slower than MyISAM.
Could you please explain, what should I examine in this setup? Thanks.
Edited 2 time(s). Last edit at 01/14/2013 10:39AM by fasdf asdfasd.
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.