Debian Codegraph @

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

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