MySQL Forums
Forum List  »  NDB clusters

Re: Sysbench data
Posted by: Stewart Smith
Date: June 30, 2006 11:13PM

If you read these results "correctly", you will conclude that a lot of these results show NDB to be FASTER than MyISAM in a similar setup.

NDB has NoOfReplicas=2.

This means that at the end of commit, data is in 2 places.

With the MyISAM setup, it's only in one. So you should possibly divide/multiply the MyISAM results by 2 to estimate the "write twice" that NDB is doing.

Also, sysbench only connects to one mysqld. cluster should get higher results when having several connections to several mysql servers.


you may want to look at the EXPLAIN for your order by queries, see what's going on. maybe some indexes could help, or forcing the use of some index. not sure until you look.

Stewart Smith, Software Engineer - MySQL Cluster
MySQL AB, www.mysql.com

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html

Options: ReplyQuote


Subject
Views
Written By
Posted
2073
June 30, 2006 03:38AM
1075
June 30, 2006 03:46AM
Re: Sysbench data
1190
June 30, 2006 11:13PM
1139
July 01, 2006 02:51AM
1060
July 02, 2006 08:29PM


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.