Debian Codegraph @

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

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