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
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