Debian Codegraph @

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

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