Debian Codegraph @

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

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