MySQL Forums
Forum List  »  NDB clusters

Bad performance in comparison with myisam
Posted by: fasdf asdfasd
Date: January 14, 2013 10:17AM

Hi,

I have this setup

2x
- 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
- ndb_mgmd
- mysqld

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.

Ladislav Prokopny



Edited 2 time(s). Last edit at 01/14/2013 10:39AM by fasdf asdfasd.

Options: ReplyQuote


Subject
Views
Written By
Posted
Bad performance in comparison with myisam
1576
January 14, 2013 10:17AM


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.