Debian Codegraph @

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

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