MySQL Forums
Forum List  »  Newbie

Re: Newbie with a server issue
Posted by: Rick James
Date: January 13, 2015 04:03PM

* Inadequate indexes.
* Poorly formulated queries.
* Other possibilities.

When the CPU is high, do SHOW FULL PROCESSLIST to see what queries are running. (Do that a few times to see the pattern.) Then show us a query and provide
SHOW CREATE TABLE -- for any table(s) involved in the query
EXPLAIN SELECT ... -- for the SELECT (assuming it is a SELECT)
How much RAM do you have?

Options: ReplyQuote


Subject
Written By
Posted
Re: Newbie with a server issue
January 13, 2015 04:03PM


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.