Debian Codegraph @

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

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