关于MySQL的慢日志分析工具
# 280ms user time, 80ms systemtime, 11.56M rss, 16.65M vsz # Currentdate: Sat May8 02:47:39 2010# Files: localhost-slow.log
#Overall: 4 total, 3 unique, 0.01 QPS, 1.96x concurrency ________________
# total min max avg 95%stddevmedian
# Exectime 1443s 5s 1418s 361s 1357s 584s 684s
#Lock time 0 0 0 0 0 0 0
#Rows sent 1 0 1 0.25 0.99 0.43 0
#Rows exam 6.98M 1.69M 1.89M 1.74M 1.86M76.62k 1.69M
# Time range 2010-05-08 00:28:42 to 2010-05-08 00:40:58
#Profile
# Rank Query> # ==== ================== ================ ===== ========================
# 1 0x2A94F91D8C3B4B261418.0000 99.0% 11418.0000 INSERT SELECT t_page_sample
# 2 0x06754F1BD3C8D697 14.00001.0% 2 7.0000 SELECT t_page_sample
# Query 1: 0QPS, 0x concurrency,> # Thisitem is included in the report because it matches --limit.
# pct total min max avg 95%stddevmedian
#Count 25 1
# Exec time 98 1418s 1418s 1418s 1418s 1418s 0 1418s
# Lock time 0 0 0 0 0 0 0 0
# Rows sent 0 0 0 0 0 0 0 0
# Rows exam 27 1.89M 1.89M 1.89M 1.89M 1.89M 0 1.89M
# Timerange 2010-05-08 00:28:42 to 2010-05-08 00:28:42
# Query_timedistribution
# 1us
#10us
# 100us
# 1ms
#10ms
#100ms
# 1s
#10s+ ################################################################
#Review information
# first_seen: 2010-05-08 00:28:42
# last_seen: 2010-05-08 00:28:42
# reviewed_by:
# reviewed_on:
# comments:
# Tables
# SHOW TABLE STATUS FROM `t_girl` LIKE't_page_sample'\G
# SHOW CREATE TABLE `t_girl`.`t_page_sample`\G
insert ignore into t_page_sample select ceil(rand()*10000000), ceil(rand()*9),date_sub(now(),interval floor(rand()*20) day), now() fromt_page_sample\G
# Query 2: 0.07 QPS, 0.47x concurrency,> # This item is included in the reportbecause it matches --limit.
# pct total min max avg 95%stddevmedian
# Count 50 2
#Exec time 0 14s 5s 9s 7s 9s 3s 7s
#Lock time 0 0 0 0 0 0 0 0
#Rows sent 0 0 0 0 0 0 0 0
#Rows exam 48 3.39M 1.69M 1.69M 1.69M 1.69M 0 1.69M
# Time range 2010-05-08 00:40:28 to 2010-05-08 00:40:58
#Query_time distribution
# 1us
#10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s ################################################################
# 10s+
# Review information
# first_seen: 2010-05-08 00:40:28
# last_seen: 2010-05-08 00:40:58
# reviewed_by:
# reviewed_on:
# comments:
# Tables
# SHOW TABLE STATUS FROM`t_girl` LIKE 't_page_sample'\G
# SHOW CREATE TABLE`t_girl`.`t_page_sample`\G
# EXPLAIN
select * from t_page_sampleorder by>
页:
[1]