MySQL Forums
Forum List  »  Performance

Re: CPU usage extremely high
Posted by: Rick James
Date: May 11, 2015 06:30PM

You cut off the output before the statement. Let's see the statement, plus SHOW CREATE TABLE for any table(s) involved.

I do see that it scanned 1.98 million rows in less than a second. That sounds like a table scan. Maybe an INDEX would avoid having to do that much work.

Options: ReplyQuote


Subject
Views
Written By
Posted
3050
April 28, 2015 08:55AM
1420
April 28, 2015 09:03AM
1161
April 29, 2015 05:43PM
1189
May 09, 2015 07:22AM
1062
May 09, 2015 07:38AM
Re: CPU usage extremely high
1075
May 11, 2015 06:30PM


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.