MySQL Cluster performance question

Hello,

Recently we decided to test out MySQL Cluster 5.1.19. We have 1 mgm node, 2 data nodes, and 1 sql node with number of replicas set to 2. The servers are connected via Gigabit Ethernet.

We have two tables past30_ndb_disk and past30_MYISAM that contain the same data, but the former utilizes the cluster on-disk while the latter is saved on the sql node as a MyISAM table. The tables are 10,000,000 rows big taking up a little over 1GB of space.

We also have ndb_index_stat_enable = 0
And engine_condition_pushdown = On

I ran the same query on both tables and got the following:

mysql> SELECT DISTINCT gv_symbol FROM `past30_ndb_disk` FORCE INDEX
(`gvsymtime`) WHERE 1;

90 rows in set (4 min 44.90 sec)

mysql> SELECT DISTINCT gv_symbol FROM `past30_MYISAM` FORCE INDEX
(`gvsymtime`) WHERE 1;

90 rows in set (1.54 sec)

I was not expecting a difference this drastic. Do you have any tips on how to get a better response time?

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

-Al

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com