Debian Codegraph @

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

raw
1 update performance_schema.setup_consumers
2 set enabled='NO' where name='thread_instrumentation';
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 NO
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 0
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 0
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 0
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 0
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 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 0
238 user1 wait/lock/table/sql/handler 0
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 0
248 user1 localhost wait/lock/table/sql/handler 0
249 execute dump_waits_user;
250 user event_name count_star
251 user1 wait/io/table/sql/handler 0
252 user1 wait/lock/table/sql/handler 0
253 execute dump_waits_host;
254 host event_name count_star
255 localhost wait/io/table/sql/handler 0
256 localhost wait/lock/table/sql/handler 0
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 0
295 user1 wait/lock/table/sql/handler 0
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 0
306 user1 localhost wait/lock/table/sql/handler 0
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 0
312 user1 wait/lock/table/sql/handler 0
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 0
318 localhost wait/lock/table/sql/handler 0
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 0
392 user1 wait/lock/table/sql/handler 0
393 username event_name count_star
394 user2 wait/io/table/sql/handler 0
395 user2 wait/lock/table/sql/handler 0
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 0
403 user1 localhost wait/lock/table/sql/handler 0
404 user2 localhost wait/io/table/sql/handler 0
405 user2 localhost wait/lock/table/sql/handler 0
406 execute dump_waits_user;
407 user event_name count_star
408 user1 wait/io/table/sql/handler 0
409 user1 wait/lock/table/sql/handler 0
410 user2 wait/io/table/sql/handler 0
411 user2 wait/lock/table/sql/handler 0
412 execute dump_waits_host;
413 host event_name count_star
414 localhost wait/io/table/sql/handler 0
415 localhost wait/lock/table/sql/handler 0
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 0
454 user1 wait/lock/table/sql/handler 0
455 username event_name count_star
456 user2 wait/io/table/sql/handler 0
457 user2 wait/lock/table/sql/handler 0
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 0
466 user1 localhost wait/lock/table/sql/handler 0
467 user2 localhost wait/io/table/sql/handler 0
468 user2 localhost wait/lock/table/sql/handler 0
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 0
474 user1 wait/lock/table/sql/handler 0
475 user2 wait/io/table/sql/handler 0
476 user2 wait/lock/table/sql/handler 0
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 0
482 localhost wait/lock/table/sql/handler 0
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 0
563 user1 wait/lock/table/sql/handler 0
564 username event_name count_star
565 user2 wait/io/table/sql/handler 0
566 user2 wait/lock/table/sql/handler 0
567 username event_name count_star
568 user3 wait/io/table/sql/handler 0
569 user3 wait/lock/table/sql/handler 0
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 0
575 user1 localhost wait/lock/table/sql/handler 0
576 user2 localhost wait/io/table/sql/handler 0
577 user2 localhost wait/lock/table/sql/handler 0
578 user3 localhost wait/io/table/sql/handler 0
579 user3 localhost wait/lock/table/sql/handler 0
580 execute dump_waits_user;
581 user event_name count_star
582 user1 wait/io/table/sql/handler 0
583 user1 wait/lock/table/sql/handler 0
584 user2 wait/io/table/sql/handler 0
585 user2 wait/lock/table/sql/handler 0
586 user3 wait/io/table/sql/handler 0
587 user3 wait/lock/table/sql/handler 0
588 execute dump_waits_host;
589 host event_name count_star
590 localhost wait/io/table/sql/handler 0
591 localhost wait/lock/table/sql/handler 0
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 0
630 user1 wait/lock/table/sql/handler 0
631 username event_name count_star
632 user2 wait/io/table/sql/handler 0
633 user2 wait/lock/table/sql/handler 0
634 username event_name count_star
635 user3 wait/io/table/sql/handler 0
636 user3 wait/lock/table/sql/handler 0
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 0
643 user1 localhost wait/lock/table/sql/handler 0
644 user2 localhost wait/io/table/sql/handler 0
645 user2 localhost wait/lock/table/sql/handler 0
646 user3 localhost wait/io/table/sql/handler 0
647 user3 localhost wait/lock/table/sql/handler 0
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 0
653 user1 wait/lock/table/sql/handler 0
654 user2 wait/io/table/sql/handler 0
655 user2 wait/lock/table/sql/handler 0
656 user3 wait/io/table/sql/handler 0
657 user3 wait/lock/table/sql/handler 0
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 0
663 localhost wait/lock/table/sql/handler 0
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 0
751 user1 wait/lock/table/sql/handler 0
752 username event_name count_star
753 user2 wait/io/table/sql/handler 0
754 user2 wait/lock/table/sql/handler 0
755 username event_name count_star
756 user3 wait/io/table/sql/handler 0
757 user3 wait/lock/table/sql/handler 0
758 username event_name count_star
759 user4 wait/io/table/sql/handler 0
760 user4 wait/lock/table/sql/handler 0
761 execute dump_waits_account;
762 user host event_name count_star
763 user1 localhost wait/io/table/sql/handler 0
764 user1 localhost wait/lock/table/sql/handler 0
765 user2 localhost wait/io/table/sql/handler 0
766 user2 localhost wait/lock/table/sql/handler 0
767 user3 localhost wait/io/table/sql/handler 0
768 user3 localhost wait/lock/table/sql/handler 0
769 user4 localhost wait/io/table/sql/handler 0
770 user4 localhost wait/lock/table/sql/handler 0
771 execute dump_waits_user;
772 user event_name count_star
773 user1 wait/io/table/sql/handler 0
774 user1 wait/lock/table/sql/handler 0
775 user2 wait/io/table/sql/handler 0
776 user2 wait/lock/table/sql/handler 0
777 user3 wait/io/table/sql/handler 0
778 user3 wait/lock/table/sql/handler 0
779 user4 wait/io/table/sql/handler 0
780 user4 wait/lock/table/sql/handler 0
781 execute dump_waits_host;
782 host event_name count_star
783 localhost wait/io/table/sql/handler 0
784 localhost wait/lock/table/sql/handler 0
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 0
824 user1 wait/lock/table/sql/handler 0
825 username event_name count_star
826 user2 wait/io/table/sql/handler 0
827 user2 wait/lock/table/sql/handler 0
828 username event_name count_star
829 user3 wait/io/table/sql/handler 0
830 user3 wait/lock/table/sql/handler 0
831 username event_name count_star
832 user4 wait/io/table/sql/handler 0
833 user4 wait/lock/table/sql/handler 0
834 execute dump_waits_account;
835 user host event_name count_star
836 user1 localhost wait/io/table/sql/handler 0
837 user1 localhost wait/lock/table/sql/handler 0
838 user2 localhost wait/io/table/sql/handler 0
839 user2 localhost wait/lock/table/sql/handler 0
840 user3 localhost wait/io/table/sql/handler 0
841 user3 localhost wait/lock/table/sql/handler 0
842 user4 localhost wait/io/table/sql/handler 0
843 user4 localhost wait/lock/table/sql/handler 0
844 execute dump_waits_user;
845 user event_name count_star
846 user1 wait/io/table/sql/handler 0
847 user1 wait/lock/table/sql/handler 0
848 user2 wait/io/table/sql/handler 0
849 user2 wait/lock/table/sql/handler 0
850 user3 wait/io/table/sql/handler 0
851 user3 wait/lock/table/sql/handler 0
852 user4 wait/io/table/sql/handler 0
853 user4 wait/lock/table/sql/handler 0
854 execute dump_waits_host;
855 host event_name count_star
856 localhost wait/io/table/sql/handler 0
857 localhost wait/lock/table/sql/handler 0
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 0
894 user1 wait/lock/table/sql/handler 0
895 username event_name count_star
896 user2 wait/io/table/sql/handler 0
897 user2 wait/lock/table/sql/handler 0
898 username event_name count_star
899 user3 wait/io/table/sql/handler 0
900 user3 wait/lock/table/sql/handler 0
901 username event_name count_star
902 user4 wait/io/table/sql/handler 0
903 user4 wait/lock/table/sql/handler 0
904 execute dump_waits_account;
905 user host event_name count_star
906 user1 localhost wait/io/table/sql/handler 0
907 user1 localhost wait/lock/table/sql/handler 0
908 user2 localhost wait/io/table/sql/handler 0
909 user2 localhost wait/lock/table/sql/handler 0
910 user3 localhost wait/io/table/sql/handler 0
911 user3 localhost wait/lock/table/sql/handler 0
912 user4 localhost wait/io/table/sql/handler 0
913 user4 localhost wait/lock/table/sql/handler 0
914 execute dump_waits_user;
915 user event_name count_star
916 user1 wait/io/table/sql/handler 0
917 user1 wait/lock/table/sql/handler 0
918 user2 wait/io/table/sql/handler 0
919 user2 wait/lock/table/sql/handler 0
920 user3 wait/io/table/sql/handler 0
921 user3 wait/lock/table/sql/handler 0
922 user4 wait/io/table/sql/handler 0
923 user4 wait/lock/table/sql/handler 0
924 execute dump_waits_host;
925 host event_name count_star
926 localhost wait/io/table/sql/handler 0
927 localhost wait/lock/table/sql/handler 0
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 0
964 user1 wait/lock/table/sql/handler 0
965 username event_name count_star
966 user2 wait/io/table/sql/handler 0
967 user2 wait/lock/table/sql/handler 0
968 username event_name count_star
969 user3 wait/io/table/sql/handler 0
970 user3 wait/lock/table/sql/handler 0
971 username event_name count_star
972 user4 wait/io/table/sql/handler 0
973 user4 wait/lock/table/sql/handler 0
974 execute dump_waits_account;
975 user host event_name count_star
976 user1 localhost wait/io/table/sql/handler 0
977 user1 localhost wait/lock/table/sql/handler 0
978 user2 localhost wait/io/table/sql/handler 0
979 user2 localhost wait/lock/table/sql/handler 0
980 user3 localhost wait/io/table/sql/handler 0
981 user3 localhost wait/lock/table/sql/handler 0
982 user4 localhost wait/io/table/sql/handler 0
983 user4 localhost wait/lock/table/sql/handler 0
984 execute dump_waits_user;
985 user event_name count_star
986 user1 wait/io/table/sql/handler 0
987 user1 wait/lock/table/sql/handler 0
988 user2 wait/io/table/sql/handler 0
989 user2 wait/lock/table/sql/handler 0
990 user3 wait/io/table/sql/handler 0
991 user3 wait/lock/table/sql/handler 0
992 user4 wait/io/table/sql/handler 0
993 user4 wait/lock/table/sql/handler 0
994 execute dump_waits_host;
995 host event_name count_star
996 localhost wait/io/table/sql/handler 0
997 localhost wait/lock/table/sql/handler 0
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 0
1034 user2 wait/lock/table/sql/handler 0
1035 username event_name count_star
1036 user3 wait/io/table/sql/handler 0
1037 user3 wait/lock/table/sql/handler 0
1038 username event_name count_star
1039 user4 wait/io/table/sql/handler 0
1040 user4 wait/lock/table/sql/handler 0
1041 execute dump_waits_account;
1042 user host event_name count_star
1043 user1 localhost wait/io/table/sql/handler 0
1044 user1 localhost wait/lock/table/sql/handler 0
1045 user2 localhost wait/io/table/sql/handler 0
1046 user2 localhost wait/lock/table/sql/handler 0
1047 user3 localhost wait/io/table/sql/handler 0
1048 user3 localhost wait/lock/table/sql/handler 0
1049 user4 localhost wait/io/table/sql/handler 0
1050 user4 localhost wait/lock/table/sql/handler 0
1051 execute dump_waits_user;
1052 user event_name count_star
1053 user1 wait/io/table/sql/handler 0
1054 user1 wait/lock/table/sql/handler 0
1055 user2 wait/io/table/sql/handler 0
1056 user2 wait/lock/table/sql/handler 0
1057 user3 wait/io/table/sql/handler 0
1058 user3 wait/lock/table/sql/handler 0
1059 user4 wait/io/table/sql/handler 0
1060 user4 wait/lock/table/sql/handler 0
1061 execute dump_waits_host;
1062 host event_name count_star
1063 localhost wait/io/table/sql/handler 0
1064 localhost wait/lock/table/sql/handler 0
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 0
1103 user3 wait/lock/table/sql/handler 0
1104 username event_name count_star
1105 user4 wait/io/table/sql/handler 0
1106 user4 wait/lock/table/sql/handler 0
1107 execute dump_waits_account;
1108 user host event_name count_star
1109 user1 localhost wait/io/table/sql/handler 0
1110 user1 localhost wait/lock/table/sql/handler 0
1111 user2 localhost wait/io/table/sql/handler 0
1112 user2 localhost wait/lock/table/sql/handler 0
1113 user3 localhost wait/io/table/sql/handler 0
1114 user3 localhost wait/lock/table/sql/handler 0
1115 user4 localhost wait/io/table/sql/handler 0
1116 user4 localhost wait/lock/table/sql/handler 0
1117 execute dump_waits_user;
1118 user event_name count_star
1119 user1 wait/io/table/sql/handler 0
1120 user1 wait/lock/table/sql/handler 0
1121 user2 wait/io/table/sql/handler 0
1122 user2 wait/lock/table/sql/handler 0
1123 user3 wait/io/table/sql/handler 0
1124 user3 wait/lock/table/sql/handler 0
1125 user4 wait/io/table/sql/handler 0
1126 user4 wait/lock/table/sql/handler 0
1127 execute dump_waits_host;
1128 host event_name count_star
1129 localhost wait/io/table/sql/handler 0
1130 localhost wait/lock/table/sql/handler 0
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 0
1171 user4 wait/lock/table/sql/handler 0
1172 execute dump_waits_account;
1173 user host event_name count_star
1174 user1 localhost wait/io/table/sql/handler 0
1175 user1 localhost wait/lock/table/sql/handler 0
1176 user2 localhost wait/io/table/sql/handler 0
1177 user2 localhost wait/lock/table/sql/handler 0
1178 user3 localhost wait/io/table/sql/handler 0
1179 user3 localhost wait/lock/table/sql/handler 0
1180 user4 localhost wait/io/table/sql/handler 0
1181 user4 localhost wait/lock/table/sql/handler 0
1182 execute dump_waits_user;
1183 user event_name count_star
1184 user1 wait/io/table/sql/handler 0
1185 user1 wait/lock/table/sql/handler 0
1186 user2 wait/io/table/sql/handler 0
1187 user2 wait/lock/table/sql/handler 0
1188 user3 wait/io/table/sql/handler 0
1189 user3 wait/lock/table/sql/handler 0
1190 user4 wait/io/table/sql/handler 0
1191 user4 wait/lock/table/sql/handler 0
1192 execute dump_waits_host;
1193 host event_name count_star
1194 localhost wait/io/table/sql/handler 0
1195 localhost wait/lock/table/sql/handler 0
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 0
1239 user1 localhost wait/lock/table/sql/handler 0
1240 user2 localhost wait/io/table/sql/handler 0
1241 user2 localhost wait/lock/table/sql/handler 0
1242 user3 localhost wait/io/table/sql/handler 0
1243 user3 localhost wait/lock/table/sql/handler 0
1244 user4 localhost wait/io/table/sql/handler 0
1245 user4 localhost wait/lock/table/sql/handler 0
1246 execute dump_waits_user;
1247 user event_name count_star
1248 user1 wait/io/table/sql/handler 0
1249 user1 wait/lock/table/sql/handler 0
1250 user2 wait/io/table/sql/handler 0
1251 user2 wait/lock/table/sql/handler 0
1252 user3 wait/io/table/sql/handler 0
1253 user3 wait/lock/table/sql/handler 0
1254 user4 wait/io/table/sql/handler 0
1255 user4 wait/lock/table/sql/handler 0
1256 execute dump_waits_host;
1257 host event_name count_star
1258 localhost wait/io/table/sql/handler 0
1259 localhost wait/lock/table/sql/handler 0
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 0
1305 user1 localhost wait/lock/table/sql/handler 0
1306 user2 localhost wait/io/table/sql/handler 0
1307 user2 localhost wait/lock/table/sql/handler 0
1308 user3 localhost wait/io/table/sql/handler 0
1309 user3 localhost wait/lock/table/sql/handler 0
1310 user4 localhost wait/io/table/sql/handler 0
1311 user4 localhost wait/lock/table/sql/handler 0
1312 execute dump_waits_user;
1313 user event_name count_star
1314 user1 wait/io/table/sql/handler 0
1315 user1 wait/lock/table/sql/handler 0
1316 user2 wait/io/table/sql/handler 0
1317 user2 wait/lock/table/sql/handler 0
1318 user3 wait/io/table/sql/handler 0
1319 user3 wait/lock/table/sql/handler 0
1320 user4 wait/io/table/sql/handler 0
1321 user4 wait/lock/table/sql/handler 0
1322 execute dump_waits_host;
1323 host event_name count_star
1324 localhost wait/io/table/sql/handler 0
1325 localhost wait/lock/table/sql/handler 0
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 0
1380 user1 wait/lock/table/sql/handler 0
1381 user2 wait/io/table/sql/handler 0
1382 user2 wait/lock/table/sql/handler 0
1383 user3 wait/io/table/sql/handler 0
1384 user3 wait/lock/table/sql/handler 0
1385 user4 wait/io/table/sql/handler 0
1386 user4 wait/lock/table/sql/handler 0
1387 execute dump_waits_host;
1388 host event_name count_star
1389 localhost wait/io/table/sql/handler 0
1390 localhost wait/lock/table/sql/handler 0
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 0
1455 localhost wait/lock/table/sql/handler 0
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