Debian Codegraph @

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

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