Re: Bad performance mysql cluster versus innodb

[Arié TIBI]

Hello,

* Even in one transaction, I got bad performances :

mysql> insert into table_ndbcluster (select * from tload);
Query OK, 99991 rows affected (1 min 38.18 sec)
Records: 99991 Duplicates: 0 Warnings: 0

mysql> insert into table_innodb (select * from tload);
Query OK, 99991 rows affected (9.64 sec)
Records: 99991 Duplicates: 0 Warnings: 0

Innodb has been tuned for the computer. What are cluster performance tuning parameter (I have 500Mo RAM) ?

I tryed to change these parameters with no success :

MaxNoOfOrderedIndexes=5000
MaxNoOfUniqueHashIndexes=5000
MaxNoOfConcurrentIndexOperations=14000
MaxNoOfConcurrentOperations=150000
MaxNoOfConcurrentScans=400
TimeBetweenGlobalCheckpoints=500
IndexMemory=100M
DataMemory=100M

* In a second time I will put a second server in cluster to have redundancy.

Best regards