Debian Codegraph @

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

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