MySQL Forums
Forum List  »  NDB clusters

Bad performance mysql cluster versus innodb
Posted by: Arié TIBI
Date: February 09, 2005 08:25AM

Hello,

We successfully installed Mysql cluster but we have really bad performances for DML operations (insertion of 100000 lines). Here is examples of TMC :

TABLE ENGINE=NDBCLUSTER
#time cat load.txt | mysql test
real 0m20.078s
user 0m0.680s
sys 0m0.400s

TABLE ENGINE=INNODB
real 0m5.057s
user 0m0.570s
sys 0m0.410s

TABLE ENGINE=MYISAM
real 0m4.143s
user 0m0.700s
sys 0m0.330s

Have you any way to improve performances of NDBCLUSTER (we hope at least the same as INNODB) ?

Our configuration :
==============
- Linux Debian
- Computer : PII 500MRAM (the result is the same PIV 2GoRAM)
- mysql-max-4.1.9-pc-linux-gnu-i686.tar.gz
- intel-icc8-libs-8.0-0.i386.rpm

Cluster is single-node :

[NDBD DEFAULT]
NoOfReplicas= 1
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=lea
[NDBD]
HostName=lea
DataDir= /var/lib/mysql-cluster
[MYSQLD]

We tryed to change parameters but it is the same result :

[NDBD DEFAULT]
NoOfReplicas= 1
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName=lea
[NDBD]
HostName=lea
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes=5000
MaxNoOfUniqueHashIndexes=5000
MaxNoOfConcurrentIndexOperations=14000
MaxNoOfConcurrentOperations=50000
#MaxNoOfConcurrentScans=400
#TimeBetweenGlobalCheckpoints=500
IndexMemory=100M
DataMemory=100M
[MYSQLD]

Other operating system :
==================
It's the same result with RedHat AS3

Best regards

Options: ReplyQuote


Subject
Views
Written By
Posted
Bad performance mysql cluster versus innodb
4442
February 09, 2005 08:25AM


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.