MySQL Forums
Forum List  »  Performance

Statistics
Posted by: Ashley Martens
Date: April 25, 2010 10:45AM

When I analyze my slow query log I see the Statistics command as a problem. I initially thought that this was being caused by code trying to EXPLAIN queries, but I have ruled that out. Is this indexing?

# Query 1: 185.91 QPS, 15.65x concurrency, ID 0xFDA56061CFC0F1F0 at byte 1200641937
# This item is included in the report because it matches --limit.
# pct total min max avg 95% stddev median
# Count 63 15603423
# Exec time 52 1313202s 10ms 3s 84ms 266ms 91ms 51ms
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows exam 0 0 0 0 0 0 0 0
# Query_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ##########################
# 1s #
# 10s+
# administrator command: Statistics\G

Options: ReplyQuote


Subject
Views
Written By
Posted
Statistics
3136
April 25, 2010 10:45AM
1166
April 26, 2010 09:14PM
899
April 27, 2010 06:32AM
1132
April 27, 2010 08:08AM
974
April 27, 2010 09:13AM
1037
April 27, 2010 08:00PM


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.