Debian Codegraph @

mysql-test/suite/perfschema/r/table_aggregate_hist_4u_3t.result

raw
1 select * from performance_schema.setup_actors
2 order by USER, HOST, `ROLE`;
3 HOST USER ROLE ENABLED HISTORY
4 localhost user1 % YES YES
5 localhost user2 % YES YES
6 localhost user3 % YES YES
7 localhost user4 % YES YES
8 select * from performance_schema.setup_objects
9 order by object_type, object_schema, object_name;
10 OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED
11 TABLE test t1 YES YES
12 TABLE test t2 YES NO
13 TABLE test t3 YES NO
14 select * from performance_schema.setup_consumers;
15 NAME ENABLED
16 events_stages_current YES
17 events_stages_history YES
18 events_stages_history_long YES
19 events_statements_cpu YES
20 events_statements_current YES
21 events_statements_history YES
22 events_statements_history_long YES
23 events_transactions_current YES
24 events_transactions_history YES
25 events_transactions_history_long YES
26 events_waits_current YES
27 events_waits_history YES
28 events_waits_history_long YES
29 global_instrumentation YES
30 thread_instrumentation YES
31 statements_digest YES
32 flush tables;
33 truncate performance_schema.objects_summary_global_by_type;
34 truncate performance_schema.table_io_waits_summary_by_index_usage;
35 truncate performance_schema.table_io_waits_summary_by_table;
36 truncate performance_schema.table_lock_waits_summary_by_table;
37 truncate performance_schema.events_waits_summary_by_thread_by_event_name;
38 truncate performance_schema.events_waits_summary_by_account_by_event_name;
39 truncate performance_schema.events_waits_summary_by_user_by_event_name;
40 truncate performance_schema.events_waits_summary_by_host_by_event_name;
41 truncate performance_schema.events_waits_summary_global_by_event_name;
42 truncate performance_schema.events_waits_history_long;
43 show global variables like "performance_schema%table%";
44 Variable_name Value
45 performance_schema_max_table_handles -1
46 performance_schema_max_table_instances -1
47 performance_schema_max_table_lock_stat -1
48 show global status like "performance_schema%table%_lost";
49 Variable_name Value
50 Performance_schema_table_handles_lost 0
51 Performance_schema_table_instances_lost 0
52 Performance_schema_table_lock_stat_lost 0
53 "================== Step 1 =================="
54 call dump_thread();
55 username status
56 user1 not found
57 username status
58 user2 not found
59 username status
60 user3 not found
61 username status
62 user4 not found
63 execute dump_waits_account;
64 user host event_name count_star
65 execute dump_waits_user;
66 user event_name count_star
67 execute dump_waits_host;
68 host event_name count_star
69 localhost wait/io/table/sql/handler 0
70 localhost wait/lock/table/sql/handler 0
71 execute dump_waits_global;
72 event_name count_star
73 wait/io/table/sql/handler 0
74 wait/lock/table/sql/handler 0
75 execute dump_waits_history;
76 event_name count(event_name) object_type object_schema object_name
77 execute dump_waits_index_io;
78 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
79 TABLE test t1 index_b 0 0 0 0 0 0 0
80 TABLE test t1 index_cb 0 0 0 0 0 0 0
81 TABLE test t1 PRIMARY 0 0 0 0 0 0 0
82 TABLE test t2 index_b 0 0 0 0 0 0 0
83 TABLE test t2 index_cb 0 0 0 0 0 0 0
84 TABLE test t2 PRIMARY 0 0 0 0 0 0 0
85 TABLE test t3 index_b 0 0 0 0 0 0 0
86 TABLE test t3 index_cb 0 0 0 0 0 0 0
87 TABLE test t3 PRIMARY 0 0 0 0 0 0 0
88 execute dump_waits_table_io;
89 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
90 TABLE test t1 0 0 0 0 0 0 0
91 TABLE test t2 0 0 0 0 0 0 0
92 TABLE test t3 0 0 0 0 0 0 0
93 execute dump_waits_table_lock;
94 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
95 TABLE test t1 0 0 0 0 0 0 0 0 0 0
96 TABLE test t2 0 0 0 0 0 0 0 0 0 0
97 TABLE test t3 0 0 0 0 0 0 0 0 0 0
98 execute dump_objects_summary;
99 object_type object_schema object_name count_star
100 TABLE test t1 0
101 TABLE test t2 0
102 TABLE test t3 0
103 select concat(current_user(), " is connected") as status;
104 status
105 user1@localhost is connected
106 "================== Step 2 =================="
107 call dump_thread();
108 username event_name count_star
109 user1 wait/io/table/sql/handler 0
110 user1 wait/lock/table/sql/handler 0
111 username status
112 user2 not found
113 username status
114 user3 not found
115 username status
116 user4 not found
117 execute dump_waits_account;
118 user host event_name count_star
119 user1 localhost wait/io/table/sql/handler 0
120 user1 localhost wait/lock/table/sql/handler 0
121 execute dump_waits_user;
122 user event_name count_star
123 user1 wait/io/table/sql/handler 0
124 user1 wait/lock/table/sql/handler 0
125 execute dump_waits_host;
126 host event_name count_star
127 localhost wait/io/table/sql/handler 0
128 localhost wait/lock/table/sql/handler 0
129 execute dump_waits_global;
130 event_name count_star
131 wait/io/table/sql/handler 0
132 wait/lock/table/sql/handler 0
133 execute dump_waits_history;
134 event_name count(event_name) object_type object_schema object_name
135 execute dump_waits_index_io;
136 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
137 TABLE test t1 index_b 0 0 0 0 0 0 0
138 TABLE test t1 index_cb 0 0 0 0 0 0 0
139 TABLE test t1 PRIMARY 0 0 0 0 0 0 0
140 TABLE test t2 index_b 0 0 0 0 0 0 0
141 TABLE test t2 index_cb 0 0 0 0 0 0 0
142 TABLE test t2 PRIMARY 0 0 0 0 0 0 0
143 TABLE test t3 index_b 0 0 0 0 0 0 0
144 TABLE test t3 index_cb 0 0 0 0 0 0 0
145 TABLE test t3 PRIMARY 0 0 0 0 0 0 0
146 execute dump_waits_table_io;
147 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
148 TABLE test t1 0 0 0 0 0 0 0
149 TABLE test t2 0 0 0 0 0 0 0
150 TABLE test t3 0 0 0 0 0 0 0
151 execute dump_waits_table_lock;
152 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
153 TABLE test t1 0 0 0 0 0 0 0 0 0 0
154 TABLE test t2 0 0 0 0 0 0 0 0 0 0
155 TABLE test t3 0 0 0 0 0 0 0 0 0 0
156 execute dump_objects_summary;
157 object_type object_schema object_name count_star
158 TABLE test t1 0
159 TABLE test t2 0
160 TABLE test t3 0
161 insert into test.t1 set a=101, b=1, c=1;
162 insert into test.t2 set a=102, b=2, c=2;
163 insert into test.t2 set a=103, b=3, c=3;
164 insert into test.t3 set a=104, b=4, c=4;
165 insert into test.t3 set a=105, b=5, c=5;
166 insert into test.t3 set a=106, b=6, c=6;
167 select * from test.t1;
168 a b c d
169 101 1 1 0
170 select * from test.t2;
171 a b c d
172 102 2 2 0
173 103 3 3 0
174 select * from test.t3;
175 a b c d
176 104 4 4 0
177 105 5 5 0
178 106 6 6 0
179 update test.t1 set d=d+1;
180 update test.t2 set d=d+1;
181 update test.t3 set d=d+1;
182 update test.t1 set d=d+1 where a=101;
183 update test.t2 set d=d+1 where a=101;
184 update test.t3 set d=d+1 where a=101;
185 select * from test.t1 force index(index_b) where b=5;
186 a b c d
187 select * from test.t2 force index(index_b) where b=5;
188 a b c d
189 select * from test.t3 force index(index_b) where b=5;
190 a b c d
191 105 5 5 1
192 "================== con1 marker =================="
193 "================== Step 3-A =================="
194 call dump_thread();
195 username event_name count_star
196 user1 wait/io/table/sql/handler 34
197 user1 wait/lock/table/sql/handler 18
198 username status
199 user2 not found
200 username status
201 user3 not found
202 username status
203 user4 not found
204 execute dump_waits_account;
205 user host event_name count_star
206 user1 localhost wait/io/table/sql/handler 34
207 user1 localhost wait/lock/table/sql/handler 18
208 execute dump_waits_user;
209 user event_name count_star
210 user1 wait/io/table/sql/handler 34
211 user1 wait/lock/table/sql/handler 18
212 execute dump_waits_host;
213 host event_name count_star
214 localhost wait/io/table/sql/handler 34
215 localhost wait/lock/table/sql/handler 18
216 execute dump_waits_global;
217 event_name count_star
218 wait/io/table/sql/handler 34
219 wait/lock/table/sql/handler 18
220 execute dump_waits_history;
221 event_name count(event_name) object_type object_schema object_name
222 wait/io/table/sql/handler 8 TABLE test t1
223 wait/lock/table/sql/handler 5 TABLE test t1
224 wait/io/table/sql/handler 11 TABLE test t2
225 wait/lock/table/sql/handler 6 TABLE test t2
226 wait/io/table/sql/handler 15 TABLE test t3
227 wait/lock/table/sql/handler 7 TABLE test t3
228 execute dump_waits_index_io;
229 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
230 TABLE test t1 NULL 4 3 1 3 1 0 0
231 TABLE test t1 index_b 1 1 0 1 0 0 0
232 TABLE test t1 index_cb 0 0 0 0 0 0 0
233 TABLE test t1 PRIMARY 3 1 2 1 0 2 0
234 TABLE test t2 NULL 7 5 2 5 2 0 0
235 TABLE test t2 index_b 1 1 0 1 0 0 0
236 TABLE test t2 index_cb 0 0 0 0 0 0 0
237 TABLE test t2 PRIMARY 3 1 2 1 0 2 0
238 TABLE test t3 NULL 10 7 3 7 3 0 0
239 TABLE test t3 index_b 1 1 0 1 0 0 0
240 TABLE test t3 index_cb 0 0 0 0 0 0 0
241 TABLE test t3 PRIMARY 4 1 3 1 0 3 0
242 execute dump_waits_table_io;
243 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
244 TABLE test t1 8 5 3 5 1 2 0
245 TABLE test t2 11 7 4 7 2 2 0
246 TABLE test t3 15 9 6 9 3 3 0
247 execute dump_waits_table_lock;
248 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
249 TABLE test t1 5 2 3 0 0 0 0 2 0 3
250 TABLE test t2 6 2 4 0 0 0 0 2 0 4
251 TABLE test t3 7 2 5 0 0 0 0 2 0 5
252 execute dump_objects_summary;
253 object_type object_schema object_name count_star
254 TABLE test t1 13
255 TABLE test t2 17
256 TABLE test t3 22
257 flush tables;
258 "================== con1 FLUSH =================="
259 "================== Step 3-B =================="
260 call dump_thread();
261 username event_name count_star
262 user1 wait/io/table/sql/handler 34
263 user1 wait/lock/table/sql/handler 18
264 username status
265 user2 not found
266 username status
267 user3 not found
268 username status
269 user4 not found
270 execute dump_waits_account;
271 user host event_name count_star
272 user1 localhost wait/io/table/sql/handler 34
273 user1 localhost wait/lock/table/sql/handler 18
274 execute dump_waits_user;
275 user event_name count_star
276 user1 wait/io/table/sql/handler 34
277 user1 wait/lock/table/sql/handler 18
278 execute dump_waits_host;
279 host event_name count_star
280 localhost wait/io/table/sql/handler 34
281 localhost wait/lock/table/sql/handler 18
282 execute dump_waits_global;
283 event_name count_star
284 wait/io/table/sql/handler 34
285 wait/lock/table/sql/handler 18
286 execute dump_waits_history;
287 event_name count(event_name) object_type object_schema object_name
288 wait/io/table/sql/handler 8 TABLE test t1
289 wait/lock/table/sql/handler 5 TABLE test t1
290 wait/io/table/sql/handler 11 TABLE test t2
291 wait/lock/table/sql/handler 6 TABLE test t2
292 wait/io/table/sql/handler 15 TABLE test t3
293 wait/lock/table/sql/handler 7 TABLE test t3
294 execute dump_waits_index_io;
295 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
296 TABLE test t1 NULL 4 3 1 3 1 0 0
297 TABLE test t1 index_b 1 1 0 1 0 0 0
298 TABLE test t1 index_cb 0 0 0 0 0 0 0
299 TABLE test t1 PRIMARY 3 1 2 1 0 2 0
300 TABLE test t2 NULL 7 5 2 5 2 0 0
301 TABLE test t2 index_b 1 1 0 1 0 0 0
302 TABLE test t2 index_cb 0 0 0 0 0 0 0
303 TABLE test t2 PRIMARY 3 1 2 1 0 2 0
304 TABLE test t3 NULL 10 7 3 7 3 0 0
305 TABLE test t3 index_b 1 1 0 1 0 0 0
306 TABLE test t3 index_cb 0 0 0 0 0 0 0
307 TABLE test t3 PRIMARY 4 1 3 1 0 3 0
308 execute dump_waits_table_io;
309 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
310 TABLE test t1 8 5 3 5 1 2 0
311 TABLE test t2 11 7 4 7 2 2 0
312 TABLE test t3 15 9 6 9 3 3 0
313 execute dump_waits_table_lock;
314 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
315 TABLE test t1 5 2 3 0 0 0 0 2 0 3
316 TABLE test t2 6 2 4 0 0 0 0 2 0 4
317 TABLE test t3 7 2 5 0 0 0 0 2 0 5
318 execute dump_objects_summary;
319 object_type object_schema object_name count_star
320 TABLE test t1 13
321 TABLE test t2 17
322 TABLE test t3 22
323 select concat(current_user(), " is connected") as status;
324 status
325 user2@localhost is connected
326 "================== Step 4 =================="
327 call dump_thread();
328 username event_name count_star
329 user1 wait/io/table/sql/handler 34
330 user1 wait/lock/table/sql/handler 18
331 username event_name count_star
332 user2 wait/io/table/sql/handler 0
333 user2 wait/lock/table/sql/handler 0
334 username status
335 user3 not found
336 username status
337 user4 not found
338 execute dump_waits_account;
339 user host event_name count_star
340 user1 localhost wait/io/table/sql/handler 34
341 user1 localhost wait/lock/table/sql/handler 18
342 user2 localhost wait/io/table/sql/handler 0
343 user2 localhost wait/lock/table/sql/handler 0
344 execute dump_waits_user;
345 user event_name count_star
346 user1 wait/io/table/sql/handler 34
347 user1 wait/lock/table/sql/handler 18
348 user2 wait/io/table/sql/handler 0
349 user2 wait/lock/table/sql/handler 0
350 execute dump_waits_host;
351 host event_name count_star
352 localhost wait/io/table/sql/handler 34
353 localhost wait/lock/table/sql/handler 18
354 execute dump_waits_global;
355 event_name count_star
356 wait/io/table/sql/handler 34
357 wait/lock/table/sql/handler 18
358 execute dump_waits_history;
359 event_name count(event_name) object_type object_schema object_name
360 wait/io/table/sql/handler 8 TABLE test t1
361 wait/lock/table/sql/handler 5 TABLE test t1
362 wait/io/table/sql/handler 11 TABLE test t2
363 wait/lock/table/sql/handler 6 TABLE test t2
364 wait/io/table/sql/handler 15 TABLE test t3
365 wait/lock/table/sql/handler 7 TABLE test t3
366 execute dump_waits_index_io;
367 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
368 TABLE test t1 NULL 4 3 1 3 1 0 0
369 TABLE test t1 index_b 1 1 0 1 0 0 0
370 TABLE test t1 index_cb 0 0 0 0 0 0 0
371 TABLE test t1 PRIMARY 3 1 2 1 0 2 0
372 TABLE test t2 NULL 7 5 2 5 2 0 0
373 TABLE test t2 index_b 1 1 0 1 0 0 0
374 TABLE test t2 index_cb 0 0 0 0 0 0 0
375 TABLE test t2 PRIMARY 3 1 2 1 0 2 0
376 TABLE test t3 NULL 10 7 3 7 3 0 0
377 TABLE test t3 index_b 1 1 0 1 0 0 0
378 TABLE test t3 index_cb 0 0 0 0 0 0 0
379 TABLE test t3 PRIMARY 4 1 3 1 0 3 0
380 execute dump_waits_table_io;
381 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
382 TABLE test t1 8 5 3 5 1 2 0
383 TABLE test t2 11 7 4 7 2 2 0
384 TABLE test t3 15 9 6 9 3 3 0
385 execute dump_waits_table_lock;
386 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
387 TABLE test t1 5 2 3 0 0 0 0 2 0 3
388 TABLE test t2 6 2 4 0 0 0 0 2 0 4
389 TABLE test t3 7 2 5 0 0 0 0 2 0 5
390 execute dump_objects_summary;
391 object_type object_schema object_name count_star
392 TABLE test t1 13
393 TABLE test t2 17
394 TABLE test t3 22
395 insert into test.t1 set a=201, b=1, c=1;
396 insert into test.t2 set a=202, b=2, c=2;
397 insert into test.t2 set a=203, b=3, c=3;
398 insert into test.t3 set a=204, b=4, c=4;
399 insert into test.t3 set a=205, b=5, c=5;
400 insert into test.t3 set a=206, b=6, c=6;
401 select * from test.t1;
402 a b c d
403 101 1 1 2
404 201 1 1 0
405 select * from test.t2;
406 a b c d
407 102 2 2 1
408 103 3 3 1
409 202 2 2 0
410 203 3 3 0
411 select * from test.t3;
412 a b c d
413 104 4 4 1
414 105 5 5 1
415 106 6 6 1
416 204 4 4 0
417 205 5 5 0
418 206 6 6 0
419 update test.t1 set d=d+1;
420 update test.t2 set d=d+1;
421 update test.t3 set d=d+1;
422 update test.t1 set d=d+1 where a=201;
423 update test.t2 set d=d+1 where a=201;
424 update test.t3 set d=d+1 where a=201;
425 select * from test.t1 force index(index_b) where b=5;
426 a b c d
427 select * from test.t2 force index(index_b) where b=5;
428 a b c d
429 select * from test.t3 force index(index_b) where b=5;
430 a b c d
431 105 5 5 2
432 205 5 5 1
433 "================== con2 marker =================="
434 "================== Step 5 =================="
435 call dump_thread();
436 username event_name count_star
437 user1 wait/io/table/sql/handler 34
438 user1 wait/lock/table/sql/handler 18
439 username event_name count_star
440 user2 wait/io/table/sql/handler 53
441 user2 wait/lock/table/sql/handler 18
442 username status
443 user3 not found
444 username status
445 user4 not found
446 execute dump_waits_account;
447 user host event_name count_star
448 user1 localhost wait/io/table/sql/handler 34
449 user1 localhost wait/lock/table/sql/handler 18
450 user2 localhost wait/io/table/sql/handler 53
451 user2 localhost wait/lock/table/sql/handler 18
452 execute dump_waits_user;
453 user event_name count_star
454 user1 wait/io/table/sql/handler 34
455 user1 wait/lock/table/sql/handler 18
456 user2 wait/io/table/sql/handler 53
457 user2 wait/lock/table/sql/handler 18
458 execute dump_waits_host;
459 host event_name count_star
460 localhost wait/io/table/sql/handler 87
461 localhost wait/lock/table/sql/handler 36
462 execute dump_waits_global;
463 event_name count_star
464 wait/io/table/sql/handler 87
465 wait/lock/table/sql/handler 36
466 execute dump_waits_history;
467 event_name count(event_name) object_type object_schema object_name
468 wait/io/table/sql/handler 19 TABLE test t1
469 wait/lock/table/sql/handler 10 TABLE test t1
470 wait/io/table/sql/handler 28 TABLE test t2
471 wait/lock/table/sql/handler 12 TABLE test t2
472 wait/io/table/sql/handler 40 TABLE test t3
473 wait/lock/table/sql/handler 14 TABLE test t3
474 execute dump_waits_index_io;
475 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
476 TABLE test t1 NULL 10 8 2 8 2 0 0
477 TABLE test t1 index_b 2 2 0 2 0 0 0
478 TABLE test t1 index_cb 0 0 0 0 0 0 0
479 TABLE test t1 PRIMARY 7 2 5 2 0 5 0
480 TABLE test t2 NULL 18 14 4 14 4 0 0
481 TABLE test t2 index_b 2 2 0 2 0 0 0
482 TABLE test t2 index_cb 0 0 0 0 0 0 0
483 TABLE test t2 PRIMARY 8 2 6 2 0 6 0
484 TABLE test t3 NULL 26 20 6 20 6 0 0
485 TABLE test t3 index_b 3 3 0 3 0 0 0
486 TABLE test t3 index_cb 0 0 0 0 0 0 0
487 TABLE test t3 PRIMARY 11 2 9 2 0 9 0
488 execute dump_waits_table_io;
489 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
490 TABLE test t1 19 12 7 12 2 5 0
491 TABLE test t2 28 18 10 18 4 6 0
492 TABLE test t3 40 25 15 25 6 9 0
493 execute dump_waits_table_lock;
494 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
495 TABLE test t1 10 4 6 0 0 0 0 4 0 6
496 TABLE test t2 12 4 8 0 0 0 0 4 0 8
497 TABLE test t3 14 4 10 0 0 0 0 4 0 10
498 execute dump_objects_summary;
499 object_type object_schema object_name count_star
500 TABLE test t1 29
501 TABLE test t2 40
502 TABLE test t3 54
503 select concat(current_user(), " is connected") as status;
504 status
505 user3@localhost is connected
506 "================== Step 6 =================="
507 call dump_thread();
508 username event_name count_star
509 user1 wait/io/table/sql/handler 34
510 user1 wait/lock/table/sql/handler 18
511 username event_name count_star
512 user2 wait/io/table/sql/handler 53
513 user2 wait/lock/table/sql/handler 18
514 username event_name count_star
515 user3 wait/io/table/sql/handler 0
516 user3 wait/lock/table/sql/handler 0
517 username status
518 user4 not found
519 execute dump_waits_account;
520 user host event_name count_star
521 user1 localhost wait/io/table/sql/handler 34
522 user1 localhost wait/lock/table/sql/handler 18
523 user2 localhost wait/io/table/sql/handler 53
524 user2 localhost wait/lock/table/sql/handler 18
525 user3 localhost wait/io/table/sql/handler 0
526 user3 localhost wait/lock/table/sql/handler 0
527 execute dump_waits_user;
528 user event_name count_star
529 user1 wait/io/table/sql/handler 34
530 user1 wait/lock/table/sql/handler 18
531 user2 wait/io/table/sql/handler 53
532 user2 wait/lock/table/sql/handler 18
533 user3 wait/io/table/sql/handler 0
534 user3 wait/lock/table/sql/handler 0
535 execute dump_waits_host;
536 host event_name count_star
537 localhost wait/io/table/sql/handler 87
538 localhost wait/lock/table/sql/handler 36
539 execute dump_waits_global;
540 event_name count_star
541 wait/io/table/sql/handler 87
542 wait/lock/table/sql/handler 36
543 execute dump_waits_history;
544 event_name count(event_name) object_type object_schema object_name
545 wait/io/table/sql/handler 19 TABLE test t1
546 wait/lock/table/sql/handler 10 TABLE test t1
547 wait/io/table/sql/handler 28 TABLE test t2
548 wait/lock/table/sql/handler 12 TABLE test t2
549 wait/io/table/sql/handler 40 TABLE test t3
550 wait/lock/table/sql/handler 14 TABLE test t3
551 execute dump_waits_index_io;
552 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
553 TABLE test t1 NULL 10 8 2 8 2 0 0
554 TABLE test t1 index_b 2 2 0 2 0 0 0
555 TABLE test t1 index_cb 0 0 0 0 0 0 0
556 TABLE test t1 PRIMARY 7 2 5 2 0 5 0
557 TABLE test t2 NULL 18 14 4 14 4 0 0
558 TABLE test t2 index_b 2 2 0 2 0 0 0
559 TABLE test t2 index_cb 0 0 0 0 0 0 0
560 TABLE test t2 PRIMARY 8 2 6 2 0 6 0
561 TABLE test t3 NULL 26 20 6 20 6 0 0
562 TABLE test t3 index_b 3 3 0 3 0 0 0
563 TABLE test t3 index_cb 0 0 0 0 0 0 0
564 TABLE test t3 PRIMARY 11 2 9 2 0 9 0
565 execute dump_waits_table_io;
566 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
567 TABLE test t1 19 12 7 12 2 5 0
568 TABLE test t2 28 18 10 18 4 6 0
569 TABLE test t3 40 25 15 25 6 9 0
570 execute dump_waits_table_lock;
571 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
572 TABLE test t1 10 4 6 0 0 0 0 4 0 6
573 TABLE test t2 12 4 8 0 0 0 0 4 0 8
574 TABLE test t3 14 4 10 0 0 0 0 4 0 10
575 execute dump_objects_summary;
576 object_type object_schema object_name count_star
577 TABLE test t1 29
578 TABLE test t2 40
579 TABLE test t3 54
580 insert into test.t1 set a=301, b=1, c=1;
581 insert into test.t2 set a=302, b=2, c=2;
582 insert into test.t2 set a=303, b=3, c=3;
583 insert into test.t3 set a=304, b=4, c=4;
584 insert into test.t3 set a=305, b=5, c=5;
585 insert into test.t3 set a=306, b=6, c=6;
586 select * from test.t1;
587 a b c d
588 101 1 1 3
589 201 1 1 2
590 301 1 1 0
591 select * from test.t2;
592 a b c d
593 102 2 2 2
594 103 3 3 2
595 202 2 2 1
596 203 3 3 1
597 302 2 2 0
598 303 3 3 0
599 select * from test.t3;
600 a b c d
601 104 4 4 2
602 105 5 5 2
603 106 6 6 2
604 204 4 4 1
605 205 5 5 1
606 206 6 6 1
607 304 4 4 0
608 305 5 5 0
609 306 6 6 0
610 update test.t1 set d=d+1;
611 update test.t2 set d=d+1;
612 update test.t3 set d=d+1;
613 update test.t1 set d=d+1 where a=301;
614 update test.t2 set d=d+1 where a=301;
615 update test.t3 set d=d+1 where a=301;
616 select * from test.t1 force index(index_b) where b=5;
617 a b c d
618 select * from test.t2 force index(index_b) where b=5;
619 a b c d
620 select * from test.t3 force index(index_b) where b=5;
621 a b c d
622 105 5 5 3
623 205 5 5 2
624 305 5 5 1
625 "================== con3 marker =================="
626 "================== Step 7 =================="
627 call dump_thread();
628 username event_name count_star
629 user1 wait/io/table/sql/handler 34
630 user1 wait/lock/table/sql/handler 18
631 username event_name count_star
632 user2 wait/io/table/sql/handler 53
633 user2 wait/lock/table/sql/handler 18
634 username event_name count_star
635 user3 wait/io/table/sql/handler 72
636 user3 wait/lock/table/sql/handler 18
637 username status
638 user4 not found
639 execute dump_waits_account;
640 user host event_name count_star
641 user1 localhost wait/io/table/sql/handler 34
642 user1 localhost wait/lock/table/sql/handler 18
643 user2 localhost wait/io/table/sql/handler 53
644 user2 localhost wait/lock/table/sql/handler 18
645 user3 localhost wait/io/table/sql/handler 72
646 user3 localhost wait/lock/table/sql/handler 18
647 execute dump_waits_user;
648 user event_name count_star
649 user1 wait/io/table/sql/handler 34
650 user1 wait/lock/table/sql/handler 18
651 user2 wait/io/table/sql/handler 53
652 user2 wait/lock/table/sql/handler 18
653 user3 wait/io/table/sql/handler 72
654 user3 wait/lock/table/sql/handler 18
655 execute dump_waits_host;
656 host event_name count_star
657 localhost wait/io/table/sql/handler 159
658 localhost wait/lock/table/sql/handler 54
659 execute dump_waits_global;
660 event_name count_star
661 wait/io/table/sql/handler 159
662 wait/lock/table/sql/handler 54
663 execute dump_waits_history;
664 event_name count(event_name) object_type object_schema object_name
665 wait/io/table/sql/handler 33 TABLE test t1
666 wait/lock/table/sql/handler 15 TABLE test t1
667 wait/io/table/sql/handler 51 TABLE test t2
668 wait/lock/table/sql/handler 18 TABLE test t2
669 wait/io/table/sql/handler 75 TABLE test t3
670 wait/lock/table/sql/handler 21 TABLE test t3
671 execute dump_waits_index_io;
672 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
673 TABLE test t1 NULL 18 15 3 15 3 0 0
674 TABLE test t1 index_b 3 3 0 3 0 0 0
675 TABLE test t1 index_cb 0 0 0 0 0 0 0
676 TABLE test t1 PRIMARY 12 3 9 3 0 9 0
677 TABLE test t2 NULL 33 27 6 27 6 0 0
678 TABLE test t2 index_b 3 3 0 3 0 0 0
679 TABLE test t2 index_cb 0 0 0 0 0 0 0
680 TABLE test t2 PRIMARY 15 3 12 3 0 12 0
681 TABLE test t3 NULL 48 39 9 39 9 0 0
682 TABLE test t3 index_b 6 6 0 6 0 0 0
683 TABLE test t3 index_cb 0 0 0 0 0 0 0
684 TABLE test t3 PRIMARY 21 3 18 3 0 18 0
685 execute dump_waits_table_io;
686 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
687 TABLE test t1 33 21 12 21 3 9 0
688 TABLE test t2 51 33 18 33 6 12 0
689 TABLE test t3 75 48 27 48 9 18 0
690 execute dump_waits_table_lock;
691 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
692 TABLE test t1 15 6 9 0 0 0 0 6 0 9
693 TABLE test t2 18 6 12 0 0 0 0 6 0 12
694 TABLE test t3 21 6 15 0 0 0 0 6 0 15
695 execute dump_objects_summary;
696 object_type object_schema object_name count_star
697 TABLE test t1 48
698 TABLE test t2 69
699 TABLE test t3 96
700 select concat(current_user(), " is connected") as status;
701 status
702 user4@localhost is connected
703 "================== Step 8 =================="
704 call dump_thread();
705 username event_name count_star
706 user1 wait/io/table/sql/handler 34
707 user1 wait/lock/table/sql/handler 18
708 username event_name count_star
709 user2 wait/io/table/sql/handler 53
710 user2 wait/lock/table/sql/handler 18
711 username event_name count_star
712 user3 wait/io/table/sql/handler 72
713 user3 wait/lock/table/sql/handler 18
714 username event_name count_star
715 user4 wait/io/table/sql/handler 0
716 user4 wait/lock/table/sql/handler 0
717 execute dump_waits_account;
718 user host event_name count_star
719 user1 localhost wait/io/table/sql/handler 34
720 user1 localhost wait/lock/table/sql/handler 18
721 user2 localhost wait/io/table/sql/handler 53
722 user2 localhost wait/lock/table/sql/handler 18
723 user3 localhost wait/io/table/sql/handler 72
724 user3 localhost wait/lock/table/sql/handler 18
725 user4 localhost wait/io/table/sql/handler 0
726 user4 localhost wait/lock/table/sql/handler 0
727 execute dump_waits_user;
728 user event_name count_star
729 user1 wait/io/table/sql/handler 34
730 user1 wait/lock/table/sql/handler 18
731 user2 wait/io/table/sql/handler 53
732 user2 wait/lock/table/sql/handler 18
733 user3 wait/io/table/sql/handler 72
734 user3 wait/lock/table/sql/handler 18
735 user4 wait/io/table/sql/handler 0
736 user4 wait/lock/table/sql/handler 0
737 execute dump_waits_host;
738 host event_name count_star
739 localhost wait/io/table/sql/handler 159
740 localhost wait/lock/table/sql/handler 54
741 execute dump_waits_global;
742 event_name count_star
743 wait/io/table/sql/handler 159
744 wait/lock/table/sql/handler 54
745 execute dump_waits_history;
746 event_name count(event_name) object_type object_schema object_name
747 wait/io/table/sql/handler 33 TABLE test t1
748 wait/lock/table/sql/handler 15 TABLE test t1
749 wait/io/table/sql/handler 51 TABLE test t2
750 wait/lock/table/sql/handler 18 TABLE test t2
751 wait/io/table/sql/handler 75 TABLE test t3
752 wait/lock/table/sql/handler 21 TABLE test t3
753 execute dump_waits_index_io;
754 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
755 TABLE test t1 NULL 18 15 3 15 3 0 0
756 TABLE test t1 index_b 3 3 0 3 0 0 0
757 TABLE test t1 index_cb 0 0 0 0 0 0 0
758 TABLE test t1 PRIMARY 12 3 9 3 0 9 0
759 TABLE test t2 NULL 33 27 6 27 6 0 0
760 TABLE test t2 index_b 3 3 0 3 0 0 0
761 TABLE test t2 index_cb 0 0 0 0 0 0 0
762 TABLE test t2 PRIMARY 15 3 12 3 0 12 0
763 TABLE test t3 NULL 48 39 9 39 9 0 0
764 TABLE test t3 index_b 6 6 0 6 0 0 0
765 TABLE test t3 index_cb 0 0 0 0 0 0 0
766 TABLE test t3 PRIMARY 21 3 18 3 0 18 0
767 execute dump_waits_table_io;
768 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
769 TABLE test t1 33 21 12 21 3 9 0
770 TABLE test t2 51 33 18 33 6 12 0
771 TABLE test t3 75 48 27 48 9 18 0
772 execute dump_waits_table_lock;
773 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
774 TABLE test t1 15 6 9 0 0 0 0 6 0 9
775 TABLE test t2 18 6 12 0 0 0 0 6 0 12
776 TABLE test t3 21 6 15 0 0 0 0 6 0 15
777 execute dump_objects_summary;
778 object_type object_schema object_name count_star
779 TABLE test t1 48
780 TABLE test t2 69
781 TABLE test t3 96
782 insert into test.t1 set a=401, b=1, c=1;
783 insert into test.t2 set a=402, b=2, c=2;
784 insert into test.t2 set a=403, b=3, c=3;
785 insert into test.t3 set a=404, b=4, c=4;
786 insert into test.t3 set a=405, b=5, c=5;
787 insert into test.t3 set a=406, b=6, c=6;
788 select * from test.t1;
789 a b c d
790 101 1 1 4
791 201 1 1 3
792 301 1 1 2
793 401 1 1 0
794 select * from test.t2;
795 a b c d
796 102 2 2 3
797 103 3 3 3
798 202 2 2 2
799 203 3 3 2
800 302 2 2 1
801 303 3 3 1
802 402 2 2 0
803 403 3 3 0
804 select * from test.t3;
805 a b c d
806 104 4 4 3
807 105 5 5 3
808 106 6 6 3
809 204 4 4 2
810 205 5 5 2
811 206 6 6 2
812 304 4 4 1
813 305 5 5 1
814 306 6 6 1
815 404 4 4 0
816 405 5 5 0
817 406 6 6 0
818 update test.t1 set d=d+1;
819 update test.t2 set d=d+1;
820 update test.t3 set d=d+1;
821 update test.t1 set d=d+1 where a=401;
822 update test.t2 set d=d+1 where a=401;
823 update test.t3 set d=d+1 where a=401;
824 select * from test.t1 force index(index_b) where b=5;
825 a b c d
826 select * from test.t2 force index(index_b) where b=5;
827 a b c d
828 select * from test.t3 force index(index_b) where b=5;
829 a b c d
830 105 5 5 4
831 205 5 5 3
832 305 5 5 2
833 405 5 5 1
834 "================== con4 marker =================="
835 "================== Step 9 =================="
836 call dump_thread();
837 username event_name count_star
838 user1 wait/io/table/sql/handler 34
839 user1 wait/lock/table/sql/handler 18
840 username event_name count_star
841 user2 wait/io/table/sql/handler 53
842 user2 wait/lock/table/sql/handler 18
843 username event_name count_star
844 user3 wait/io/table/sql/handler 72
845 user3 wait/lock/table/sql/handler 18
846 username event_name count_star
847 user4 wait/io/table/sql/handler 91
848 user4 wait/lock/table/sql/handler 18
849 execute dump_waits_account;
850 user host event_name count_star
851 user1 localhost wait/io/table/sql/handler 34
852 user1 localhost wait/lock/table/sql/handler 18
853 user2 localhost wait/io/table/sql/handler 53
854 user2 localhost wait/lock/table/sql/handler 18
855 user3 localhost wait/io/table/sql/handler 72
856 user3 localhost wait/lock/table/sql/handler 18
857 user4 localhost wait/io/table/sql/handler 91
858 user4 localhost wait/lock/table/sql/handler 18
859 execute dump_waits_user;
860 user event_name count_star
861 user1 wait/io/table/sql/handler 34
862 user1 wait/lock/table/sql/handler 18
863 user2 wait/io/table/sql/handler 53
864 user2 wait/lock/table/sql/handler 18
865 user3 wait/io/table/sql/handler 72
866 user3 wait/lock/table/sql/handler 18
867 user4 wait/io/table/sql/handler 91
868 user4 wait/lock/table/sql/handler 18
869 execute dump_waits_host;
870 host event_name count_star
871 localhost wait/io/table/sql/handler 250
872 localhost wait/lock/table/sql/handler 72
873 execute dump_waits_global;
874 event_name count_star
875 wait/io/table/sql/handler 250
876 wait/lock/table/sql/handler 72
877 execute dump_waits_history;
878 event_name count(event_name) object_type object_schema object_name
879 wait/io/table/sql/handler 50 TABLE test t1
880 wait/lock/table/sql/handler 20 TABLE test t1
881 wait/io/table/sql/handler 80 TABLE test t2
882 wait/lock/table/sql/handler 24 TABLE test t2
883 wait/io/table/sql/handler 120 TABLE test t3
884 wait/lock/table/sql/handler 28 TABLE test t3
885 execute dump_waits_index_io;
886 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
887 TABLE test t1 NULL 28 24 4 24 4 0 0
888 TABLE test t1 index_b 4 4 0 4 0 0 0
889 TABLE test t1 index_cb 0 0 0 0 0 0 0
890 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
891 TABLE test t2 NULL 52 44 8 44 8 0 0
892 TABLE test t2 index_b 4 4 0 4 0 0 0
893 TABLE test t2 index_cb 0 0 0 0 0 0 0
894 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
895 TABLE test t3 NULL 76 64 12 64 12 0 0
896 TABLE test t3 index_b 10 10 0 10 0 0 0
897 TABLE test t3 index_cb 0 0 0 0 0 0 0
898 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
899 execute dump_waits_table_io;
900 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
901 TABLE test t1 50 32 18 32 4 14 0
902 TABLE test t2 80 52 28 52 8 20 0
903 TABLE test t3 120 78 42 78 12 30 0
904 execute dump_waits_table_lock;
905 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
906 TABLE test t1 20 8 12 0 0 0 0 8 0 12
907 TABLE test t2 24 8 16 0 0 0 0 8 0 16
908 TABLE test t3 28 8 20 0 0 0 0 8 0 20
909 execute dump_objects_summary;
910 object_type object_schema object_name count_star
911 TABLE test t1 70
912 TABLE test t2 104
913 TABLE test t3 148
914 lock tables test.t1 read, test.t2 read, test.t3 read;
915 unlock tables;
916 lock tables test.t1 write, test.t2 write, test.t3 write;
917 unlock tables;
918 "================== con1 marker =================="
919 "================== Step 10 =================="
920 call dump_thread();
921 username event_name count_star
922 user1 wait/io/table/sql/handler 34
923 user1 wait/lock/table/sql/handler 24
924 username event_name count_star
925 user2 wait/io/table/sql/handler 53
926 user2 wait/lock/table/sql/handler 18
927 username event_name count_star
928 user3 wait/io/table/sql/handler 72
929 user3 wait/lock/table/sql/handler 18
930 username event_name count_star
931 user4 wait/io/table/sql/handler 91
932 user4 wait/lock/table/sql/handler 18
933 execute dump_waits_account;
934 user host event_name count_star
935 user1 localhost wait/io/table/sql/handler 34
936 user1 localhost wait/lock/table/sql/handler 24
937 user2 localhost wait/io/table/sql/handler 53
938 user2 localhost wait/lock/table/sql/handler 18
939 user3 localhost wait/io/table/sql/handler 72
940 user3 localhost wait/lock/table/sql/handler 18
941 user4 localhost wait/io/table/sql/handler 91
942 user4 localhost wait/lock/table/sql/handler 18
943 execute dump_waits_user;
944 user event_name count_star
945 user1 wait/io/table/sql/handler 34
946 user1 wait/lock/table/sql/handler 24
947 user2 wait/io/table/sql/handler 53
948 user2 wait/lock/table/sql/handler 18
949 user3 wait/io/table/sql/handler 72
950 user3 wait/lock/table/sql/handler 18
951 user4 wait/io/table/sql/handler 91
952 user4 wait/lock/table/sql/handler 18
953 execute dump_waits_host;
954 host event_name count_star
955 localhost wait/io/table/sql/handler 250
956 localhost wait/lock/table/sql/handler 78
957 execute dump_waits_global;
958 event_name count_star
959 wait/io/table/sql/handler 250
960 wait/lock/table/sql/handler 78
961 execute dump_waits_history;
962 event_name count(event_name) object_type object_schema object_name
963 wait/io/table/sql/handler 50 TABLE test t1
964 wait/lock/table/sql/handler 22 TABLE test t1
965 wait/io/table/sql/handler 80 TABLE test t2
966 wait/lock/table/sql/handler 26 TABLE test t2
967 wait/io/table/sql/handler 120 TABLE test t3
968 wait/lock/table/sql/handler 30 TABLE test t3
969 execute dump_waits_index_io;
970 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
971 TABLE test t1 NULL 28 24 4 24 4 0 0
972 TABLE test t1 index_b 4 4 0 4 0 0 0
973 TABLE test t1 index_cb 0 0 0 0 0 0 0
974 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
975 TABLE test t2 NULL 52 44 8 44 8 0 0
976 TABLE test t2 index_b 4 4 0 4 0 0 0
977 TABLE test t2 index_cb 0 0 0 0 0 0 0
978 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
979 TABLE test t3 NULL 76 64 12 64 12 0 0
980 TABLE test t3 index_b 10 10 0 10 0 0 0
981 TABLE test t3 index_cb 0 0 0 0 0 0 0
982 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
983 execute dump_waits_table_io;
984 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
985 TABLE test t1 50 32 18 32 4 14 0
986 TABLE test t2 80 52 28 52 8 20 0
987 TABLE test t3 120 78 42 78 12 30 0
988 execute dump_waits_table_lock;
989 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
990 TABLE test t1 22 9 13 0 0 0 0 9 0 13
991 TABLE test t2 26 9 17 0 0 0 0 9 0 17
992 TABLE test t3 30 9 21 0 0 0 0 9 0 21
993 execute dump_objects_summary;
994 object_type object_schema object_name count_star
995 TABLE test t1 72
996 TABLE test t2 106
997 TABLE test t3 150
998 flush tables;
999 "================== flush marker =================="
1000 "================== Step 11 =================="
1001 call dump_thread();
1002 username event_name count_star
1003 user1 wait/io/table/sql/handler 34
1004 user1 wait/lock/table/sql/handler 24
1005 username event_name count_star
1006 user2 wait/io/table/sql/handler 53
1007 user2 wait/lock/table/sql/handler 18
1008 username event_name count_star
1009 user3 wait/io/table/sql/handler 72
1010 user3 wait/lock/table/sql/handler 18
1011 username event_name count_star
1012 user4 wait/io/table/sql/handler 91
1013 user4 wait/lock/table/sql/handler 18
1014 execute dump_waits_account;
1015 user host event_name count_star
1016 user1 localhost wait/io/table/sql/handler 34
1017 user1 localhost wait/lock/table/sql/handler 24
1018 user2 localhost wait/io/table/sql/handler 53
1019 user2 localhost wait/lock/table/sql/handler 18
1020 user3 localhost wait/io/table/sql/handler 72
1021 user3 localhost wait/lock/table/sql/handler 18
1022 user4 localhost wait/io/table/sql/handler 91
1023 user4 localhost wait/lock/table/sql/handler 18
1024 execute dump_waits_user;
1025 user event_name count_star
1026 user1 wait/io/table/sql/handler 34
1027 user1 wait/lock/table/sql/handler 24
1028 user2 wait/io/table/sql/handler 53
1029 user2 wait/lock/table/sql/handler 18
1030 user3 wait/io/table/sql/handler 72
1031 user3 wait/lock/table/sql/handler 18
1032 user4 wait/io/table/sql/handler 91
1033 user4 wait/lock/table/sql/handler 18
1034 execute dump_waits_host;
1035 host event_name count_star
1036 localhost wait/io/table/sql/handler 250
1037 localhost wait/lock/table/sql/handler 78
1038 execute dump_waits_global;
1039 event_name count_star
1040 wait/io/table/sql/handler 250
1041 wait/lock/table/sql/handler 78
1042 execute dump_waits_history;
1043 event_name count(event_name) object_type object_schema object_name
1044 wait/io/table/sql/handler 50 TABLE test t1
1045 wait/lock/table/sql/handler 22 TABLE test t1
1046 wait/io/table/sql/handler 80 TABLE test t2
1047 wait/lock/table/sql/handler 26 TABLE test t2
1048 wait/io/table/sql/handler 120 TABLE test t3
1049 wait/lock/table/sql/handler 30 TABLE test t3
1050 execute dump_waits_index_io;
1051 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1052 TABLE test t1 NULL 28 24 4 24 4 0 0
1053 TABLE test t1 index_b 4 4 0 4 0 0 0
1054 TABLE test t1 index_cb 0 0 0 0 0 0 0
1055 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1056 TABLE test t2 NULL 52 44 8 44 8 0 0
1057 TABLE test t2 index_b 4 4 0 4 0 0 0
1058 TABLE test t2 index_cb 0 0 0 0 0 0 0
1059 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1060 TABLE test t3 NULL 76 64 12 64 12 0 0
1061 TABLE test t3 index_b 10 10 0 10 0 0 0
1062 TABLE test t3 index_cb 0 0 0 0 0 0 0
1063 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1064 execute dump_waits_table_io;
1065 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1066 TABLE test t1 50 32 18 32 4 14 0
1067 TABLE test t2 80 52 28 52 8 20 0
1068 TABLE test t3 120 78 42 78 12 30 0
1069 execute dump_waits_table_lock;
1070 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1071 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1072 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1073 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1074 execute dump_objects_summary;
1075 object_type object_schema object_name count_star
1076 TABLE test t1 72
1077 TABLE test t2 106
1078 TABLE test t3 150
1079 set global read_only=1;
1080 set global read_only=0;
1081 "================== global read_only marker =================="
1082 "================== Step 12 =================="
1083 call dump_thread();
1084 username event_name count_star
1085 user1 wait/io/table/sql/handler 34
1086 user1 wait/lock/table/sql/handler 24
1087 username event_name count_star
1088 user2 wait/io/table/sql/handler 53
1089 user2 wait/lock/table/sql/handler 18
1090 username event_name count_star
1091 user3 wait/io/table/sql/handler 72
1092 user3 wait/lock/table/sql/handler 18
1093 username event_name count_star
1094 user4 wait/io/table/sql/handler 91
1095 user4 wait/lock/table/sql/handler 18
1096 execute dump_waits_account;
1097 user host event_name count_star
1098 user1 localhost wait/io/table/sql/handler 34
1099 user1 localhost wait/lock/table/sql/handler 24
1100 user2 localhost wait/io/table/sql/handler 53
1101 user2 localhost wait/lock/table/sql/handler 18
1102 user3 localhost wait/io/table/sql/handler 72
1103 user3 localhost wait/lock/table/sql/handler 18
1104 user4 localhost wait/io/table/sql/handler 91
1105 user4 localhost wait/lock/table/sql/handler 18
1106 execute dump_waits_user;
1107 user event_name count_star
1108 user1 wait/io/table/sql/handler 34
1109 user1 wait/lock/table/sql/handler 24
1110 user2 wait/io/table/sql/handler 53
1111 user2 wait/lock/table/sql/handler 18
1112 user3 wait/io/table/sql/handler 72
1113 user3 wait/lock/table/sql/handler 18
1114 user4 wait/io/table/sql/handler 91
1115 user4 wait/lock/table/sql/handler 18
1116 execute dump_waits_host;
1117 host event_name count_star
1118 localhost wait/io/table/sql/handler 250
1119 localhost wait/lock/table/sql/handler 78
1120 execute dump_waits_global;
1121 event_name count_star
1122 wait/io/table/sql/handler 250
1123 wait/lock/table/sql/handler 78
1124 execute dump_waits_history;
1125 event_name count(event_name) object_type object_schema object_name
1126 wait/io/table/sql/handler 50 TABLE test t1
1127 wait/lock/table/sql/handler 22 TABLE test t1
1128 wait/io/table/sql/handler 80 TABLE test t2
1129 wait/lock/table/sql/handler 26 TABLE test t2
1130 wait/io/table/sql/handler 120 TABLE test t3
1131 wait/lock/table/sql/handler 30 TABLE test t3
1132 execute dump_waits_index_io;
1133 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1134 TABLE test t1 NULL 28 24 4 24 4 0 0
1135 TABLE test t1 index_b 4 4 0 4 0 0 0
1136 TABLE test t1 index_cb 0 0 0 0 0 0 0
1137 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1138 TABLE test t2 NULL 52 44 8 44 8 0 0
1139 TABLE test t2 index_b 4 4 0 4 0 0 0
1140 TABLE test t2 index_cb 0 0 0 0 0 0 0
1141 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1142 TABLE test t3 NULL 76 64 12 64 12 0 0
1143 TABLE test t3 index_b 10 10 0 10 0 0 0
1144 TABLE test t3 index_cb 0 0 0 0 0 0 0
1145 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1146 execute dump_waits_table_io;
1147 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1148 TABLE test t1 50 32 18 32 4 14 0
1149 TABLE test t2 80 52 28 52 8 20 0
1150 TABLE test t3 120 78 42 78 12 30 0
1151 execute dump_waits_table_lock;
1152 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1153 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1154 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1155 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1156 execute dump_objects_summary;
1157 object_type object_schema object_name count_star
1158 TABLE test t1 72
1159 TABLE test t2 106
1160 TABLE test t3 150
1161 "================== con1 disconnected =================="
1162 "================== Step 13 =================="
1163 call dump_thread();
1164 username status
1165 user1 not found
1166 username event_name count_star
1167 user2 wait/io/table/sql/handler 53
1168 user2 wait/lock/table/sql/handler 18
1169 username event_name count_star
1170 user3 wait/io/table/sql/handler 72
1171 user3 wait/lock/table/sql/handler 18
1172 username event_name count_star
1173 user4 wait/io/table/sql/handler 91
1174 user4 wait/lock/table/sql/handler 18
1175 execute dump_waits_account;
1176 user host event_name count_star
1177 user1 localhost wait/io/table/sql/handler 34
1178 user1 localhost wait/lock/table/sql/handler 24
1179 user2 localhost wait/io/table/sql/handler 53
1180 user2 localhost wait/lock/table/sql/handler 18
1181 user3 localhost wait/io/table/sql/handler 72
1182 user3 localhost wait/lock/table/sql/handler 18
1183 user4 localhost wait/io/table/sql/handler 91
1184 user4 localhost wait/lock/table/sql/handler 18
1185 execute dump_waits_user;
1186 user event_name count_star
1187 user1 wait/io/table/sql/handler 34
1188 user1 wait/lock/table/sql/handler 24
1189 user2 wait/io/table/sql/handler 53
1190 user2 wait/lock/table/sql/handler 18
1191 user3 wait/io/table/sql/handler 72
1192 user3 wait/lock/table/sql/handler 18
1193 user4 wait/io/table/sql/handler 91
1194 user4 wait/lock/table/sql/handler 18
1195 execute dump_waits_host;
1196 host event_name count_star
1197 localhost wait/io/table/sql/handler 250
1198 localhost wait/lock/table/sql/handler 78
1199 execute dump_waits_global;
1200 event_name count_star
1201 wait/io/table/sql/handler 250
1202 wait/lock/table/sql/handler 78
1203 execute dump_waits_history;
1204 event_name count(event_name) object_type object_schema object_name
1205 wait/io/table/sql/handler 50 TABLE test t1
1206 wait/lock/table/sql/handler 22 TABLE test t1
1207 wait/io/table/sql/handler 80 TABLE test t2
1208 wait/lock/table/sql/handler 26 TABLE test t2
1209 wait/io/table/sql/handler 120 TABLE test t3
1210 wait/lock/table/sql/handler 30 TABLE test t3
1211 execute dump_waits_index_io;
1212 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1213 TABLE test t1 NULL 28 24 4 24 4 0 0
1214 TABLE test t1 index_b 4 4 0 4 0 0 0
1215 TABLE test t1 index_cb 0 0 0 0 0 0 0
1216 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1217 TABLE test t2 NULL 52 44 8 44 8 0 0
1218 TABLE test t2 index_b 4 4 0 4 0 0 0
1219 TABLE test t2 index_cb 0 0 0 0 0 0 0
1220 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1221 TABLE test t3 NULL 76 64 12 64 12 0 0
1222 TABLE test t3 index_b 10 10 0 10 0 0 0
1223 TABLE test t3 index_cb 0 0 0 0 0 0 0
1224 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1225 execute dump_waits_table_io;
1226 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1227 TABLE test t1 50 32 18 32 4 14 0
1228 TABLE test t2 80 52 28 52 8 20 0
1229 TABLE test t3 120 78 42 78 12 30 0
1230 execute dump_waits_table_lock;
1231 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1232 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1233 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1234 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1235 execute dump_objects_summary;
1236 object_type object_schema object_name count_star
1237 TABLE test t1 72
1238 TABLE test t2 106
1239 TABLE test t3 150
1240 "================== con2 disconnected =================="
1241 "================== Step 14 =================="
1242 call dump_thread();
1243 username status
1244 user1 not found
1245 username status
1246 user2 not found
1247 username event_name count_star
1248 user3 wait/io/table/sql/handler 72
1249 user3 wait/lock/table/sql/handler 18
1250 username event_name count_star
1251 user4 wait/io/table/sql/handler 91
1252 user4 wait/lock/table/sql/handler 18
1253 execute dump_waits_account;
1254 user host event_name count_star
1255 user1 localhost wait/io/table/sql/handler 34
1256 user1 localhost wait/lock/table/sql/handler 24
1257 user2 localhost wait/io/table/sql/handler 53
1258 user2 localhost wait/lock/table/sql/handler 18
1259 user3 localhost wait/io/table/sql/handler 72
1260 user3 localhost wait/lock/table/sql/handler 18
1261 user4 localhost wait/io/table/sql/handler 91
1262 user4 localhost wait/lock/table/sql/handler 18
1263 execute dump_waits_user;
1264 user event_name count_star
1265 user1 wait/io/table/sql/handler 34
1266 user1 wait/lock/table/sql/handler 24
1267 user2 wait/io/table/sql/handler 53
1268 user2 wait/lock/table/sql/handler 18
1269 user3 wait/io/table/sql/handler 72
1270 user3 wait/lock/table/sql/handler 18
1271 user4 wait/io/table/sql/handler 91
1272 user4 wait/lock/table/sql/handler 18
1273 execute dump_waits_host;
1274 host event_name count_star
1275 localhost wait/io/table/sql/handler 250
1276 localhost wait/lock/table/sql/handler 78
1277 execute dump_waits_global;
1278 event_name count_star
1279 wait/io/table/sql/handler 250
1280 wait/lock/table/sql/handler 78
1281 execute dump_waits_history;
1282 event_name count(event_name) object_type object_schema object_name
1283 wait/io/table/sql/handler 50 TABLE test t1
1284 wait/lock/table/sql/handler 22 TABLE test t1
1285 wait/io/table/sql/handler 80 TABLE test t2
1286 wait/lock/table/sql/handler 26 TABLE test t2
1287 wait/io/table/sql/handler 120 TABLE test t3
1288 wait/lock/table/sql/handler 30 TABLE test t3
1289 execute dump_waits_index_io;
1290 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1291 TABLE test t1 NULL 28 24 4 24 4 0 0
1292 TABLE test t1 index_b 4 4 0 4 0 0 0
1293 TABLE test t1 index_cb 0 0 0 0 0 0 0
1294 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1295 TABLE test t2 NULL 52 44 8 44 8 0 0
1296 TABLE test t2 index_b 4 4 0 4 0 0 0
1297 TABLE test t2 index_cb 0 0 0 0 0 0 0
1298 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1299 TABLE test t3 NULL 76 64 12 64 12 0 0
1300 TABLE test t3 index_b 10 10 0 10 0 0 0
1301 TABLE test t3 index_cb 0 0 0 0 0 0 0
1302 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1303 execute dump_waits_table_io;
1304 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1305 TABLE test t1 50 32 18 32 4 14 0
1306 TABLE test t2 80 52 28 52 8 20 0
1307 TABLE test t3 120 78 42 78 12 30 0
1308 execute dump_waits_table_lock;
1309 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1310 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1311 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1312 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1313 execute dump_objects_summary;
1314 object_type object_schema object_name count_star
1315 TABLE test t1 72
1316 TABLE test t2 106
1317 TABLE test t3 150
1318 "================== con3 disconnected =================="
1319 "================== Step 15 =================="
1320 call dump_thread();
1321 username status
1322 user1 not found
1323 username status
1324 user2 not found
1325 username status
1326 user3 not found
1327 username event_name count_star
1328 user4 wait/io/table/sql/handler 91
1329 user4 wait/lock/table/sql/handler 18
1330 execute dump_waits_account;
1331 user host event_name count_star
1332 user1 localhost wait/io/table/sql/handler 34
1333 user1 localhost wait/lock/table/sql/handler 24
1334 user2 localhost wait/io/table/sql/handler 53
1335 user2 localhost wait/lock/table/sql/handler 18
1336 user3 localhost wait/io/table/sql/handler 72
1337 user3 localhost wait/lock/table/sql/handler 18
1338 user4 localhost wait/io/table/sql/handler 91
1339 user4 localhost wait/lock/table/sql/handler 18
1340 execute dump_waits_user;
1341 user event_name count_star
1342 user1 wait/io/table/sql/handler 34
1343 user1 wait/lock/table/sql/handler 24
1344 user2 wait/io/table/sql/handler 53
1345 user2 wait/lock/table/sql/handler 18
1346 user3 wait/io/table/sql/handler 72
1347 user3 wait/lock/table/sql/handler 18
1348 user4 wait/io/table/sql/handler 91
1349 user4 wait/lock/table/sql/handler 18
1350 execute dump_waits_host;
1351 host event_name count_star
1352 localhost wait/io/table/sql/handler 250
1353 localhost wait/lock/table/sql/handler 78
1354 execute dump_waits_global;
1355 event_name count_star
1356 wait/io/table/sql/handler 250
1357 wait/lock/table/sql/handler 78
1358 execute dump_waits_history;
1359 event_name count(event_name) object_type object_schema object_name
1360 wait/io/table/sql/handler 50 TABLE test t1
1361 wait/lock/table/sql/handler 22 TABLE test t1
1362 wait/io/table/sql/handler 80 TABLE test t2
1363 wait/lock/table/sql/handler 26 TABLE test t2
1364 wait/io/table/sql/handler 120 TABLE test t3
1365 wait/lock/table/sql/handler 30 TABLE test t3
1366 execute dump_waits_index_io;
1367 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1368 TABLE test t1 NULL 28 24 4 24 4 0 0
1369 TABLE test t1 index_b 4 4 0 4 0 0 0
1370 TABLE test t1 index_cb 0 0 0 0 0 0 0
1371 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1372 TABLE test t2 NULL 52 44 8 44 8 0 0
1373 TABLE test t2 index_b 4 4 0 4 0 0 0
1374 TABLE test t2 index_cb 0 0 0 0 0 0 0
1375 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1376 TABLE test t3 NULL 76 64 12 64 12 0 0
1377 TABLE test t3 index_b 10 10 0 10 0 0 0
1378 TABLE test t3 index_cb 0 0 0 0 0 0 0
1379 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1380 execute dump_waits_table_io;
1381 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1382 TABLE test t1 50 32 18 32 4 14 0
1383 TABLE test t2 80 52 28 52 8 20 0
1384 TABLE test t3 120 78 42 78 12 30 0
1385 execute dump_waits_table_lock;
1386 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1387 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1388 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1389 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1390 execute dump_objects_summary;
1391 object_type object_schema object_name count_star
1392 TABLE test t1 72
1393 TABLE test t2 106
1394 TABLE test t3 150
1395 "================== con4 disconnected =================="
1396 "================== Step 16 =================="
1397 call dump_thread();
1398 username status
1399 user1 not found
1400 username status
1401 user2 not found
1402 username status
1403 user3 not found
1404 username status
1405 user4 not found
1406 execute dump_waits_account;
1407 user host event_name count_star
1408 user1 localhost wait/io/table/sql/handler 34
1409 user1 localhost wait/lock/table/sql/handler 24
1410 user2 localhost wait/io/table/sql/handler 53
1411 user2 localhost wait/lock/table/sql/handler 18
1412 user3 localhost wait/io/table/sql/handler 72
1413 user3 localhost wait/lock/table/sql/handler 18
1414 user4 localhost wait/io/table/sql/handler 91
1415 user4 localhost wait/lock/table/sql/handler 18
1416 execute dump_waits_user;
1417 user event_name count_star
1418 user1 wait/io/table/sql/handler 34
1419 user1 wait/lock/table/sql/handler 24
1420 user2 wait/io/table/sql/handler 53
1421 user2 wait/lock/table/sql/handler 18
1422 user3 wait/io/table/sql/handler 72
1423 user3 wait/lock/table/sql/handler 18
1424 user4 wait/io/table/sql/handler 91
1425 user4 wait/lock/table/sql/handler 18
1426 execute dump_waits_host;
1427 host event_name count_star
1428 localhost wait/io/table/sql/handler 250
1429 localhost wait/lock/table/sql/handler 78
1430 execute dump_waits_global;
1431 event_name count_star
1432 wait/io/table/sql/handler 250
1433 wait/lock/table/sql/handler 78
1434 execute dump_waits_history;
1435 event_name count(event_name) object_type object_schema object_name
1436 wait/io/table/sql/handler 50 TABLE test t1
1437 wait/lock/table/sql/handler 22 TABLE test t1
1438 wait/io/table/sql/handler 80 TABLE test t2
1439 wait/lock/table/sql/handler 26 TABLE test t2
1440 wait/io/table/sql/handler 120 TABLE test t3
1441 wait/lock/table/sql/handler 30 TABLE test t3
1442 execute dump_waits_index_io;
1443 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1444 TABLE test t1 NULL 28 24 4 24 4 0 0
1445 TABLE test t1 index_b 4 4 0 4 0 0 0
1446 TABLE test t1 index_cb 0 0 0 0 0 0 0
1447 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1448 TABLE test t2 NULL 52 44 8 44 8 0 0
1449 TABLE test t2 index_b 4 4 0 4 0 0 0
1450 TABLE test t2 index_cb 0 0 0 0 0 0 0
1451 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1452 TABLE test t3 NULL 76 64 12 64 12 0 0
1453 TABLE test t3 index_b 10 10 0 10 0 0 0
1454 TABLE test t3 index_cb 0 0 0 0 0 0 0
1455 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1456 execute dump_waits_table_io;
1457 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1458 TABLE test t1 50 32 18 32 4 14 0
1459 TABLE test t2 80 52 28 52 8 20 0
1460 TABLE test t3 120 78 42 78 12 30 0
1461 execute dump_waits_table_lock;
1462 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1463 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1464 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1465 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1466 execute dump_objects_summary;
1467 object_type object_schema object_name count_star
1468 TABLE test t1 72
1469 TABLE test t2 106
1470 TABLE test t3 150
1471 truncate performance_schema.events_waits_summary_by_thread_by_event_name;
1472 "================== BY_THREAD truncated =================="
1473 "================== Step 17 =================="
1474 call dump_thread();
1475 username status
1476 user1 not found
1477 username status
1478 user2 not found
1479 username status
1480 user3 not found
1481 username status
1482 user4 not found
1483 execute dump_waits_account;
1484 user host event_name count_star
1485 user1 localhost wait/io/table/sql/handler 34
1486 user1 localhost wait/lock/table/sql/handler 24
1487 user2 localhost wait/io/table/sql/handler 53
1488 user2 localhost wait/lock/table/sql/handler 18
1489 user3 localhost wait/io/table/sql/handler 72
1490 user3 localhost wait/lock/table/sql/handler 18
1491 user4 localhost wait/io/table/sql/handler 91
1492 user4 localhost wait/lock/table/sql/handler 18
1493 execute dump_waits_user;
1494 user event_name count_star
1495 user1 wait/io/table/sql/handler 34
1496 user1 wait/lock/table/sql/handler 24
1497 user2 wait/io/table/sql/handler 53
1498 user2 wait/lock/table/sql/handler 18
1499 user3 wait/io/table/sql/handler 72
1500 user3 wait/lock/table/sql/handler 18
1501 user4 wait/io/table/sql/handler 91
1502 user4 wait/lock/table/sql/handler 18
1503 execute dump_waits_host;
1504 host event_name count_star
1505 localhost wait/io/table/sql/handler 250
1506 localhost wait/lock/table/sql/handler 78
1507 execute dump_waits_global;
1508 event_name count_star
1509 wait/io/table/sql/handler 250
1510 wait/lock/table/sql/handler 78
1511 execute dump_waits_history;
1512 event_name count(event_name) object_type object_schema object_name
1513 wait/io/table/sql/handler 50 TABLE test t1
1514 wait/lock/table/sql/handler 22 TABLE test t1
1515 wait/io/table/sql/handler 80 TABLE test t2
1516 wait/lock/table/sql/handler 26 TABLE test t2
1517 wait/io/table/sql/handler 120 TABLE test t3
1518 wait/lock/table/sql/handler 30 TABLE test t3
1519 execute dump_waits_index_io;
1520 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1521 TABLE test t1 NULL 28 24 4 24 4 0 0
1522 TABLE test t1 index_b 4 4 0 4 0 0 0
1523 TABLE test t1 index_cb 0 0 0 0 0 0 0
1524 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1525 TABLE test t2 NULL 52 44 8 44 8 0 0
1526 TABLE test t2 index_b 4 4 0 4 0 0 0
1527 TABLE test t2 index_cb 0 0 0 0 0 0 0
1528 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1529 TABLE test t3 NULL 76 64 12 64 12 0 0
1530 TABLE test t3 index_b 10 10 0 10 0 0 0
1531 TABLE test t3 index_cb 0 0 0 0 0 0 0
1532 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1533 execute dump_waits_table_io;
1534 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1535 TABLE test t1 50 32 18 32 4 14 0
1536 TABLE test t2 80 52 28 52 8 20 0
1537 TABLE test t3 120 78 42 78 12 30 0
1538 execute dump_waits_table_lock;
1539 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1540 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1541 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1542 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1543 execute dump_objects_summary;
1544 object_type object_schema object_name count_star
1545 TABLE test t1 72
1546 TABLE test t2 106
1547 TABLE test t3 150
1548 truncate performance_schema.events_waits_summary_by_account_by_event_name;
1549 "================== BY_ACCOUNT truncated =================="
1550 "================== Step 18 =================="
1551 call dump_thread();
1552 username status
1553 user1 not found
1554 username status
1555 user2 not found
1556 username status
1557 user3 not found
1558 username status
1559 user4 not found
1560 execute dump_waits_account;
1561 user host event_name count_star
1562 user1 localhost wait/io/table/sql/handler 0
1563 user1 localhost wait/lock/table/sql/handler 0
1564 user2 localhost wait/io/table/sql/handler 0
1565 user2 localhost wait/lock/table/sql/handler 0
1566 user3 localhost wait/io/table/sql/handler 0
1567 user3 localhost wait/lock/table/sql/handler 0
1568 user4 localhost wait/io/table/sql/handler 0
1569 user4 localhost wait/lock/table/sql/handler 0
1570 execute dump_waits_user;
1571 user event_name count_star
1572 user1 wait/io/table/sql/handler 34
1573 user1 wait/lock/table/sql/handler 24
1574 user2 wait/io/table/sql/handler 53
1575 user2 wait/lock/table/sql/handler 18
1576 user3 wait/io/table/sql/handler 72
1577 user3 wait/lock/table/sql/handler 18
1578 user4 wait/io/table/sql/handler 91
1579 user4 wait/lock/table/sql/handler 18
1580 execute dump_waits_host;
1581 host event_name count_star
1582 localhost wait/io/table/sql/handler 250
1583 localhost wait/lock/table/sql/handler 78
1584 execute dump_waits_global;
1585 event_name count_star
1586 wait/io/table/sql/handler 250
1587 wait/lock/table/sql/handler 78
1588 execute dump_waits_history;
1589 event_name count(event_name) object_type object_schema object_name
1590 wait/io/table/sql/handler 50 TABLE test t1
1591 wait/lock/table/sql/handler 22 TABLE test t1
1592 wait/io/table/sql/handler 80 TABLE test t2
1593 wait/lock/table/sql/handler 26 TABLE test t2
1594 wait/io/table/sql/handler 120 TABLE test t3
1595 wait/lock/table/sql/handler 30 TABLE test t3
1596 execute dump_waits_index_io;
1597 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1598 TABLE test t1 NULL 28 24 4 24 4 0 0
1599 TABLE test t1 index_b 4 4 0 4 0 0 0
1600 TABLE test t1 index_cb 0 0 0 0 0 0 0
1601 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1602 TABLE test t2 NULL 52 44 8 44 8 0 0
1603 TABLE test t2 index_b 4 4 0 4 0 0 0
1604 TABLE test t2 index_cb 0 0 0 0 0 0 0
1605 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1606 TABLE test t3 NULL 76 64 12 64 12 0 0
1607 TABLE test t3 index_b 10 10 0 10 0 0 0
1608 TABLE test t3 index_cb 0 0 0 0 0 0 0
1609 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1610 execute dump_waits_table_io;
1611 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1612 TABLE test t1 50 32 18 32 4 14 0
1613 TABLE test t2 80 52 28 52 8 20 0
1614 TABLE test t3 120 78 42 78 12 30 0
1615 execute dump_waits_table_lock;
1616 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1617 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1618 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1619 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1620 execute dump_objects_summary;
1621 object_type object_schema object_name count_star
1622 TABLE test t1 72
1623 TABLE test t2 106
1624 TABLE test t3 150
1625 truncate performance_schema.events_waits_summary_by_user_by_event_name;
1626 "================== BY_USER truncated =================="
1627 "================== Step 19 =================="
1628 call dump_thread();
1629 username status
1630 user1 not found
1631 username status
1632 user2 not found
1633 username status
1634 user3 not found
1635 username status
1636 user4 not found
1637 execute dump_waits_account;
1638 user host event_name count_star
1639 user1 localhost wait/io/table/sql/handler 0
1640 user1 localhost wait/lock/table/sql/handler 0
1641 user2 localhost wait/io/table/sql/handler 0
1642 user2 localhost wait/lock/table/sql/handler 0
1643 user3 localhost wait/io/table/sql/handler 0
1644 user3 localhost wait/lock/table/sql/handler 0
1645 user4 localhost wait/io/table/sql/handler 0
1646 user4 localhost wait/lock/table/sql/handler 0
1647 execute dump_waits_user;
1648 user event_name count_star
1649 user1 wait/io/table/sql/handler 0
1650 user1 wait/lock/table/sql/handler 0
1651 user2 wait/io/table/sql/handler 0
1652 user2 wait/lock/table/sql/handler 0
1653 user3 wait/io/table/sql/handler 0
1654 user3 wait/lock/table/sql/handler 0
1655 user4 wait/io/table/sql/handler 0
1656 user4 wait/lock/table/sql/handler 0
1657 execute dump_waits_host;
1658 host event_name count_star
1659 localhost wait/io/table/sql/handler 250
1660 localhost wait/lock/table/sql/handler 78
1661 execute dump_waits_global;
1662 event_name count_star
1663 wait/io/table/sql/handler 250
1664 wait/lock/table/sql/handler 78
1665 execute dump_waits_history;
1666 event_name count(event_name) object_type object_schema object_name
1667 wait/io/table/sql/handler 50 TABLE test t1
1668 wait/lock/table/sql/handler 22 TABLE test t1
1669 wait/io/table/sql/handler 80 TABLE test t2
1670 wait/lock/table/sql/handler 26 TABLE test t2
1671 wait/io/table/sql/handler 120 TABLE test t3
1672 wait/lock/table/sql/handler 30 TABLE test t3
1673 execute dump_waits_index_io;
1674 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1675 TABLE test t1 NULL 28 24 4 24 4 0 0
1676 TABLE test t1 index_b 4 4 0 4 0 0 0
1677 TABLE test t1 index_cb 0 0 0 0 0 0 0
1678 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1679 TABLE test t2 NULL 52 44 8 44 8 0 0
1680 TABLE test t2 index_b 4 4 0 4 0 0 0
1681 TABLE test t2 index_cb 0 0 0 0 0 0 0
1682 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1683 TABLE test t3 NULL 76 64 12 64 12 0 0
1684 TABLE test t3 index_b 10 10 0 10 0 0 0
1685 TABLE test t3 index_cb 0 0 0 0 0 0 0
1686 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1687 execute dump_waits_table_io;
1688 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1689 TABLE test t1 50 32 18 32 4 14 0
1690 TABLE test t2 80 52 28 52 8 20 0
1691 TABLE test t3 120 78 42 78 12 30 0
1692 execute dump_waits_table_lock;
1693 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1694 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1695 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1696 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1697 execute dump_objects_summary;
1698 object_type object_schema object_name count_star
1699 TABLE test t1 72
1700 TABLE test t2 106
1701 TABLE test t3 150
1702 truncate performance_schema.events_waits_summary_by_host_by_event_name;
1703 "================== BY_HOST truncated =================="
1704 "================== Step 21 =================="
1705 call dump_thread();
1706 username status
1707 user1 not found
1708 username status
1709 user2 not found
1710 username status
1711 user3 not found
1712 username status
1713 user4 not found
1714 execute dump_waits_account;
1715 user host event_name count_star
1716 user1 localhost wait/io/table/sql/handler 0
1717 user1 localhost wait/lock/table/sql/handler 0
1718 user2 localhost wait/io/table/sql/handler 0
1719 user2 localhost wait/lock/table/sql/handler 0
1720 user3 localhost wait/io/table/sql/handler 0
1721 user3 localhost wait/lock/table/sql/handler 0
1722 user4 localhost wait/io/table/sql/handler 0
1723 user4 localhost wait/lock/table/sql/handler 0
1724 execute dump_waits_user;
1725 user event_name count_star
1726 user1 wait/io/table/sql/handler 0
1727 user1 wait/lock/table/sql/handler 0
1728 user2 wait/io/table/sql/handler 0
1729 user2 wait/lock/table/sql/handler 0
1730 user3 wait/io/table/sql/handler 0
1731 user3 wait/lock/table/sql/handler 0
1732 user4 wait/io/table/sql/handler 0
1733 user4 wait/lock/table/sql/handler 0
1734 execute dump_waits_host;
1735 host event_name count_star
1736 localhost wait/io/table/sql/handler 0
1737 localhost wait/lock/table/sql/handler 0
1738 execute dump_waits_global;
1739 event_name count_star
1740 wait/io/table/sql/handler 250
1741 wait/lock/table/sql/handler 78
1742 execute dump_waits_history;
1743 event_name count(event_name) object_type object_schema object_name
1744 wait/io/table/sql/handler 50 TABLE test t1
1745 wait/lock/table/sql/handler 22 TABLE test t1
1746 wait/io/table/sql/handler 80 TABLE test t2
1747 wait/lock/table/sql/handler 26 TABLE test t2
1748 wait/io/table/sql/handler 120 TABLE test t3
1749 wait/lock/table/sql/handler 30 TABLE test t3
1750 execute dump_waits_index_io;
1751 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1752 TABLE test t1 NULL 28 24 4 24 4 0 0
1753 TABLE test t1 index_b 4 4 0 4 0 0 0
1754 TABLE test t1 index_cb 0 0 0 0 0 0 0
1755 TABLE test t1 PRIMARY 18 4 14 4 0 14 0
1756 TABLE test t2 NULL 52 44 8 44 8 0 0
1757 TABLE test t2 index_b 4 4 0 4 0 0 0
1758 TABLE test t2 index_cb 0 0 0 0 0 0 0
1759 TABLE test t2 PRIMARY 24 4 20 4 0 20 0
1760 TABLE test t3 NULL 76 64 12 64 12 0 0
1761 TABLE test t3 index_b 10 10 0 10 0 0 0
1762 TABLE test t3 index_cb 0 0 0 0 0 0 0
1763 TABLE test t3 PRIMARY 34 4 30 4 0 30 0
1764 execute dump_waits_table_io;
1765 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1766 TABLE test t1 50 32 18 32 4 14 0
1767 TABLE test t2 80 52 28 52 8 20 0
1768 TABLE test t3 120 78 42 78 12 30 0
1769 execute dump_waits_table_lock;
1770 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1771 TABLE test t1 22 9 13 0 0 0 0 9 0 13
1772 TABLE test t2 26 9 17 0 0 0 0 9 0 17
1773 TABLE test t3 30 9 21 0 0 0 0 9 0 21
1774 execute dump_objects_summary;
1775 object_type object_schema object_name count_star
1776 TABLE test t1 72
1777 TABLE test t2 106
1778 TABLE test t3 150
1779 truncate performance_schema.events_waits_summary_global_by_event_name;
1780 "================== GLOBAL truncated =================="
1781 "================== Step 21 =================="
1782 call dump_thread();
1783 username status
1784 user1 not found
1785 username status
1786 user2 not found
1787 username status
1788 user3 not found
1789 username status
1790 user4 not found
1791 execute dump_waits_account;
1792 user host event_name count_star
1793 user1 localhost wait/io/table/sql/handler 0
1794 user1 localhost wait/lock/table/sql/handler 0
1795 user2 localhost wait/io/table/sql/handler 0
1796 user2 localhost wait/lock/table/sql/handler 0
1797 user3 localhost wait/io/table/sql/handler 0
1798 user3 localhost wait/lock/table/sql/handler 0
1799 user4 localhost wait/io/table/sql/handler 0
1800 user4 localhost wait/lock/table/sql/handler 0
1801 execute dump_waits_user;
1802 user event_name count_star
1803 user1 wait/io/table/sql/handler 0
1804 user1 wait/lock/table/sql/handler 0
1805 user2 wait/io/table/sql/handler 0
1806 user2 wait/lock/table/sql/handler 0
1807 user3 wait/io/table/sql/handler 0
1808 user3 wait/lock/table/sql/handler 0
1809 user4 wait/io/table/sql/handler 0
1810 user4 wait/lock/table/sql/handler 0
1811 execute dump_waits_host;
1812 host event_name count_star
1813 localhost wait/io/table/sql/handler 0
1814 localhost wait/lock/table/sql/handler 0
1815 execute dump_waits_global;
1816 event_name count_star
1817 wait/io/table/sql/handler 0
1818 wait/lock/table/sql/handler 0
1819 execute dump_waits_history;
1820 event_name count(event_name) object_type object_schema object_name
1821 wait/io/table/sql/handler 50 TABLE test t1
1822 wait/lock/table/sql/handler 22 TABLE test t1
1823 wait/io/table/sql/handler 80 TABLE test t2
1824 wait/lock/table/sql/handler 26 TABLE test t2
1825 wait/io/table/sql/handler 120 TABLE test t3
1826 wait/lock/table/sql/handler 30 TABLE test t3
1827 execute dump_waits_index_io;
1828 object_type object_schema object_name index_name count_star count_read count_write count_fetch count_insert count_update count_delete
1829 TABLE test t1 NULL 0 0 0 0 0 0 0
1830 TABLE test t1 index_b 0 0 0 0 0 0 0
1831 TABLE test t1 index_cb 0 0 0 0 0 0 0
1832 TABLE test t1 PRIMARY 0 0 0 0 0 0 0
1833 TABLE test t2 NULL 0 0 0 0 0 0 0
1834 TABLE test t2 index_b 0 0 0 0 0 0 0
1835 TABLE test t2 index_cb 0 0 0 0 0 0 0
1836 TABLE test t2 PRIMARY 0 0 0 0 0 0 0
1837 TABLE test t3 NULL 0 0 0 0 0 0 0
1838 TABLE test t3 index_b 0 0 0 0 0 0 0
1839 TABLE test t3 index_cb 0 0 0 0 0 0 0
1840 TABLE test t3 PRIMARY 0 0 0 0 0 0 0
1841 execute dump_waits_table_io;
1842 object_type object_schema object_name count_star count_read count_write count_fetch count_insert count_update count_delete
1843 TABLE test t1 0 0 0 0 0 0 0
1844 TABLE test t2 0 0 0 0 0 0 0
1845 TABLE test t3 0 0 0 0 0 0 0
1846 execute dump_waits_table_lock;
1847 object_type object_schema object_name count_star count_read count_write count_read_normal count_read_with_shared_locks count_read_high_priority count_read_no_insert count_read_external count_write_low_priority count_write_external
1848 TABLE test t1 0 0 0 0 0 0 0 0 0 0
1849 TABLE test t2 0 0 0 0 0 0 0 0 0 0
1850 TABLE test t3 0 0 0 0 0 0 0 0 0 0
1851 execute dump_objects_summary;
1852 object_type object_schema object_name count_star
1853 TABLE test t1 0
1854 TABLE test t2 0
1855 TABLE test t3 0
1856 show global status like "performance_schema%table%_lost";
1857 Variable_name Value
1858 Performance_schema_table_handles_lost 0
1859 Performance_schema_table_instances_lost 0
1860 Performance_schema_table_lock_stat_lost 0