Debian Codegraph @

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

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