Debian Codegraph @

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

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