Debian Codegraph @

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

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