Peter and/or gallery,
What is the best way to make use of all the cores of a multi-core machine running NDB?
My current set up is the following :
2 x Dual Quad Core for MySQL Heads raid 10, 15k RPM SAS drives 8G memory
6 x Dual Quad Core for Data Nodes raid 10, 15k RPM SAS drives 16G memory
The problem I see is that the ndbd and mysqld processes SEEM to only use one core on each of the machines. Am I correct?
Do I need to start up a new NDBD process for each core on each machine to take full advantage of the processing power of these machines?
Has anyone worked with this that might be able to advise?