MySQL Forums
Forum List  »  Performance

Re: CPU usage extremely high
Posted by: Temu Kinn
Date: May 09, 2015 07:38AM

After running pt-query-digest, i got only 2 queries reported. I think the one causing the load has the following analysis:

# Time range: 2015-05-09 15:43:20 to 16:26:23
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 45 5958
# Exec time 96 3981s 547ms 1s 668ms 777ms 61ms 640ms
# Lock time 24 510ms 50us 621us 85us 119us 23us 80us
# Rows sent 3 1.30k 0 1 0.22 0.99 0.41 0
# Rows examine 98 11.54G 1.98M 1.98M 1.98M 1.95M 0 1.95M
# Query size 31 2.38M 416 420 418.68 400.73 0 400.73

The "Rows examine" and "Query size" results look horrible for less than 1 hour of analysis. :) Am i right? or is it normal considering the total query count?
My main plan to resolve the high resource load on the server is to migrate the DB on which this query has to run to a different server that isn't operational.

Options: ReplyQuote


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