Re: MySQL huge CPU usage
Posted by: Rick James
Date: June 09, 2014 11:32AM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
June 06, 2014 12:30PM
June 07, 2014 05:46PM
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.