Debian Codegraph @

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

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