MySQL Forums
Forum List  »  Performance

Re: heavy read workload with high cpu usage
Posted by: Rick James
Date: June 04, 2015 08:35AM

High CPU usually implies a missing index. It may imply a poorly formulated query. Please provide

EXPLAIN SELECT ...; -- for any SELECTs that are slow.
SHOW CREATE TABLE -- for whatever tables are involved.

From those, we may be able to provide an improvement. (Or we may need to ask for more info.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: heavy read workload with high cpu usage
855
June 04, 2015 08:35AM


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.