MySQL Bugs: #19970: Queries run on the cluster affect of other databases running on API nodes

Bug #19970	Queries run on the cluster affect of other databases running on API nodes
Submitted:	20 May 2006 15:04	Modified:	21 May 2006 5:12
Reporter:	heh heh	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.21	OS:	Linux (Linux x86_64)
Assigned to:		CPU Architecture:	Any

Description:
Temporarily until I have MySQL Cluster "figured out" and working stable alongside with a production system, I am re-using a few production machines running MySQL as API nodes.

It seems that cluster affects regular work being done on these nodes by slowing queries down significantly, this slowdown is especially visible when issuing commands to create new ndbcluster type tables on any of the API nodes.

While 'create table' type ndbcluster have the biggest performance impact for the db running on that particular node,  regular cluster work also seems to affect performance significantly.

Please note that at the momet my cluster is simply a replicating slave for the production system and only insert/update/delete queries are running on it, we are not reading any data yet.

How to repeat:
Run a regular MyISAM db on a cluster API node and perform ndb table creation

We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

Please see our Cluster Forum at http://forums.mysql.com/list.php?25
this seems to be a better place for this kind of questions/observations

This wasn't a question, it was an observation of something that looks bad.