1 message in com.mysql.lists.clusterExtremely slow queries on an API-node...
FromSent OnAttachments
Just Marc15 May 2006 08:13 
Subject:Extremely slow queries on an API-node when creating ndb tables
From:Just Marc (ma@corky.net)
Date:05/15/2006 08:13:55 AM
List:com.mysql.lists.cluster

Hello everyone,

I'm new to Cluster and setting it up for the first time. While in transition (and until I verify that Cluster works for my application) I reuse a few running MySQL servers as API nodes.

I have noticed that when creating NDB tables, regular queries that are currently running on the same nodes (although not over the NDB storage engine, but MyISAM) become extremely slow until NDB table creation is complete. Once the tables are created mysqld processes queries at regular speeds again.

To reproduce; simply use an API node for handling non-NDB queries and create an NDB table while regular queries are running.

Has anyone encountered this? Is this a bug, a feature? In either case, it should be documented :)

Thanks