Debian Codegraph @

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

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