MySQL Forums
Forum List  »  Performance

Re: CPU usage extremely high
Posted by: Rick James
Date: April 29, 2015 05:43PM

Thanks for the STATUS; need SHOW VARIABLES, too. And how much RAM do you have?

After posting that, change long_query_time to 0.5 and wait for some interesting stuff to get in the slowlog. Then run pt-query-digest to see which queries are the 'worst'.

("Load average" is not necessarily a good judge of CPU need.)

Options: ReplyQuote


Subject
Views
Written By
Posted
3050
April 28, 2015 08:55AM
1420
April 28, 2015 09:03AM
Re: CPU usage extremely high
1161
April 29, 2015 05:43PM
1189
May 09, 2015 07:22AM
1062
May 09, 2015 07:38AM
1076
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.