11 messages in com.mysql.lists.clusterRe: Performance
FromSent OnAttachments
Manuel Jenne29 Jun 2005 14:50 
Simon Garner29 Jun 2005 15:33 
Jonathan Miller29 Jun 2005 15:50 
Simon Garner29 Jun 2005 16:03 
Jonathan Miller29 Jun 2005 16:14 
Stewart Smith29 Jun 2005 20:09 
Mikael Ronström30 Jun 2005 00:48 
Manuel Jenne30 Jun 2005 01:12.bench, .bench
Stewart Smith30 Jun 2005 03:16 
Manuel Jenne30 Jun 2005 03:33 
Mikael Ronström30 Jun 2005 05:23 
Subject:Re: Performance
From:Simon Garner (sgar@expio.co.nz)
Date:06/29/2005 03:33:46 PM
List:com.mysql.lists.cluster

On 30/06/2005 9:50 a.m., Manuel Jenne wrote:

Hi,

I've very poor performance on my MySQL Cluster. A import from a 100Mb dump take up to 30min but the same import to MyISAM takes only a few seconds !!! I also tried to use MySQL-bench but I don't want to wait half a day for a result!

I find importing dumps in MySQL Cluster is slower than normal operations as it usually involves dropping and creating tables. CREATE TABLE, DROP TABLE and ALTER TABLE are all very slow in NDB.

SELECT, INSERT, UPDATE, DELETE should be similar performance to MyISAM/InnoDB (but not quite as good).

On the whole, performance with MySQL Cluster is very disappointing, as is its reliability and support for basic MySQL functionality. It does have scalability advantages over using a single server, though.

-Simon