Debian Codegraph @

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

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