Re: MySQL huge CPU usage
> Id User Host db Command Time State Info
> 408193 diariode localhost NULL Query 0 NULL SHOW FULL PROCESSLIST
You need to catch a "slow" query in the act -- so we can see what the query is. You need to do the SHOW FULL PROCESSLIST as either "root" or the same user as is slow.
Virtually all CPU time is associated with the execution of queries. Hence, the need to find out which query (or queries)
Need
SHOW VARIABLES;
SHOW GLOBAL STATUS; -- note 'GLOBAL'
The Query cache seems to be rather large, but without SHOW VARIABLES, I don't know how big it is. The STATUS does imply that it is rather effective. Still, if the QC is slowing things down rather than speeding them up, that should show up in the slowlog or the PROCESSLIST.
Subject
Written By
Posted
Re: MySQL huge CPU usage
June 09, 2014 11:32AM
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.