MySQL Forums
Forum List  »  Performance

Re: CPU Usage Maxing Out
Posted by: Rick James
Date: February 06, 2014 07:41PM

Where did "The rate of reading the..." come from? It does not make sense to me.

Get into a shell, and type
mysql
That will bring up the commandline tool, which is possibly less clumsy than the UI you are using.
In that, enter these 3 lines:
SHOW VARIABLES;
SHOW GLOBAL STATUS;
exit
and provide the lengthy output here.

When you see that the CPU is "busy", first do
top
(in a shell). The first entry should have a high CPU value; is it "mysqld"?
Kill "top" (Ctrl-C).
Assuming mysqld was chewing up a lot of CPU, go back into
mysql
and enter
SHOW PROCESSLIST;
Repeat the SHOW a few times. Do you see some SELECT or UPDATE frequently? Perhaps with the "time" column bigger than a few seconds? Show us that query.

Options: ReplyQuote


Subject
Views
Written By
Posted
3137
February 03, 2014 05:39PM
1342
February 03, 2014 05:46PM
1154
February 04, 2014 10:20PM
1355
February 05, 2014 02:07PM
Re: CPU Usage Maxing Out
1296
February 06, 2014 07:41PM
1277
February 07, 2014 12:55PM
1523
February 07, 2014 06:32PM
1280
February 13, 2014 10:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.