mysql is not using multiple cpus

Posted by helpmhost on Server Fault See other posts from Server Fault or by helpmhost
Published on 2010-12-26T09:30:16Z Indexed on 2010/12/26 9:55 UTC
Read the original article Hit count: 190

Filed under:
|

Hi,

Our MySQL server has been using a lot of CPU lately (it's reached 100% several times and stays there for a while) and I noticed that it the CPU load is all on one core of one cpu. I was hoping to spread that out to all 4 on my server.

I have been tweaking the MySQL settings to use more ram and less cpu, but it still occasionally reaches very high CPU usage.

It seems like everything about the topic refers to thread_concurrency (which I've read is a solaris only setting). What can I do in Linux?

Thanks.

© Server Fault or respective owner

Related posts about mysql

Related posts about Performance