Debian Codegraph @

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

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