Re: Unusually high cpu usage
Posted by:
Rick James
Date: January 12, 2015 09:49PM
High CPU usage in MySQL is almost always a result of poor indexes and/or poorly written SELECTs. Do SHOW PROCESSLIST when the CPU is high, show us the the queries in it, plus show us SHOW CREATE TABLE for the table(s) involved.
While you are at it, What version of MySQL? How much RAM do you have? Let's see
SHOW VARIABLES LIKE '%buffer%'
From there, we can advise further. (And may need to ask for more info.)
Subject
Views
Written By
Posted
2968
January 11, 2015 02:55PM
Re: Unusually high cpu usage
1192
January 12, 2015 09:49PM
1049
January 13, 2015 09:32AM
1377
January 13, 2015 11:47AM
1065
January 13, 2015 04:21PM
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.