MySQL Forums :: Performance :: Statistics


Advanced Search

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 2974 Ashley Martens 04/25/2010 10:45AM
Re: Statistics 1146 Rick James 04/26/2010 09:14PM
Re: Statistics 873 Ashley Martens 04/27/2010 06:32AM
Re: Statistics 1105 Rick James 04/27/2010 08:08AM
Re: Statistics 946 Ashley Martens 04/27/2010 09:13AM
Re: Statistics 1019 Rick James 04/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.