151
151
# 10s+ ################################################################
154
# Query 5: 0 QPS, 0x concurrency, ID 0xED69B13F3D0161D0 at byte 2479 _____
154
# Query 5: 0 QPS, 0x concurrency, ID 0x79BFEA84D0CED05F at byte 1889 _____
156
# Time range: all events occurred at 2007-12-07 12:02:53
157
# Attribute pct total min max avg 95% stddev median
158
# ============ === ======= ======= ======= ======= ======= ======= =======
160
# Exec time 16 20661s 20661s 20661s 20661s 20661s 0 20661s
161
# Query size 24 341 341 341 341 341 0 341
162
# error code 0 0 0 0 0 0 0 0
165
# Query_time distribution
173
# 10s+ ################################################################
175
# SHOW TABLE STATUS FROM `test1` LIKE 'tbl6'\G
176
# SHOW CREATE TABLE `test1`.`tbl6`\G
177
insert into test1.tbl6
178
(day, tbl5, misccol9type, misccol9, metric11, metric12, secs)
180
(convert_tz(current_timestamp,'EST5EDT','PST8PDT'), '239', 'foo', 'bar', 1, '1', '16.3574378490448')
181
on duplicate key update metric11 = metric11 + 1,
182
metric12 = metric12 + values(metric12), secs = secs + values(secs)\G
184
# Query 6: 0 QPS, 0x concurrency, ID 0xED69B13F3D0161D0 at byte 2479 _____
155
185
# Scores: V/M = 0.00
156
186
# Time range: all events occurred at 2007-12-07 12:02:53
157
187
# Attribute pct total min max avg 95% stddev median
185
215
last1metric1 = last0metric1, last1time = last0time,
186
216
last0metric1 = ondeckmetric1, last0time = now() from test2.tbl8 where tbl8 in (10800712)\G
188
# Query 6: 0 QPS, 0x concurrency, ID 0x79BFEA84D0CED05F at byte 1889 _____
190
# Time range: all events occurred at 2007-12-07 12:02:53
191
# Attribute pct total min max avg 95% stddev median
192
# ============ === ======= ======= ======= ======= ======= ======= =======
194
# Exec time 16 20661s 20661s 20661s 20661s 20661s 0 20661s
195
# Query size 24 341 341 341 341 341 0 341
196
# error code 0 0 0 0 0 0 0 0
199
# Query_time distribution
207
# 10s+ ################################################################
209
# SHOW TABLE STATUS FROM `test1` LIKE 'tbl6'\G
210
# SHOW CREATE TABLE `test1`.`tbl6`\G
211
insert into test1.tbl6
212
(day, tbl5, misccol9type, misccol9, metric11, metric12, secs)
214
(convert_tz(current_timestamp,'EST5EDT','PST8PDT'), '239', 'foo', 'bar', 1, '1', '16.3574378490448')
215
on duplicate key update metric11 = metric11 + 1,
216
metric12 = metric12 + values(metric12), secs = secs + values(secs)\G
219
219
# Rank Query ID Response time Calls R/Call V/M Item
220
220
# ==== ================== ================ ===== ========== ===== ========
222
222
# 2 0xC356FD9EFD7D799E 20675.0000 16.7% 1 20675.0000 0.00 UPDATE test?.tblo test?.tbl?
223
223
# 3 0xB5E55291C7DE1096 20664.0000 16.7% 1 20664.0000 0.00 UPDATE test?.tblo test?.tbl?
224
224
# 4 0x85FFF5AA78E5FF6A 20664.0000 16.7% 1 20664.0000 0.00 BEGIN
225
# 5 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?
226
# 6 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
225
# 5 0x79BFEA84D0CED05F 20661.0000 16.7% 1 20661.0000 0.00 INSERT UPDATE test?.tbl?
226
# 6 0xED69B13F3D0161D0 20661.0000 16.7% 1 20661.0000 0.00 UPDATE test?.tbl?