MySQL Forums
Forum List  »  NDB clusters

Re: How to speed up the answer time ?
Posted by: Martin Skold
Date: January 12, 2005 04:39AM

Hi Jörg!

I am not sure if your question is if you can have several query nodes (mysqld) in a cluster in general (you can)
or if it is appropriate to run several mysqld processes on the same machine? If you you don't have a multi-CPU
machine, then running more than one mysqld probably costs more in context switching than you will gain in better
utilization of the cluster. Having several query nodes connect to a cluster (preferably from different machines)
normally gives you better utilization of the cluster since the mysqld often become the botlleneck. You can determine this
by looking at the CPU-load, if the mysqld is using a lot of CPU-time and the storage nodes (ndbd processes) are
using very little CPU-time you probably have more performance you can tap into through additional query nodes.

BR
-- Martin

Options: ReplyQuote


Subject
Views
Written By
Posted
3454
January 11, 2005 02:27AM
Re: How to speed up the answer time ?
2190
January 12, 2005 04:39AM
2362
January 12, 2005 10:09AM
2303
January 12, 2005 01:59PM


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.