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
Subject
Views
Written By
Posted
Bad performance mysql cluster versus innodb
4442
February 09, 2005 08:25AM
2806
February 09, 2005 04:57PM
2532
February 10, 2005 11:32AM
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.