MySQL Forums
Forum List  »  NDB clusters

SQL Cluster Performane worse than MyISAM.
Posted by: Andrew Mcleod
Date: February 24, 2005 10:25AM

Hi,

I am yet another person that is curious with MySQL Cluster, and loved the idea of acheiving more performance by the NDBCLUSTER storage engine loading all tables into memory.

Expecting an increase in performance, I was shocked to see things taking even longer. A query that would take less than one second using MyISAM disk based tables, took up near FIVE seconds using NDBCLUSTER. These tables are are mere 16MB in size in total (two tables plus indexes) - so this behaviour is completely unexpected.

This is how I've measured the performance over and over... as follows:

mysql> alter table iBB_members type=ndb;
Query OK, 15581 rows affected, 1 warning (13.79 sec)
Records: 15581 Duplicates: 0 Warnings: 0

mysql> alter table iBB_blog_blogs type=ndb;
Query OK, 15029 rows affected, 1 warning (20.69 sec)
Records: 15029 Duplicates: 0 Warnings: 0

mysql> SELECT b.*, m.name FROM iBB_blog_blogs b LEFT JOIN iBB_members m ON (b.member_id=m.id) WHERE b.blog_private=0 AND blog_name IS NOT NULL
ORDER BY b.blog_pinned DESC, blog_last_date desc LIMIT 1;
-----output omitted------
1 row in set (4.27 sec)

Over four seconds here, it varies - however, if I convert these two tables back to MyISAM:

mysql> alter table iBB_members type=myisam;
Query OK, 15582 rows affected, 1 warning (7.25 sec)
Records: 15582 Duplicates: 0 Warnings: 0

mysql> alter table iBB_blog_blogs type=myisam;
Query OK, 15030 rows affected, 1 warning (6.79 sec)
Records: 15030 Duplicates: 0 Warnings: 0

mysql> SELECT b.*, m.name FROM iBB_blog_blogs b LEFT JOIN iBB_members m ON (b.member_id=m.id) WHERE b.blog_private=0 AND blog_name IS NOT NULL ORDER BY b.blog_pinned DESC, blog_last_date desc LIMIT 1;
-----output omitted-------
1 row in set (0.38 sec)

Cluster config.ini as follows for reference:

[NDBD DEFAULT]
NoOfReplicas= 1
DataMemory= 1024M
IndexMemory= 384M
LockPagesInMainMemory=1
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD]
HostName= 192.168.254.1
[NDBD]
HostName= 192.168.254.1
DataDir= /usr/local/mysql/data
[MYSQLD]
HostName= 192.168.254.1

Any help as to what the problem is would be greatly appreciated, I've spent the past week working on preparing an environment and configuring MySQL Cluster and am extremely dissapointed with these performance tests!

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL Cluster Performane worse than MyISAM.
4699
February 24, 2005 10: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.