Debian Codegraph @

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

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