Re: Mysql consuming huge CPU resources.
MySQL version?
Post results of ...
show global status;
show variables;
What does the slow-query log say (if it's not running, start it)? Let's see the results of Explain Extended on a few of those slow queries.
For a preliminary shot at identifying problems, run one or more of the queries under "Optimisation cheatsheet" at
http://www.artfulsoftware.com/infotree/mysqltips.php
Subject
Written By
Posted
Re: Mysql consuming huge CPU resources.
May 09, 2015 01: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.