Debian Codegraph @

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

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