Slide 7
Slide 7 text
使い方
$ mk-query-digest --fingerprints slow.log
# Files: slow.log
# Overall: 115 total, 12 unique, 0.00 QPS, 0.03x concurrency _____________
# total min max avg 95% stddev median
# Exec time 2323s 3s 338s 20s 49s 43s 5s
# Lock time 6ms 22us 270us 55us 98us 31us 42us
# Rows sent 22.92k 0 664 204.08 487.09 171.01 166.51
# Rows exam 730.08k 0 123.41k 6.35k 38.40k 18.22k 329.68
# Time range 2010-09-28 05:54:30 to 2010-09-29 04:00:47
# bytes 25.16k 134 2.45k 224.03 381.65 239.90 130.47
# Profile
# Rank Query ID Response time Calls R/Call Item
# ==== ================== ================ ===== ======== ================
# 1 0x5C552C534D2A3440 1114.2297 48.0% 17 65.5429 SELECT t3
# 2 0xD9C2EFCBECC526D1 549.2743 23.6% 73 7.5243 SELECT t2
# 3 0x0255F509DADB6455 457.1587 19.7% 9 50.7954 UPDATE t1
• オプションはドットファイルに書いておける
• t3 テーブルへのクエリが非常に遅い