Hey all,

Just wondering if anyone here would have some suggestions for tweaking a MySQL server for optimal performance. Specifically, I'm curious to know if there is anything special that would need to be done to optimize the system to use multiple processors. The system config is:

RHES 3 on SMP 2.4 kernel
Dual 2.66 Xeon processors with HT
2 GB RAM
SCSI RAID array
MySQL 4.0.17

This system is already in production, so I can't make any huge changes, but there are times where it seems to only be using 1 CPU. I'm hoping that someone has some suggestions on what settings I could check to see if it's set up to use multiple CPUs.

Thanks.

P.S. I apologize in advance, but I don't know much at all about MySQL, I usually deal more with the hardware side of things. If there's any specific info needed though, I can get it.

I think its much more important is having the databases and tables designed and created properly, with efficiency in mind. You'd be very suprised the difference it makes.

BluePyre,

While not knowing much about MySQL, I do know that our programmers have spent a lot of time setting up our tables as efficiently as possible. A lot of time is spent making sure that things are created properly, queries are set up right, and that the tables are optimized on a regular basis. And make no mistake, the system is already very fast, but it just appears at times that it's not utilizing the other processor(s) as much as it could, and I was looking to see if there was something I could do to help with that.

You may like to upgrade the kernel to 2.6, if you're looking for more power and spead. I read somewhere its around 10% faster than the 2.4 kernel.
Not sure on utilising more than one CPU... i'm hoping someone more knowledgable comes along.