MySQL Forums
Forum List  »  NDB clusters

Re: SQL Cluster Performane worse than MyISAM.
Posted by: Peter Zaitsev
Date: February 24, 2005 05:19PM

This is well expected.

It is wrongly assumed what as NDB Cluster is In Memory database its performance should be close to HEAP (In memory) tables.

There is a giant difference between data being located in the same process address space (HEAP) or in different process or over network (NDB), So even if you run NDB on the same node as MySQL Server for test performance will be lower.

The access to different process on the same box is expensive (especially as NDB uses TCP/IP, as this is configuration only for testing any way), access over ethernet network
is even more expensive.

How large performance overhead is a lot depends on how much round trips will be involved. For single row lookups the difference is smaller as query parsing and reciving from client takes large part. For joins it is much larger as there are a lot of network round trips has to be made.

Also MySQL Optimizer was mainly done for On Disk and In Memory tables - working with
"remote" tables requires different join methods which are in development now.

Options: ReplyQuote


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


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.