System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

mysql - cpu user usage>90.0%

SOLVED
Go to solution
Piotr Kirklewski
Super Advisor

mysql - cpu user usage>90.0%

Hi there
About two hours ago it started:

cpu user usage>90.0%

If I reboot the

process /etc/init.f/mysqld/reboot

Then its fine for 5 mins.

How can I check what exactly is mysql doing ?

Cheers
Jesus is the King
4 REPLIES
Philip Gunter
Respected Contributor
Solution

Re: mysql - cpu user usage>90.0%

Hi Nagileon,

you should have a look at mytop. That should help you locate where the perf issue is with mysql.

http://jeremy.zawodny.com/mysql/mytop/

Cheers,
Philip.
Steven E. Protter
Exalted Contributor

Re: mysql - cpu user usage>90.0%

Shalom,

90% CPU use is not a serious problem on a Linux or Unix system.

I would suggest the sar utility to measure performance and see if its cpu, i/o or whatnot.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Piotr Kirklewski
Super Advisor

Re: mysql - cpu user usage>90.0%

Monit is set to send a message if the user cpu usage is > 90% but in the reality its obout 99.9%.
I don't like it.

How can I limit cpu usage for this user ?

Cheers
Jesus is the King
Stuart Browne
Honored Contributor

Re: mysql - cpu user usage>90.0%

mysqladmin processlist

This will list the queries that are currently running in mysql.

Hopefully, there'll be an easy to see operation occuring which you can track back.

if that's not it, ensure that the slow query log is on, and see if there's a re-occuring query which is chomping the machine.
One long-haired git at your service...