Debian Codegraph @

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

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