Debian Codegraph @

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

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