Debian Codegraph @

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

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