Debian Codegraph @

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

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