High CPU - What to do.

Posted by Udi Kantzuker on Stack Overflow See other posts from Stack Overflow or by Udi Kantzuker
Published on 2010-09-30T01:01:47Z Indexed on 2011/01/18 2:53 UTC
Read the original article Hit count: 181

Filed under:
|
|

I have a high CPU problem with MYSQL using "top" ( linux ) shows cpu peaks of 90%.

I was trying to find the source of the problem, turned on general log and slow query log, The slow query log did not find anything.

The Db contains a few small tables and one large table that contains almost 100k rows, Database Engine is MyIsam. strange thing i have noticed that on the large table, select, insert are very fast but update takes 0.2 - 0.5 secs.

already used optimize and repair and no improvement.

the table is being updated frequently, could this be the source of the high CPU% ?

What can i do to improve this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about Performance