Debian Codegraph @

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