Debian Codegraph @

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