Skip navigation links

MySQL Forums :: Cluster :: Bad performance in comparison with myisam


Advanced Search

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 747 fasdf asdfasd 01/14/2013 10:17AM
Re: Bad performance in comparison with myisam 395 Matthew Keep 01/14/2013 01:04PM
Re: Bad performance in comparison with myisam 457 Daniel Fernandez 01/16/2013 08:12AM


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.