MySQL Forums
Forum List  »  NDB clusters

Re: SQL Cluster Performane worse than MyISAM.
Posted by: John David Duncan
Date: February 24, 2005 05:08PM

Those results aren't surprising, but then again, there's more than one kind of performance.

Joins can be slow in MySQL Cluster. MySQL's optimizer was designed for on-disk data, not for data that is "far away" over the network in the NDB storage nodes... so the optimizer's execution plan for a left join can turn out to be far from ideal.

But for another case, suppose you have a one-row update to a million-row table, using the primary key, and by "performance" you want to know how many of the updates you can perform per second. Does the database bog down at 10 users, or 100, or 1000, or several thousand? This is a case where MySQL Cluster can truly outperform the other storage engines.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL Cluster Performane worse than MyISAM.
2411
February 24, 2005 05:08PM


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.