1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
|
# Query 1: 0 QPS, 0x concurrency, ID 0xA5C90AEFB6734628ABE9508269335CD1 at byte 1866
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-08-05 13:00:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 1
# Exec time 98 1349s 1349s 1349s 1349s 1349s 0 1349s
# Lock time 99 1349s 1349s 1349s 1349s 1349s 0 1349s
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 99 1.84M 1.84M 1.84M 1.84M 1.84M 0 1.84M
# Merge passes 0 0 0 0 0 0 0 0
# Query size 16 40 40 40 40 40 0 40
# Boolean:
# Filesort 100% yes, 0% no
# Filesort on 100% yes, 0% no
# Full scan 100% yes, 0% no
# Tmp table 100% yes, 0% no
# Tmp table on 100% yes, 0% no
# String:
# Databases db3
# Lock_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+ ################################################################
# Tables
# SHOW TABLE STATUS FROM `db3` LIKE 'forest'\G
# SHOW CREATE TABLE `db3`.`forest`\G
DELETE FROM forest WHERE animal = 'dead'\G
# Converted for EXPLAIN
# EXPLAIN /*!50100 PARTITIONS*/
select * from forest WHERE animal = 'dead'\G
# Query 2: 0.00 QPS, 0.00x concurrency, ID 0x7023AEC64FE3598DAC1BF726F2AB10C5 at byte 934
# Scores: V/M = 0.03
# Time range: 2009-08-05 11:00:27 to 13:00:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 44 4
# Exec time 0 3s 526ms 926ms 726ms 900ms 141ms 705ms
# Lock time 0 334ms 37ms 100ms 84ms 95ms 26ms 95ms
# Rows sent 3 33 7 9 8.25 8.91 0.83 8.91
# Rows examine 0 152 50 51 50.67 49.17 0 49.17
# Merge passes 0 0 0 0 0 0 0 0
# Query size 27 68 17 17 17 17 0 17
# Boolean:
# Full scan 100% yes, 0% no
# QC Hit 25% yes, 75% no
# String:
# Databases db1 (2/50%), db3 (2/50%)
# Lock_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms #####################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `db1` LIKE 'foo'\G
# SHOW CREATE TABLE `db1`.`foo`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT * FROM foo\G
# Query 3: 0 QPS, 0x concurrency, ID 0x937677F741B37EAFB79802214165F670 at byte 1267
# Scores: V/M = 0.73
# Time range: all events occurred at 2009-08-05 12:00:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 22 2
# Exec time 0 726ms 52us 726ms 363ms 726ms 513ms 363ms
# Lock time 0 110ms 10ms 100ms 55ms 100ms 64ms 55ms
# Rows sent 0 0 0 0 0 0 0 0
# Rows examine 0 0 0 0 0 0 0 0
# Merge passes 0 0 0 0 0 0 0 0
# Query size 27 66 33 33 33 33 0 33
# Boolean:
# Full scan 100% yes, 0% no
# String:
# Databases db2
# Lock_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms ################################################################
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `db2` LIKE 'tbl'\G
# SHOW CREATE TABLE `db2`.`tbl`\G
INSERT INTO tbl VALUES ('a', 'b')\G
# Query 4: 0 QPS, 0x concurrency, ID 0x181E5BEE0A9CD8C01F9B2F47A843D460 at byte 333
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-08-05 11:00:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 1
# Exec time 0 2s 2s 2s 2s 2s 0 2s
# Lock time 0 10ms 10ms 10ms 10ms 10ms 0 10ms
# Rows sent 0 1 1 1 1 1 0 1
# Rows examine 0 1 1 1 1 1 0 1
# Merge passes 0 0 0 0 0 0 0 0
# Query size 12 31 31 31 31 31 0 31
# String:
# Databases db1
# Lock_time distribution
# 1us
# 10us
# 100us
# 1ms
# 10ms ################################################################
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `db1` LIKE 'tbl'\G
# SHOW CREATE TABLE `db1`.`tbl`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT id FROM tbl WHERE id = 1\G
# Query 5: 0 QPS, 0x concurrency, ID 0xFBC6FB7F8360D37D3F1024B96D9D469E at byte 625
# Scores: V/M = 0.00
# Time range: all events occurred at 2009-08-05 11:00:27
# Attribute pct total min max avg 95% stddev median
# ============ === ======= ======= ======= ======= ======= ======= =======
# Count 11 1
# Exec time 0 9s 9s 9s 9s 9s 0 9s
# Lock time 0 1us 1us 1us 1us 1us 0 1us
# Rows sent 96 900 900 900 900 900 0 900
# Rows examine 0 9.77k 9.77k 9.77k 9.77k 9.77k 0 9.77k
# Merge passes 100 1 1 1 1 1 0 1
# Query size 15 39 39 39 39 39 0 39
# Boolean:
# Filesort on 100% yes, 0% no
# Full scan 100% yes, 0% no
# Tmp table 100% yes, 0% no
# String:
# Databases db1
# Lock_time distribution
# 1us ################################################################
# 10us
# 100us
# 1ms
# 10ms
# 100ms
# 1s
# 10s+
# Tables
# SHOW TABLE STATUS FROM `db1` LIKE 'blah'\G
# SHOW CREATE TABLE `db1`.`blah`\G
# EXPLAIN /*!50100 PARTITIONS*/
SELECT COUNT(*) FROM blah WHERE col > 2\G
# Profile
# Rank Query ID Response time Calls R/Call
# ==== ================================== =============== ===== =========
# 1 0xA5C90AEFB6734628ABE9508269335CD1 1349.0001 98.9% 1 1349.0001 0.00 DELETE forest
# 2 0x7023AEC64FE3598DAC1BF726F2AB10C5 2.9042 0.2% 4 0.7261 0.03 SELECT foo
# 3 0x937677F741B37EAFB79802214165F670 0.7261 0.1% 2 0.3631 0.73 INSERT tbl
# 4 0x181E5BEE0A9CD8C01F9B2F47A843D460 1.7261 0.1% 1 1.7261 0.00 SELECT tbl
# 5 0xFBC6FB7F8360D37D3F1024B96D9D469E 9.0001 0.7% 1 9.0001 0.00 SELECT blah
|
