Re: MySQL using too much CPU
Posted by:
Rick James
Date: August 30, 2014 05:27PM
> long_query_time=5 -- decrease to 2; then look at the slowlog
> log-queries-not-using-indexes=1 -- waste of time, turn off
What do you see with this mysql command?
SHOW PROCESSLIST?
My point is, that until you can identify a query that is chewing up the CPU, nothing can be done. MySQL does not use much CPU when 'idle'; certainly not 66.2%.
Subject
Views
Written By
Posted
2216
August 29, 2014 05:12PM
Re: MySQL using too much CPU
1003
August 30, 2014 05:27PM
1126
August 31, 2014 10:13PM
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.