Debian Codegraph @

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

raw
1 "================== Step 1 =================="
2 call dump_thread();
3 username status
4 user1 not found
5 username status
6 user2 not found
7 username status
8 user3 not found
9 username status
10 user4 not found
11 execute dump_waits_account;
12 user host event_name count_star
13 execute dump_waits_user;
14 user event_name count_star
15 execute dump_waits_host;
16 host event_name count_star
17 execute dump_waits_global;
18 event_name count_star
19 wait/io/file/sql/query_log 0
20 wait/synch/mutex/sql/LOCK_connection_count 0
21 wait/synch/mutex/sql/LOCK_uuid_generator 0
22 execute dump_waits_history;
23 event_name count(event_name)
24 execute dump_stages_account;
25 user host event_name count_star
26 execute dump_stages_user;
27 user event_name count_star
28 execute dump_stages_host;
29 host event_name count_star
30 execute dump_stages_global;
31 event_name count_star
32 stage/sql/checking permissions 0
33 stage/sql/closing tables 0
34 stage/sql/init 0
35 stage/sql/Opening tables 0
36 stage/sql/starting 0
37 execute dump_stages_history;
38 event_name count(event_name)
39 execute dump_statements_account;
40 user host event_name count_star
41 execute dump_statements_user;
42 user event_name count_star
43 execute dump_statements_host;
44 host event_name count_star
45 execute dump_statements_global;
46 event_name count_star
47 statement/com/Error 0
48 statement/com/Quit 0
49 statement/sp/freturn 0
50 statement/sql/insert 0
51 statement/sql/select 0
52 execute dump_statements_history;
53 event_name count(event_name)
54 execute dump_transactions_account;
55 user host event_name count_star
56 execute dump_transactions_user;
57 user event_name count_star
58 execute dump_transactions_host;
59 host event_name count_star
60 execute dump_transactions_global;
61 event_name count_star
62 transaction 0
63 execute dump_transactions_history;
64 event_name count(event_name)
65 execute dump_accounts;
66 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
67 execute dump_users;
68 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
69 execute dump_hosts;
70 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
71 "================== con1 connected =================="
72 "================== Step 2 =================="
73 call dump_thread();
74 username event_name count_star
75 user1 wait/io/file/sql/query_log 1
76 user1 wait/synch/mutex/sql/LOCK_connection_count 0
77 user1 wait/synch/mutex/sql/LOCK_uuid_generator 0
78 username status
79 user2 not found
80 username status
81 user3 not found
82 username status
83 user4 not found
84 execute dump_waits_account;
85 user host event_name count_star
86 execute dump_waits_user;
87 user event_name count_star
88 execute dump_waits_host;
89 host event_name count_star
90 execute dump_waits_global;
91 event_name count_star
92 wait/io/file/sql/query_log 1
93 wait/synch/mutex/sql/LOCK_connection_count 0
94 wait/synch/mutex/sql/LOCK_uuid_generator 0
95 execute dump_waits_history;
96 event_name count(event_name)
97 wait/io/file/sql/query_log 1
98 execute dump_stages_account;
99 user host event_name count_star
100 execute dump_stages_user;
101 user event_name count_star
102 execute dump_stages_host;
103 host event_name count_star
104 execute dump_stages_global;
105 event_name count_star
106 stage/sql/checking permissions 0
107 stage/sql/closing tables 0
108 stage/sql/init 0
109 stage/sql/Opening tables 0
110 stage/sql/starting 0
111 execute dump_stages_history;
112 event_name count(event_name)
113 execute dump_statements_account;
114 user host event_name count_star
115 execute dump_statements_user;
116 user event_name count_star
117 execute dump_statements_host;
118 host event_name count_star
119 execute dump_statements_global;
120 event_name count_star
121 statement/com/Error 0
122 statement/com/Quit 0
123 statement/sp/freturn 0
124 statement/sql/insert 0
125 statement/sql/select 0
126 execute dump_statements_history;
127 event_name count(event_name)
128 execute dump_transactions_account;
129 user host event_name count_star
130 execute dump_transactions_user;
131 user event_name count_star
132 execute dump_transactions_host;
133 host event_name count_star
134 execute dump_transactions_global;
135 event_name count_star
136 transaction 0
137 execute dump_transactions_history;
138 event_name count(event_name)
139 execute dump_accounts;
140 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
141 execute dump_users;
142 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
143 execute dump_hosts;
144 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
145 select uuid_short() <> 1;
146 uuid_short() <> 1
147 1
148 select uuid_short() <> 1;
149 uuid_short() <> 1
150 1
151 start transaction;
152 insert into test.t1 values ("marker");
153 commit;
154 select test.f(10,20);
155 test.f(10,20)
156 30
157 "================== con1 marker =================="
158 "================== Step 3 =================="
159 call dump_thread();
160 username event_name count_star
161 user1 wait/io/file/sql/query_log 7
162 user1 wait/synch/mutex/sql/LOCK_connection_count 0
163 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
164 username status
165 user2 not found
166 username status
167 user3 not found
168 username status
169 user4 not found
170 execute dump_waits_account;
171 user host event_name count_star
172 execute dump_waits_user;
173 user event_name count_star
174 execute dump_waits_host;
175 host event_name count_star
176 execute dump_waits_global;
177 event_name count_star
178 wait/io/file/sql/query_log 7
179 wait/synch/mutex/sql/LOCK_connection_count 0
180 wait/synch/mutex/sql/LOCK_uuid_generator 2
181 execute dump_waits_history;
182 event_name count(event_name)
183 wait/io/file/sql/query_log 7
184 wait/synch/mutex/sql/LOCK_uuid_generator 2
185 execute dump_stages_account;
186 user host event_name count_star
187 execute dump_stages_user;
188 user event_name count_star
189 execute dump_stages_host;
190 host event_name count_star
191 execute dump_stages_global;
192 event_name count_star
193 stage/sql/checking permissions 4
194 stage/sql/closing tables 6
195 stage/sql/init 4
196 stage/sql/Opening tables 5
197 stage/sql/starting 8
198 execute dump_stages_history;
199 event_name count(event_name)
200 stage/sql/checking permissions 4
201 stage/sql/closing tables 6
202 stage/sql/init 4
203 stage/sql/Opening tables 5
204 stage/sql/starting 8
205 execute dump_statements_account;
206 user host event_name count_star
207 execute dump_statements_user;
208 user event_name count_star
209 execute dump_statements_host;
210 host event_name count_star
211 execute dump_statements_global;
212 event_name count_star
213 statement/com/Error 0
214 statement/com/Quit 0
215 statement/sp/freturn 1
216 statement/sql/insert 1
217 statement/sql/select 3
218 execute dump_statements_history;
219 event_name count(event_name)
220 statement/sp/freturn 1
221 statement/sql/insert 1
222 statement/sql/select 3
223 execute dump_transactions_account;
224 user host event_name count_star
225 execute dump_transactions_user;
226 user event_name count_star
227 execute dump_transactions_host;
228 host event_name count_star
229 execute dump_transactions_global;
230 event_name count_star
231 transaction 1
232 execute dump_transactions_history;
233 event_name count(event_name)
234 transaction 1
235 execute dump_accounts;
236 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
237 execute dump_users;
238 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
239 execute dump_hosts;
240 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
241 "================== con2 connected =================="
242 "================== Step 4 =================="
243 call dump_thread();
244 username event_name count_star
245 user1 wait/io/file/sql/query_log 7
246 user1 wait/synch/mutex/sql/LOCK_connection_count 0
247 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
248 username event_name count_star
249 user2 wait/io/file/sql/query_log 1
250 user2 wait/synch/mutex/sql/LOCK_connection_count 0
251 user2 wait/synch/mutex/sql/LOCK_uuid_generator 0
252 username status
253 user3 not found
254 username status
255 user4 not found
256 execute dump_waits_account;
257 user host event_name count_star
258 execute dump_waits_user;
259 user event_name count_star
260 execute dump_waits_host;
261 host event_name count_star
262 execute dump_waits_global;
263 event_name count_star
264 wait/io/file/sql/query_log 8
265 wait/synch/mutex/sql/LOCK_connection_count 0
266 wait/synch/mutex/sql/LOCK_uuid_generator 2
267 execute dump_waits_history;
268 event_name count(event_name)
269 wait/io/file/sql/query_log 8
270 wait/synch/mutex/sql/LOCK_uuid_generator 2
271 execute dump_stages_account;
272 user host event_name count_star
273 execute dump_stages_user;
274 user event_name count_star
275 execute dump_stages_host;
276 host event_name count_star
277 execute dump_stages_global;
278 event_name count_star
279 stage/sql/checking permissions 4
280 stage/sql/closing tables 6
281 stage/sql/init 4
282 stage/sql/Opening tables 5
283 stage/sql/starting 8
284 execute dump_stages_history;
285 event_name count(event_name)
286 stage/sql/checking permissions 4
287 stage/sql/closing tables 6
288 stage/sql/init 4
289 stage/sql/Opening tables 5
290 stage/sql/starting 8
291 execute dump_statements_account;
292 user host event_name count_star
293 execute dump_statements_user;
294 user event_name count_star
295 execute dump_statements_host;
296 host event_name count_star
297 execute dump_statements_global;
298 event_name count_star
299 statement/com/Error 0
300 statement/com/Quit 0
301 statement/sp/freturn 1
302 statement/sql/insert 1
303 statement/sql/select 3
304 execute dump_statements_history;
305 event_name count(event_name)
306 statement/sp/freturn 1
307 statement/sql/insert 1
308 statement/sql/select 3
309 execute dump_transactions_account;
310 user host event_name count_star
311 execute dump_transactions_user;
312 user event_name count_star
313 execute dump_transactions_host;
314 host event_name count_star
315 execute dump_transactions_global;
316 event_name count_star
317 transaction 1
318 execute dump_transactions_history;
319 event_name count(event_name)
320 transaction 1
321 execute dump_accounts;
322 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
323 execute dump_users;
324 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
325 execute dump_hosts;
326 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
327 select uuid_short() <> 1;
328 uuid_short() <> 1
329 1
330 select uuid_short() <> 1;
331 uuid_short() <> 1
332 1
333 start transaction;
334 insert into test.t1 values ("marker");
335 commit;
336 select test.f(10,20);
337 test.f(10,20)
338 30
339 "================== con2 marker =================="
340 "================== Step 5 =================="
341 call dump_thread();
342 username event_name count_star
343 user1 wait/io/file/sql/query_log 7
344 user1 wait/synch/mutex/sql/LOCK_connection_count 0
345 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
346 username event_name count_star
347 user2 wait/io/file/sql/query_log 7
348 user2 wait/synch/mutex/sql/LOCK_connection_count 0
349 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
350 username status
351 user3 not found
352 username status
353 user4 not found
354 execute dump_waits_account;
355 user host event_name count_star
356 execute dump_waits_user;
357 user event_name count_star
358 execute dump_waits_host;
359 host event_name count_star
360 execute dump_waits_global;
361 event_name count_star
362 wait/io/file/sql/query_log 14
363 wait/synch/mutex/sql/LOCK_connection_count 0
364 wait/synch/mutex/sql/LOCK_uuid_generator 4
365 execute dump_waits_history;
366 event_name count(event_name)
367 wait/io/file/sql/query_log 14
368 wait/synch/mutex/sql/LOCK_uuid_generator 4
369 execute dump_stages_account;
370 user host event_name count_star
371 execute dump_stages_user;
372 user event_name count_star
373 execute dump_stages_host;
374 host event_name count_star
375 execute dump_stages_global;
376 event_name count_star
377 stage/sql/checking permissions 8
378 stage/sql/closing tables 12
379 stage/sql/init 8
380 stage/sql/Opening tables 10
381 stage/sql/starting 16
382 execute dump_stages_history;
383 event_name count(event_name)
384 stage/sql/checking permissions 8
385 stage/sql/closing tables 12
386 stage/sql/init 8
387 stage/sql/Opening tables 10
388 stage/sql/starting 16
389 execute dump_statements_account;
390 user host event_name count_star
391 execute dump_statements_user;
392 user event_name count_star
393 execute dump_statements_host;
394 host event_name count_star
395 execute dump_statements_global;
396 event_name count_star
397 statement/com/Error 0
398 statement/com/Quit 0
399 statement/sp/freturn 2
400 statement/sql/insert 2
401 statement/sql/select 6
402 execute dump_statements_history;
403 event_name count(event_name)
404 statement/sp/freturn 2
405 statement/sql/insert 2
406 statement/sql/select 6
407 execute dump_transactions_account;
408 user host event_name count_star
409 execute dump_transactions_user;
410 user event_name count_star
411 execute dump_transactions_host;
412 host event_name count_star
413 execute dump_transactions_global;
414 event_name count_star
415 transaction 2
416 execute dump_transactions_history;
417 event_name count(event_name)
418 transaction 2
419 execute dump_accounts;
420 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
421 execute dump_users;
422 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
423 execute dump_hosts;
424 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
425 "================== con3 connected =================="
426 "================== Step 6 =================="
427 call dump_thread();
428 username event_name count_star
429 user1 wait/io/file/sql/query_log 7
430 user1 wait/synch/mutex/sql/LOCK_connection_count 0
431 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
432 username event_name count_star
433 user2 wait/io/file/sql/query_log 7
434 user2 wait/synch/mutex/sql/LOCK_connection_count 0
435 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
436 username event_name count_star
437 user3 wait/io/file/sql/query_log 1
438 user3 wait/synch/mutex/sql/LOCK_connection_count 0
439 user3 wait/synch/mutex/sql/LOCK_uuid_generator 0
440 username status
441 user4 not found
442 execute dump_waits_account;
443 user host event_name count_star
444 execute dump_waits_user;
445 user event_name count_star
446 execute dump_waits_host;
447 host event_name count_star
448 execute dump_waits_global;
449 event_name count_star
450 wait/io/file/sql/query_log 15
451 wait/synch/mutex/sql/LOCK_connection_count 0
452 wait/synch/mutex/sql/LOCK_uuid_generator 4
453 execute dump_waits_history;
454 event_name count(event_name)
455 wait/io/file/sql/query_log 15
456 wait/synch/mutex/sql/LOCK_uuid_generator 4
457 execute dump_stages_account;
458 user host event_name count_star
459 execute dump_stages_user;
460 user event_name count_star
461 execute dump_stages_host;
462 host event_name count_star
463 execute dump_stages_global;
464 event_name count_star
465 stage/sql/checking permissions 8
466 stage/sql/closing tables 12
467 stage/sql/init 8
468 stage/sql/Opening tables 10
469 stage/sql/starting 16
470 execute dump_stages_history;
471 event_name count(event_name)
472 stage/sql/checking permissions 8
473 stage/sql/closing tables 12
474 stage/sql/init 8
475 stage/sql/Opening tables 10
476 stage/sql/starting 16
477 execute dump_statements_account;
478 user host event_name count_star
479 execute dump_statements_user;
480 user event_name count_star
481 execute dump_statements_host;
482 host event_name count_star
483 execute dump_statements_global;
484 event_name count_star
485 statement/com/Error 0
486 statement/com/Quit 0
487 statement/sp/freturn 2
488 statement/sql/insert 2
489 statement/sql/select 6
490 execute dump_statements_history;
491 event_name count(event_name)
492 statement/sp/freturn 2
493 statement/sql/insert 2
494 statement/sql/select 6
495 execute dump_transactions_account;
496 user host event_name count_star
497 execute dump_transactions_user;
498 user event_name count_star
499 execute dump_transactions_host;
500 host event_name count_star
501 execute dump_transactions_global;
502 event_name count_star
503 transaction 2
504 execute dump_transactions_history;
505 event_name count(event_name)
506 transaction 2
507 execute dump_accounts;
508 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
509 execute dump_users;
510 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
511 execute dump_hosts;
512 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
513 select uuid_short() <> 1;
514 uuid_short() <> 1
515 1
516 select uuid_short() <> 1;
517 uuid_short() <> 1
518 1
519 start transaction;
520 insert into test.t1 values ("marker");
521 commit;
522 select test.f(10,20);
523 test.f(10,20)
524 30
525 "================== con3 marker =================="
526 "================== Step 7 =================="
527 call dump_thread();
528 username event_name count_star
529 user1 wait/io/file/sql/query_log 7
530 user1 wait/synch/mutex/sql/LOCK_connection_count 0
531 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
532 username event_name count_star
533 user2 wait/io/file/sql/query_log 7
534 user2 wait/synch/mutex/sql/LOCK_connection_count 0
535 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
536 username event_name count_star
537 user3 wait/io/file/sql/query_log 7
538 user3 wait/synch/mutex/sql/LOCK_connection_count 0
539 user3 wait/synch/mutex/sql/LOCK_uuid_generator 2
540 username status
541 user4 not found
542 execute dump_waits_account;
543 user host event_name count_star
544 execute dump_waits_user;
545 user event_name count_star
546 execute dump_waits_host;
547 host event_name count_star
548 execute dump_waits_global;
549 event_name count_star
550 wait/io/file/sql/query_log 21
551 wait/synch/mutex/sql/LOCK_connection_count 0
552 wait/synch/mutex/sql/LOCK_uuid_generator 6
553 execute dump_waits_history;
554 event_name count(event_name)
555 wait/io/file/sql/query_log 21
556 wait/synch/mutex/sql/LOCK_uuid_generator 6
557 execute dump_stages_account;
558 user host event_name count_star
559 execute dump_stages_user;
560 user event_name count_star
561 execute dump_stages_host;
562 host event_name count_star
563 execute dump_stages_global;
564 event_name count_star
565 stage/sql/checking permissions 12
566 stage/sql/closing tables 18
567 stage/sql/init 12
568 stage/sql/Opening tables 15
569 stage/sql/starting 24
570 execute dump_stages_history;
571 event_name count(event_name)
572 stage/sql/checking permissions 12
573 stage/sql/closing tables 18
574 stage/sql/init 12
575 stage/sql/Opening tables 15
576 stage/sql/starting 24
577 execute dump_statements_account;
578 user host event_name count_star
579 execute dump_statements_user;
580 user event_name count_star
581 execute dump_statements_host;
582 host event_name count_star
583 execute dump_statements_global;
584 event_name count_star
585 statement/com/Error 0
586 statement/com/Quit 0
587 statement/sp/freturn 3
588 statement/sql/insert 3
589 statement/sql/select 9
590 execute dump_statements_history;
591 event_name count(event_name)
592 statement/sp/freturn 3
593 statement/sql/insert 3
594 statement/sql/select 9
595 execute dump_transactions_account;
596 user host event_name count_star
597 execute dump_transactions_user;
598 user event_name count_star
599 execute dump_transactions_host;
600 host event_name count_star
601 execute dump_transactions_global;
602 event_name count_star
603 transaction 3
604 execute dump_transactions_history;
605 event_name count(event_name)
606 transaction 3
607 execute dump_accounts;
608 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
609 execute dump_users;
610 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
611 execute dump_hosts;
612 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
613 "================== con4 connected =================="
614 "================== Step 8 =================="
615 call dump_thread();
616 username event_name count_star
617 user1 wait/io/file/sql/query_log 7
618 user1 wait/synch/mutex/sql/LOCK_connection_count 0
619 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
620 username event_name count_star
621 user2 wait/io/file/sql/query_log 7
622 user2 wait/synch/mutex/sql/LOCK_connection_count 0
623 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
624 username event_name count_star
625 user3 wait/io/file/sql/query_log 7
626 user3 wait/synch/mutex/sql/LOCK_connection_count 0
627 user3 wait/synch/mutex/sql/LOCK_uuid_generator 2
628 username event_name count_star
629 user4 wait/io/file/sql/query_log 1
630 user4 wait/synch/mutex/sql/LOCK_connection_count 0
631 user4 wait/synch/mutex/sql/LOCK_uuid_generator 0
632 execute dump_waits_account;
633 user host event_name count_star
634 execute dump_waits_user;
635 user event_name count_star
636 execute dump_waits_host;
637 host event_name count_star
638 execute dump_waits_global;
639 event_name count_star
640 wait/io/file/sql/query_log 22
641 wait/synch/mutex/sql/LOCK_connection_count 0
642 wait/synch/mutex/sql/LOCK_uuid_generator 6
643 execute dump_waits_history;
644 event_name count(event_name)
645 wait/io/file/sql/query_log 22
646 wait/synch/mutex/sql/LOCK_uuid_generator 6
647 execute dump_stages_account;
648 user host event_name count_star
649 execute dump_stages_user;
650 user event_name count_star
651 execute dump_stages_host;
652 host event_name count_star
653 execute dump_stages_global;
654 event_name count_star
655 stage/sql/checking permissions 12
656 stage/sql/closing tables 18
657 stage/sql/init 12
658 stage/sql/Opening tables 15
659 stage/sql/starting 24
660 execute dump_stages_history;
661 event_name count(event_name)
662 stage/sql/checking permissions 12
663 stage/sql/closing tables 18
664 stage/sql/init 12
665 stage/sql/Opening tables 15
666 stage/sql/starting 24
667 execute dump_statements_account;
668 user host event_name count_star
669 execute dump_statements_user;
670 user event_name count_star
671 execute dump_statements_host;
672 host event_name count_star
673 execute dump_statements_global;
674 event_name count_star
675 statement/com/Error 0
676 statement/com/Quit 0
677 statement/sp/freturn 3
678 statement/sql/insert 3
679 statement/sql/select 9
680 execute dump_statements_history;
681 event_name count(event_name)
682 statement/sp/freturn 3
683 statement/sql/insert 3
684 statement/sql/select 9
685 execute dump_transactions_account;
686 user host event_name count_star
687 execute dump_transactions_user;
688 user event_name count_star
689 execute dump_transactions_host;
690 host event_name count_star
691 execute dump_transactions_global;
692 event_name count_star
693 transaction 3
694 execute dump_transactions_history;
695 event_name count(event_name)
696 transaction 3
697 execute dump_accounts;
698 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
699 execute dump_users;
700 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
701 execute dump_hosts;
702 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
703 select uuid_short() <> 1;
704 uuid_short() <> 1
705 1
706 select uuid_short() <> 1;
707 uuid_short() <> 1
708 1
709 start transaction;
710 insert into test.t1 values ("marker");
711 commit;
712 select test.f(10,20);
713 test.f(10,20)
714 30
715 "================== con4 marker =================="
716 "================== Step 9 =================="
717 call dump_thread();
718 username event_name count_star
719 user1 wait/io/file/sql/query_log 7
720 user1 wait/synch/mutex/sql/LOCK_connection_count 0
721 user1 wait/synch/mutex/sql/LOCK_uuid_generator 2
722 username event_name count_star
723 user2 wait/io/file/sql/query_log 7
724 user2 wait/synch/mutex/sql/LOCK_connection_count 0
725 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
726 username event_name count_star
727 user3 wait/io/file/sql/query_log 7
728 user3 wait/synch/mutex/sql/LOCK_connection_count 0
729 user3 wait/synch/mutex/sql/LOCK_uuid_generator 2
730 username event_name count_star
731 user4 wait/io/file/sql/query_log 7
732 user4 wait/synch/mutex/sql/LOCK_connection_count 0
733 user4 wait/synch/mutex/sql/LOCK_uuid_generator 2
734 execute dump_waits_account;
735 user host event_name count_star
736 execute dump_waits_user;
737 user event_name count_star
738 execute dump_waits_host;
739 host event_name count_star
740 execute dump_waits_global;
741 event_name count_star
742 wait/io/file/sql/query_log 28
743 wait/synch/mutex/sql/LOCK_connection_count 0
744 wait/synch/mutex/sql/LOCK_uuid_generator 8
745 execute dump_waits_history;
746 event_name count(event_name)
747 wait/io/file/sql/query_log 28
748 wait/synch/mutex/sql/LOCK_uuid_generator 8
749 execute dump_stages_account;
750 user host event_name count_star
751 execute dump_stages_user;
752 user event_name count_star
753 execute dump_stages_host;
754 host event_name count_star
755 execute dump_stages_global;
756 event_name count_star
757 stage/sql/checking permissions 16
758 stage/sql/closing tables 24
759 stage/sql/init 16
760 stage/sql/Opening tables 20
761 stage/sql/starting 32
762 execute dump_stages_history;
763 event_name count(event_name)
764 stage/sql/checking permissions 16
765 stage/sql/closing tables 24
766 stage/sql/init 16
767 stage/sql/Opening tables 20
768 stage/sql/starting 32
769 execute dump_statements_account;
770 user host event_name count_star
771 execute dump_statements_user;
772 user event_name count_star
773 execute dump_statements_host;
774 host event_name count_star
775 execute dump_statements_global;
776 event_name count_star
777 statement/com/Error 0
778 statement/com/Quit 0
779 statement/sp/freturn 4
780 statement/sql/insert 4
781 statement/sql/select 12
782 execute dump_statements_history;
783 event_name count(event_name)
784 statement/sp/freturn 4
785 statement/sql/insert 4
786 statement/sql/select 12
787 execute dump_transactions_account;
788 user host event_name count_star
789 execute dump_transactions_user;
790 user event_name count_star
791 execute dump_transactions_host;
792 host event_name count_star
793 execute dump_transactions_global;
794 event_name count_star
795 transaction 4
796 execute dump_transactions_history;
797 event_name count(event_name)
798 transaction 4
799 execute dump_accounts;
800 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
801 execute dump_users;
802 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
803 execute dump_hosts;
804 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
805 "================== con1 disconnected =================="
806 "================== Step 10 =================="
807 call dump_thread();
808 username status
809 user1 not found
810 username event_name count_star
811 user2 wait/io/file/sql/query_log 7
812 user2 wait/synch/mutex/sql/LOCK_connection_count 0
813 user2 wait/synch/mutex/sql/LOCK_uuid_generator 2
814 username event_name count_star
815 user3 wait/io/file/sql/query_log 7
816 user3 wait/synch/mutex/sql/LOCK_connection_count 0
817 user3 wait/synch/mutex/sql/LOCK_uuid_generator 2
818 username event_name count_star
819 user4 wait/io/file/sql/query_log 7
820 user4 wait/synch/mutex/sql/LOCK_connection_count 0
821 user4 wait/synch/mutex/sql/LOCK_uuid_generator 2
822 execute dump_waits_account;
823 user host event_name count_star
824 execute dump_waits_user;
825 user event_name count_star
826 execute dump_waits_host;
827 host event_name count_star
828 execute dump_waits_global;
829 event_name count_star
830 wait/io/file/sql/query_log 29
831 wait/synch/mutex/sql/LOCK_connection_count 1
832 wait/synch/mutex/sql/LOCK_uuid_generator 8
833 execute dump_waits_history;
834 event_name count(event_name)
835 wait/io/file/sql/query_log 29
836 wait/synch/mutex/sql/LOCK_connection_count 1
837 wait/synch/mutex/sql/LOCK_uuid_generator 8
838 execute dump_stages_account;
839 user host event_name count_star
840 execute dump_stages_user;
841 user event_name count_star
842 execute dump_stages_host;
843 host event_name count_star
844 execute dump_stages_global;
845 event_name count_star
846 stage/sql/checking permissions 16
847 stage/sql/closing tables 24
848 stage/sql/init 16
849 stage/sql/Opening tables 20
850 stage/sql/starting 33
851 execute dump_stages_history;
852 event_name count(event_name)
853 stage/sql/checking permissions 16
854 stage/sql/closing tables 24
855 stage/sql/init 16
856 stage/sql/Opening tables 20
857 stage/sql/starting 33
858 execute dump_statements_account;
859 user host event_name count_star
860 execute dump_statements_user;
861 user event_name count_star
862 execute dump_statements_host;
863 host event_name count_star
864 execute dump_statements_global;
865 event_name count_star
866 statement/com/Error 0
867 statement/com/Quit 1
868 statement/sp/freturn 4
869 statement/sql/insert 4
870 statement/sql/select 12
871 execute dump_statements_history;
872 event_name count(event_name)
873 statement/com/Quit 1
874 statement/sp/freturn 4
875 statement/sql/insert 4
876 statement/sql/select 12
877 execute dump_transactions_account;
878 user host event_name count_star
879 execute dump_transactions_user;
880 user event_name count_star
881 execute dump_transactions_host;
882 host event_name count_star
883 execute dump_transactions_global;
884 event_name count_star
885 transaction 4
886 execute dump_transactions_history;
887 event_name count(event_name)
888 transaction 4
889 execute dump_accounts;
890 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
891 execute dump_users;
892 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
893 execute dump_hosts;
894 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
895 "================== con2 disconnected =================="
896 "================== Step 11 =================="
897 call dump_thread();
898 username status
899 user1 not found
900 username status
901 user2 not found
902 username event_name count_star
903 user3 wait/io/file/sql/query_log 7
904 user3 wait/synch/mutex/sql/LOCK_connection_count 0
905 user3 wait/synch/mutex/sql/LOCK_uuid_generator 2
906 username event_name count_star
907 user4 wait/io/file/sql/query_log 7
908 user4 wait/synch/mutex/sql/LOCK_connection_count 0
909 user4 wait/synch/mutex/sql/LOCK_uuid_generator 2
910 execute dump_waits_account;
911 user host event_name count_star
912 execute dump_waits_user;
913 user event_name count_star
914 execute dump_waits_host;
915 host event_name count_star
916 execute dump_waits_global;
917 event_name count_star
918 wait/io/file/sql/query_log 30
919 wait/synch/mutex/sql/LOCK_connection_count 2
920 wait/synch/mutex/sql/LOCK_uuid_generator 8
921 execute dump_waits_history;
922 event_name count(event_name)
923 wait/io/file/sql/query_log 30
924 wait/synch/mutex/sql/LOCK_connection_count 2
925 wait/synch/mutex/sql/LOCK_uuid_generator 8
926 execute dump_stages_account;
927 user host event_name count_star
928 execute dump_stages_user;
929 user event_name count_star
930 execute dump_stages_host;
931 host event_name count_star
932 execute dump_stages_global;
933 event_name count_star
934 stage/sql/checking permissions 16
935 stage/sql/closing tables 24
936 stage/sql/init 16
937 stage/sql/Opening tables 20
938 stage/sql/starting 34
939 execute dump_stages_history;
940 event_name count(event_name)
941 stage/sql/checking permissions 16
942 stage/sql/closing tables 24
943 stage/sql/init 16
944 stage/sql/Opening tables 20
945 stage/sql/starting 34
946 execute dump_statements_account;
947 user host event_name count_star
948 execute dump_statements_user;
949 user event_name count_star
950 execute dump_statements_host;
951 host event_name count_star
952 execute dump_statements_global;
953 event_name count_star
954 statement/com/Error 0
955 statement/com/Quit 2
956 statement/sp/freturn 4
957 statement/sql/insert 4
958 statement/sql/select 12
959 execute dump_statements_history;
960 event_name count(event_name)
961 statement/com/Quit 2
962 statement/sp/freturn 4
963 statement/sql/insert 4
964 statement/sql/select 12
965 execute dump_transactions_account;
966 user host event_name count_star
967 execute dump_transactions_user;
968 user event_name count_star
969 execute dump_transactions_host;
970 host event_name count_star
971 execute dump_transactions_global;
972 event_name count_star
973 transaction 4
974 execute dump_transactions_history;
975 event_name count(event_name)
976 transaction 4
977 execute dump_accounts;
978 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
979 execute dump_users;
980 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
981 execute dump_hosts;
982 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
983 "================== con3 disconnected =================="
984 "================== Step 12 =================="
985 call dump_thread();
986 username status
987 user1 not found
988 username status
989 user2 not found
990 username status
991 user3 not found
992 username event_name count_star
993 user4 wait/io/file/sql/query_log 7
994 user4 wait/synch/mutex/sql/LOCK_connection_count 0
995 user4 wait/synch/mutex/sql/LOCK_uuid_generator 2
996 execute dump_waits_account;
997 user host event_name count_star
998 execute dump_waits_user;
999 user event_name count_star
1000 execute dump_waits_host;
1001 host event_name count_star
1002 execute dump_waits_global;
1003 event_name count_star
1004 wait/io/file/sql/query_log 31
1005 wait/synch/mutex/sql/LOCK_connection_count 3
1006 wait/synch/mutex/sql/LOCK_uuid_generator 8
1007 execute dump_waits_history;
1008 event_name count(event_name)
1009 wait/io/file/sql/query_log 31
1010 wait/synch/mutex/sql/LOCK_connection_count 3
1011 wait/synch/mutex/sql/LOCK_uuid_generator 8
1012 execute dump_stages_account;
1013 user host event_name count_star
1014 execute dump_stages_user;
1015 user event_name count_star
1016 execute dump_stages_host;
1017 host event_name count_star
1018 execute dump_stages_global;
1019 event_name count_star
1020 stage/sql/checking permissions 16
1021 stage/sql/closing tables 24
1022 stage/sql/init 16
1023 stage/sql/Opening tables 20
1024 stage/sql/starting 35
1025 execute dump_stages_history;
1026 event_name count(event_name)
1027 stage/sql/checking permissions 16
1028 stage/sql/closing tables 24
1029 stage/sql/init 16
1030 stage/sql/Opening tables 20
1031 stage/sql/starting 35
1032 execute dump_statements_account;
1033 user host event_name count_star
1034 execute dump_statements_user;
1035 user event_name count_star
1036 execute dump_statements_host;
1037 host event_name count_star
1038 execute dump_statements_global;
1039 event_name count_star
1040 statement/com/Error 0
1041 statement/com/Quit 3
1042 statement/sp/freturn 4
1043 statement/sql/insert 4
1044 statement/sql/select 12
1045 execute dump_statements_history;
1046 event_name count(event_name)
1047 statement/com/Quit 3
1048 statement/sp/freturn 4
1049 statement/sql/insert 4
1050 statement/sql/select 12
1051 execute dump_transactions_account;
1052 user host event_name count_star
1053 execute dump_transactions_user;
1054 user event_name count_star
1055 execute dump_transactions_host;
1056 host event_name count_star
1057 execute dump_transactions_global;
1058 event_name count_star
1059 transaction 4
1060 execute dump_transactions_history;
1061 event_name count(event_name)
1062 transaction 4
1063 execute dump_accounts;
1064 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1065 execute dump_users;
1066 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1067 execute dump_hosts;
1068 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1069 "================== con4 disconnected =================="
1070 "================== Step 13 =================="
1071 call dump_thread();
1072 username status
1073 user1 not found
1074 username status
1075 user2 not found
1076 username status
1077 user3 not found
1078 username status
1079 user4 not found
1080 execute dump_waits_account;
1081 user host event_name count_star
1082 execute dump_waits_user;
1083 user event_name count_star
1084 execute dump_waits_host;
1085 host event_name count_star
1086 execute dump_waits_global;
1087 event_name count_star
1088 wait/io/file/sql/query_log 32
1089 wait/synch/mutex/sql/LOCK_connection_count 4
1090 wait/synch/mutex/sql/LOCK_uuid_generator 8
1091 execute dump_waits_history;
1092 event_name count(event_name)
1093 wait/io/file/sql/query_log 32
1094 wait/synch/mutex/sql/LOCK_connection_count 4
1095 wait/synch/mutex/sql/LOCK_uuid_generator 8
1096 execute dump_stages_account;
1097 user host event_name count_star
1098 execute dump_stages_user;
1099 user event_name count_star
1100 execute dump_stages_host;
1101 host event_name count_star
1102 execute dump_stages_global;
1103 event_name count_star
1104 stage/sql/checking permissions 16
1105 stage/sql/closing tables 24
1106 stage/sql/init 16
1107 stage/sql/Opening tables 20
1108 stage/sql/starting 36
1109 execute dump_stages_history;
1110 event_name count(event_name)
1111 stage/sql/checking permissions 16
1112 stage/sql/closing tables 24
1113 stage/sql/init 16
1114 stage/sql/Opening tables 20
1115 stage/sql/starting 36
1116 execute dump_statements_account;
1117 user host event_name count_star
1118 execute dump_statements_user;
1119 user event_name count_star
1120 execute dump_statements_host;
1121 host event_name count_star
1122 execute dump_statements_global;
1123 event_name count_star
1124 statement/com/Error 0
1125 statement/com/Quit 4
1126 statement/sp/freturn 4
1127 statement/sql/insert 4
1128 statement/sql/select 12
1129 execute dump_statements_history;
1130 event_name count(event_name)
1131 statement/com/Quit 4
1132 statement/sp/freturn 4
1133 statement/sql/insert 4
1134 statement/sql/select 12
1135 execute dump_transactions_account;
1136 user host event_name count_star
1137 execute dump_transactions_user;
1138 user event_name count_star
1139 execute dump_transactions_host;
1140 host event_name count_star
1141 execute dump_transactions_global;
1142 event_name count_star
1143 transaction 4
1144 execute dump_transactions_history;
1145 event_name count(event_name)
1146 transaction 4
1147 execute dump_accounts;
1148 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1149 execute dump_users;
1150 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1151 execute dump_hosts;
1152 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1153 truncate performance_schema.events_waits_summary_by_thread_by_event_name;
1154 "================== WAITS_BY_THREAD truncated =================="
1155 "================== Step 14 =================="
1156 call dump_thread();
1157 username status
1158 user1 not found
1159 username status
1160 user2 not found
1161 username status
1162 user3 not found
1163 username status
1164 user4 not found
1165 execute dump_waits_account;
1166 user host event_name count_star
1167 execute dump_waits_user;
1168 user event_name count_star
1169 execute dump_waits_host;
1170 host event_name count_star
1171 execute dump_waits_global;
1172 event_name count_star
1173 wait/io/file/sql/query_log 32
1174 wait/synch/mutex/sql/LOCK_connection_count 4
1175 wait/synch/mutex/sql/LOCK_uuid_generator 8
1176 execute dump_waits_history;
1177 event_name count(event_name)
1178 wait/io/file/sql/query_log 32
1179 wait/synch/mutex/sql/LOCK_connection_count 4
1180 wait/synch/mutex/sql/LOCK_uuid_generator 8
1181 execute dump_stages_account;
1182 user host event_name count_star
1183 execute dump_stages_user;
1184 user event_name count_star
1185 execute dump_stages_host;
1186 host event_name count_star
1187 execute dump_stages_global;
1188 event_name count_star
1189 stage/sql/checking permissions 16
1190 stage/sql/closing tables 24
1191 stage/sql/init 16
1192 stage/sql/Opening tables 20
1193 stage/sql/starting 36
1194 execute dump_stages_history;
1195 event_name count(event_name)
1196 stage/sql/checking permissions 16
1197 stage/sql/closing tables 24
1198 stage/sql/init 16
1199 stage/sql/Opening tables 20
1200 stage/sql/starting 36
1201 execute dump_statements_account;
1202 user host event_name count_star
1203 execute dump_statements_user;
1204 user event_name count_star
1205 execute dump_statements_host;
1206 host event_name count_star
1207 execute dump_statements_global;
1208 event_name count_star
1209 statement/com/Error 0
1210 statement/com/Quit 4
1211 statement/sp/freturn 4
1212 statement/sql/insert 4
1213 statement/sql/select 12
1214 execute dump_statements_history;
1215 event_name count(event_name)
1216 statement/com/Quit 4
1217 statement/sp/freturn 4
1218 statement/sql/insert 4
1219 statement/sql/select 12
1220 execute dump_transactions_account;
1221 user host event_name count_star
1222 execute dump_transactions_user;
1223 user event_name count_star
1224 execute dump_transactions_host;
1225 host event_name count_star
1226 execute dump_transactions_global;
1227 event_name count_star
1228 transaction 4
1229 execute dump_transactions_history;
1230 event_name count(event_name)
1231 transaction 4
1232 execute dump_accounts;
1233 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1234 execute dump_users;
1235 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1236 execute dump_hosts;
1237 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1238 truncate performance_schema.events_waits_summary_by_account_by_event_name;
1239 "================== WAITS_BY_ACCOUNT truncated =================="
1240 "================== Step 15 =================="
1241 call dump_thread();
1242 username status
1243 user1 not found
1244 username status
1245 user2 not found
1246 username status
1247 user3 not found
1248 username status
1249 user4 not found
1250 execute dump_waits_account;
1251 user host event_name count_star
1252 execute dump_waits_user;
1253 user event_name count_star
1254 execute dump_waits_host;
1255 host event_name count_star
1256 execute dump_waits_global;
1257 event_name count_star
1258 wait/io/file/sql/query_log 32
1259 wait/synch/mutex/sql/LOCK_connection_count 4
1260 wait/synch/mutex/sql/LOCK_uuid_generator 8
1261 execute dump_waits_history;
1262 event_name count(event_name)
1263 wait/io/file/sql/query_log 32
1264 wait/synch/mutex/sql/LOCK_connection_count 4
1265 wait/synch/mutex/sql/LOCK_uuid_generator 8
1266 execute dump_stages_account;
1267 user host event_name count_star
1268 execute dump_stages_user;
1269 user event_name count_star
1270 execute dump_stages_host;
1271 host event_name count_star
1272 execute dump_stages_global;
1273 event_name count_star
1274 stage/sql/checking permissions 16
1275 stage/sql/closing tables 24
1276 stage/sql/init 16
1277 stage/sql/Opening tables 20
1278 stage/sql/starting 36
1279 execute dump_stages_history;
1280 event_name count(event_name)
1281 stage/sql/checking permissions 16
1282 stage/sql/closing tables 24
1283 stage/sql/init 16
1284 stage/sql/Opening tables 20
1285 stage/sql/starting 36
1286 execute dump_statements_account;
1287 user host event_name count_star
1288 execute dump_statements_user;
1289 user event_name count_star
1290 execute dump_statements_host;
1291 host event_name count_star
1292 execute dump_statements_global;
1293 event_name count_star
1294 statement/com/Error 0
1295 statement/com/Quit 4
1296 statement/sp/freturn 4
1297 statement/sql/insert 4
1298 statement/sql/select 12
1299 execute dump_statements_history;
1300 event_name count(event_name)
1301 statement/com/Quit 4
1302 statement/sp/freturn 4
1303 statement/sql/insert 4
1304 statement/sql/select 12
1305 execute dump_transactions_account;
1306 user host event_name count_star
1307 execute dump_transactions_user;
1308 user event_name count_star
1309 execute dump_transactions_host;
1310 host event_name count_star
1311 execute dump_transactions_global;
1312 event_name count_star
1313 transaction 4
1314 execute dump_transactions_history;
1315 event_name count(event_name)
1316 transaction 4
1317 execute dump_accounts;
1318 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1319 execute dump_users;
1320 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1321 execute dump_hosts;
1322 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1323 truncate performance_schema.events_waits_summary_by_user_by_event_name;
1324 "================== WAITS_BY_USER truncated =================="
1325 "================== Step 16 =================="
1326 call dump_thread();
1327 username status
1328 user1 not found
1329 username status
1330 user2 not found
1331 username status
1332 user3 not found
1333 username status
1334 user4 not found
1335 execute dump_waits_account;
1336 user host event_name count_star
1337 execute dump_waits_user;
1338 user event_name count_star
1339 execute dump_waits_host;
1340 host event_name count_star
1341 execute dump_waits_global;
1342 event_name count_star
1343 wait/io/file/sql/query_log 32
1344 wait/synch/mutex/sql/LOCK_connection_count 4
1345 wait/synch/mutex/sql/LOCK_uuid_generator 8
1346 execute dump_waits_history;
1347 event_name count(event_name)
1348 wait/io/file/sql/query_log 32
1349 wait/synch/mutex/sql/LOCK_connection_count 4
1350 wait/synch/mutex/sql/LOCK_uuid_generator 8
1351 execute dump_stages_account;
1352 user host event_name count_star
1353 execute dump_stages_user;
1354 user event_name count_star
1355 execute dump_stages_host;
1356 host event_name count_star
1357 execute dump_stages_global;
1358 event_name count_star
1359 stage/sql/checking permissions 16
1360 stage/sql/closing tables 24
1361 stage/sql/init 16
1362 stage/sql/Opening tables 20
1363 stage/sql/starting 36
1364 execute dump_stages_history;
1365 event_name count(event_name)
1366 stage/sql/checking permissions 16
1367 stage/sql/closing tables 24
1368 stage/sql/init 16
1369 stage/sql/Opening tables 20
1370 stage/sql/starting 36
1371 execute dump_statements_account;
1372 user host event_name count_star
1373 execute dump_statements_user;
1374 user event_name count_star
1375 execute dump_statements_host;
1376 host event_name count_star
1377 execute dump_statements_global;
1378 event_name count_star
1379 statement/com/Error 0
1380 statement/com/Quit 4
1381 statement/sp/freturn 4
1382 statement/sql/insert 4
1383 statement/sql/select 12
1384 execute dump_statements_history;
1385 event_name count(event_name)
1386 statement/com/Quit 4
1387 statement/sp/freturn 4
1388 statement/sql/insert 4
1389 statement/sql/select 12
1390 execute dump_transactions_account;
1391 user host event_name count_star
1392 execute dump_transactions_user;
1393 user event_name count_star
1394 execute dump_transactions_host;
1395 host event_name count_star
1396 execute dump_transactions_global;
1397 event_name count_star
1398 transaction 4
1399 execute dump_transactions_history;
1400 event_name count(event_name)
1401 transaction 4
1402 execute dump_accounts;
1403 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1404 execute dump_users;
1405 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1406 execute dump_hosts;
1407 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1408 truncate performance_schema.events_waits_summary_by_host_by_event_name;
1409 "================== WAITS_BY_HOST truncated =================="
1410 "================== Step 17 =================="
1411 call dump_thread();
1412 username status
1413 user1 not found
1414 username status
1415 user2 not found
1416 username status
1417 user3 not found
1418 username status
1419 user4 not found
1420 execute dump_waits_account;
1421 user host event_name count_star
1422 execute dump_waits_user;
1423 user event_name count_star
1424 execute dump_waits_host;
1425 host event_name count_star
1426 execute dump_waits_global;
1427 event_name count_star
1428 wait/io/file/sql/query_log 32
1429 wait/synch/mutex/sql/LOCK_connection_count 4
1430 wait/synch/mutex/sql/LOCK_uuid_generator 8
1431 execute dump_waits_history;
1432 event_name count(event_name)
1433 wait/io/file/sql/query_log 32
1434 wait/synch/mutex/sql/LOCK_connection_count 4
1435 wait/synch/mutex/sql/LOCK_uuid_generator 8
1436 execute dump_stages_account;
1437 user host event_name count_star
1438 execute dump_stages_user;
1439 user event_name count_star
1440 execute dump_stages_host;
1441 host event_name count_star
1442 execute dump_stages_global;
1443 event_name count_star
1444 stage/sql/checking permissions 16
1445 stage/sql/closing tables 24
1446 stage/sql/init 16
1447 stage/sql/Opening tables 20
1448 stage/sql/starting 36
1449 execute dump_stages_history;
1450 event_name count(event_name)
1451 stage/sql/checking permissions 16
1452 stage/sql/closing tables 24
1453 stage/sql/init 16
1454 stage/sql/Opening tables 20
1455 stage/sql/starting 36
1456 execute dump_statements_account;
1457 user host event_name count_star
1458 execute dump_statements_user;
1459 user event_name count_star
1460 execute dump_statements_host;
1461 host event_name count_star
1462 execute dump_statements_global;
1463 event_name count_star
1464 statement/com/Error 0
1465 statement/com/Quit 4
1466 statement/sp/freturn 4
1467 statement/sql/insert 4
1468 statement/sql/select 12
1469 execute dump_statements_history;
1470 event_name count(event_name)
1471 statement/com/Quit 4
1472 statement/sp/freturn 4
1473 statement/sql/insert 4
1474 statement/sql/select 12
1475 execute dump_transactions_account;
1476 user host event_name count_star
1477 execute dump_transactions_user;
1478 user event_name count_star
1479 execute dump_transactions_host;
1480 host event_name count_star
1481 execute dump_transactions_global;
1482 event_name count_star
1483 transaction 4
1484 execute dump_transactions_history;
1485 event_name count(event_name)
1486 transaction 4
1487 execute dump_accounts;
1488 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1489 execute dump_users;
1490 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1491 execute dump_hosts;
1492 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1493 truncate performance_schema.events_waits_summary_global_by_event_name;
1494 "================== WAITS_GLOBAL truncated =================="
1495 "================== Step 18 =================="
1496 call dump_thread();
1497 username status
1498 user1 not found
1499 username status
1500 user2 not found
1501 username status
1502 user3 not found
1503 username status
1504 user4 not found
1505 execute dump_waits_account;
1506 user host event_name count_star
1507 execute dump_waits_user;
1508 user event_name count_star
1509 execute dump_waits_host;
1510 host event_name count_star
1511 execute dump_waits_global;
1512 event_name count_star
1513 wait/io/file/sql/query_log 0
1514 wait/synch/mutex/sql/LOCK_connection_count 0
1515 wait/synch/mutex/sql/LOCK_uuid_generator 0
1516 execute dump_waits_history;
1517 event_name count(event_name)
1518 wait/io/file/sql/query_log 32
1519 wait/synch/mutex/sql/LOCK_connection_count 4
1520 wait/synch/mutex/sql/LOCK_uuid_generator 8
1521 execute dump_stages_account;
1522 user host event_name count_star
1523 execute dump_stages_user;
1524 user event_name count_star
1525 execute dump_stages_host;
1526 host event_name count_star
1527 execute dump_stages_global;
1528 event_name count_star
1529 stage/sql/checking permissions 16
1530 stage/sql/closing tables 24
1531 stage/sql/init 16
1532 stage/sql/Opening tables 20
1533 stage/sql/starting 36
1534 execute dump_stages_history;
1535 event_name count(event_name)
1536 stage/sql/checking permissions 16
1537 stage/sql/closing tables 24
1538 stage/sql/init 16
1539 stage/sql/Opening tables 20
1540 stage/sql/starting 36
1541 execute dump_statements_account;
1542 user host event_name count_star
1543 execute dump_statements_user;
1544 user event_name count_star
1545 execute dump_statements_host;
1546 host event_name count_star
1547 execute dump_statements_global;
1548 event_name count_star
1549 statement/com/Error 0
1550 statement/com/Quit 4
1551 statement/sp/freturn 4
1552 statement/sql/insert 4
1553 statement/sql/select 12
1554 execute dump_statements_history;
1555 event_name count(event_name)
1556 statement/com/Quit 4
1557 statement/sp/freturn 4
1558 statement/sql/insert 4
1559 statement/sql/select 12
1560 execute dump_transactions_account;
1561 user host event_name count_star
1562 execute dump_transactions_user;
1563 user event_name count_star
1564 execute dump_transactions_host;
1565 host event_name count_star
1566 execute dump_transactions_global;
1567 event_name count_star
1568 transaction 4
1569 execute dump_transactions_history;
1570 event_name count(event_name)
1571 transaction 4
1572 execute dump_accounts;
1573 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1574 execute dump_users;
1575 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1576 execute dump_hosts;
1577 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1578 truncate performance_schema.events_stages_summary_by_thread_by_event_name;
1579 "================== STAGES_BY_THREAD truncated =================="
1580 "================== Step 19 =================="
1581 call dump_thread();
1582 username status
1583 user1 not found
1584 username status
1585 user2 not found
1586 username status
1587 user3 not found
1588 username status
1589 user4 not found
1590 execute dump_waits_account;
1591 user host event_name count_star
1592 execute dump_waits_user;
1593 user event_name count_star
1594 execute dump_waits_host;
1595 host event_name count_star
1596 execute dump_waits_global;
1597 event_name count_star
1598 wait/io/file/sql/query_log 0
1599 wait/synch/mutex/sql/LOCK_connection_count 0
1600 wait/synch/mutex/sql/LOCK_uuid_generator 0
1601 execute dump_waits_history;
1602 event_name count(event_name)
1603 wait/io/file/sql/query_log 32
1604 wait/synch/mutex/sql/LOCK_connection_count 4
1605 wait/synch/mutex/sql/LOCK_uuid_generator 8
1606 execute dump_stages_account;
1607 user host event_name count_star
1608 execute dump_stages_user;
1609 user event_name count_star
1610 execute dump_stages_host;
1611 host event_name count_star
1612 execute dump_stages_global;
1613 event_name count_star
1614 stage/sql/checking permissions 16
1615 stage/sql/closing tables 24
1616 stage/sql/init 16
1617 stage/sql/Opening tables 20
1618 stage/sql/starting 36
1619 execute dump_stages_history;
1620 event_name count(event_name)
1621 stage/sql/checking permissions 16
1622 stage/sql/closing tables 24
1623 stage/sql/init 16
1624 stage/sql/Opening tables 20
1625 stage/sql/starting 36
1626 execute dump_statements_account;
1627 user host event_name count_star
1628 execute dump_statements_user;
1629 user event_name count_star
1630 execute dump_statements_host;
1631 host event_name count_star
1632 execute dump_statements_global;
1633 event_name count_star
1634 statement/com/Error 0
1635 statement/com/Quit 4
1636 statement/sp/freturn 4
1637 statement/sql/insert 4
1638 statement/sql/select 12
1639 execute dump_statements_history;
1640 event_name count(event_name)
1641 statement/com/Quit 4
1642 statement/sp/freturn 4
1643 statement/sql/insert 4
1644 statement/sql/select 12
1645 execute dump_transactions_account;
1646 user host event_name count_star
1647 execute dump_transactions_user;
1648 user event_name count_star
1649 execute dump_transactions_host;
1650 host event_name count_star
1651 execute dump_transactions_global;
1652 event_name count_star
1653 transaction 4
1654 execute dump_transactions_history;
1655 event_name count(event_name)
1656 transaction 4
1657 execute dump_accounts;
1658 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1659 execute dump_users;
1660 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1661 execute dump_hosts;
1662 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1663 truncate performance_schema.events_stages_summary_by_account_by_event_name;
1664 "================== STAGES_BY_ACCOUNT truncated =================="
1665 "================== Step 20 =================="
1666 call dump_thread();
1667 username status
1668 user1 not found
1669 username status
1670 user2 not found
1671 username status
1672 user3 not found
1673 username status
1674 user4 not found
1675 execute dump_waits_account;
1676 user host event_name count_star
1677 execute dump_waits_user;
1678 user event_name count_star
1679 execute dump_waits_host;
1680 host event_name count_star
1681 execute dump_waits_global;
1682 event_name count_star
1683 wait/io/file/sql/query_log 0
1684 wait/synch/mutex/sql/LOCK_connection_count 0
1685 wait/synch/mutex/sql/LOCK_uuid_generator 0
1686 execute dump_waits_history;
1687 event_name count(event_name)
1688 wait/io/file/sql/query_log 32
1689 wait/synch/mutex/sql/LOCK_connection_count 4
1690 wait/synch/mutex/sql/LOCK_uuid_generator 8
1691 execute dump_stages_account;
1692 user host event_name count_star
1693 execute dump_stages_user;
1694 user event_name count_star
1695 execute dump_stages_host;
1696 host event_name count_star
1697 execute dump_stages_global;
1698 event_name count_star
1699 stage/sql/checking permissions 16
1700 stage/sql/closing tables 24
1701 stage/sql/init 16
1702 stage/sql/Opening tables 20
1703 stage/sql/starting 36
1704 execute dump_stages_history;
1705 event_name count(event_name)
1706 stage/sql/checking permissions 16
1707 stage/sql/closing tables 24
1708 stage/sql/init 16
1709 stage/sql/Opening tables 20
1710 stage/sql/starting 36
1711 execute dump_statements_account;
1712 user host event_name count_star
1713 execute dump_statements_user;
1714 user event_name count_star
1715 execute dump_statements_host;
1716 host event_name count_star
1717 execute dump_statements_global;
1718 event_name count_star
1719 statement/com/Error 0
1720 statement/com/Quit 4
1721 statement/sp/freturn 4
1722 statement/sql/insert 4
1723 statement/sql/select 12
1724 execute dump_statements_history;
1725 event_name count(event_name)
1726 statement/com/Quit 4
1727 statement/sp/freturn 4
1728 statement/sql/insert 4
1729 statement/sql/select 12
1730 execute dump_transactions_account;
1731 user host event_name count_star
1732 execute dump_transactions_user;
1733 user event_name count_star
1734 execute dump_transactions_host;
1735 host event_name count_star
1736 execute dump_transactions_global;
1737 event_name count_star
1738 transaction 4
1739 execute dump_transactions_history;
1740 event_name count(event_name)
1741 transaction 4
1742 execute dump_accounts;
1743 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1744 execute dump_users;
1745 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1746 execute dump_hosts;
1747 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1748 truncate performance_schema.events_stages_summary_by_user_by_event_name;
1749 "================== STAGES_BY_USER truncated =================="
1750 "================== Step 21 =================="
1751 call dump_thread();
1752 username status
1753 user1 not found
1754 username status
1755 user2 not found
1756 username status
1757 user3 not found
1758 username status
1759 user4 not found
1760 execute dump_waits_account;
1761 user host event_name count_star
1762 execute dump_waits_user;
1763 user event_name count_star
1764 execute dump_waits_host;
1765 host event_name count_star
1766 execute dump_waits_global;
1767 event_name count_star
1768 wait/io/file/sql/query_log 0
1769 wait/synch/mutex/sql/LOCK_connection_count 0
1770 wait/synch/mutex/sql/LOCK_uuid_generator 0
1771 execute dump_waits_history;
1772 event_name count(event_name)
1773 wait/io/file/sql/query_log 32
1774 wait/synch/mutex/sql/LOCK_connection_count 4
1775 wait/synch/mutex/sql/LOCK_uuid_generator 8
1776 execute dump_stages_account;
1777 user host event_name count_star
1778 execute dump_stages_user;
1779 user event_name count_star
1780 execute dump_stages_host;
1781 host event_name count_star
1782 execute dump_stages_global;
1783 event_name count_star
1784 stage/sql/checking permissions 16
1785 stage/sql/closing tables 24
1786 stage/sql/init 16
1787 stage/sql/Opening tables 20
1788 stage/sql/starting 36
1789 execute dump_stages_history;
1790 event_name count(event_name)
1791 stage/sql/checking permissions 16
1792 stage/sql/closing tables 24
1793 stage/sql/init 16
1794 stage/sql/Opening tables 20
1795 stage/sql/starting 36
1796 execute dump_statements_account;
1797 user host event_name count_star
1798 execute dump_statements_user;
1799 user event_name count_star
1800 execute dump_statements_host;
1801 host event_name count_star
1802 execute dump_statements_global;
1803 event_name count_star
1804 statement/com/Error 0
1805 statement/com/Quit 4
1806 statement/sp/freturn 4
1807 statement/sql/insert 4
1808 statement/sql/select 12
1809 execute dump_statements_history;
1810 event_name count(event_name)
1811 statement/com/Quit 4
1812 statement/sp/freturn 4
1813 statement/sql/insert 4
1814 statement/sql/select 12
1815 execute dump_transactions_account;
1816 user host event_name count_star
1817 execute dump_transactions_user;
1818 user event_name count_star
1819 execute dump_transactions_host;
1820 host event_name count_star
1821 execute dump_transactions_global;
1822 event_name count_star
1823 transaction 4
1824 execute dump_transactions_history;
1825 event_name count(event_name)
1826 transaction 4
1827 execute dump_accounts;
1828 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1829 execute dump_users;
1830 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1831 execute dump_hosts;
1832 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1833 truncate performance_schema.events_stages_summary_by_host_by_event_name;
1834 "================== STAGES_BY_HOST truncated =================="
1835 "================== Step 22 =================="
1836 call dump_thread();
1837 username status
1838 user1 not found
1839 username status
1840 user2 not found
1841 username status
1842 user3 not found
1843 username status
1844 user4 not found
1845 execute dump_waits_account;
1846 user host event_name count_star
1847 execute dump_waits_user;
1848 user event_name count_star
1849 execute dump_waits_host;
1850 host event_name count_star
1851 execute dump_waits_global;
1852 event_name count_star
1853 wait/io/file/sql/query_log 0
1854 wait/synch/mutex/sql/LOCK_connection_count 0
1855 wait/synch/mutex/sql/LOCK_uuid_generator 0
1856 execute dump_waits_history;
1857 event_name count(event_name)
1858 wait/io/file/sql/query_log 32
1859 wait/synch/mutex/sql/LOCK_connection_count 4
1860 wait/synch/mutex/sql/LOCK_uuid_generator 8
1861 execute dump_stages_account;
1862 user host event_name count_star
1863 execute dump_stages_user;
1864 user event_name count_star
1865 execute dump_stages_host;
1866 host event_name count_star
1867 execute dump_stages_global;
1868 event_name count_star
1869 stage/sql/checking permissions 16
1870 stage/sql/closing tables 24
1871 stage/sql/init 16
1872 stage/sql/Opening tables 20
1873 stage/sql/starting 36
1874 execute dump_stages_history;
1875 event_name count(event_name)
1876 stage/sql/checking permissions 16
1877 stage/sql/closing tables 24
1878 stage/sql/init 16
1879 stage/sql/Opening tables 20
1880 stage/sql/starting 36
1881 execute dump_statements_account;
1882 user host event_name count_star
1883 execute dump_statements_user;
1884 user event_name count_star
1885 execute dump_statements_host;
1886 host event_name count_star
1887 execute dump_statements_global;
1888 event_name count_star
1889 statement/com/Error 0
1890 statement/com/Quit 4
1891 statement/sp/freturn 4
1892 statement/sql/insert 4
1893 statement/sql/select 12
1894 execute dump_statements_history;
1895 event_name count(event_name)
1896 statement/com/Quit 4
1897 statement/sp/freturn 4
1898 statement/sql/insert 4
1899 statement/sql/select 12
1900 execute dump_transactions_account;
1901 user host event_name count_star
1902 execute dump_transactions_user;
1903 user event_name count_star
1904 execute dump_transactions_host;
1905 host event_name count_star
1906 execute dump_transactions_global;
1907 event_name count_star
1908 transaction 4
1909 execute dump_transactions_history;
1910 event_name count(event_name)
1911 transaction 4
1912 execute dump_accounts;
1913 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1914 execute dump_users;
1915 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1916 execute dump_hosts;
1917 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1918 truncate performance_schema.events_stages_summary_global_by_event_name;
1919 "================== STAGES_GLOBAL truncated =================="
1920 "================== Step 23 =================="
1921 call dump_thread();
1922 username status
1923 user1 not found
1924 username status
1925 user2 not found
1926 username status
1927 user3 not found
1928 username status
1929 user4 not found
1930 execute dump_waits_account;
1931 user host event_name count_star
1932 execute dump_waits_user;
1933 user event_name count_star
1934 execute dump_waits_host;
1935 host event_name count_star
1936 execute dump_waits_global;
1937 event_name count_star
1938 wait/io/file/sql/query_log 0
1939 wait/synch/mutex/sql/LOCK_connection_count 0
1940 wait/synch/mutex/sql/LOCK_uuid_generator 0
1941 execute dump_waits_history;
1942 event_name count(event_name)
1943 wait/io/file/sql/query_log 32
1944 wait/synch/mutex/sql/LOCK_connection_count 4
1945 wait/synch/mutex/sql/LOCK_uuid_generator 8
1946 execute dump_stages_account;
1947 user host event_name count_star
1948 execute dump_stages_user;
1949 user event_name count_star
1950 execute dump_stages_host;
1951 host event_name count_star
1952 execute dump_stages_global;
1953 event_name count_star
1954 stage/sql/checking permissions 0
1955 stage/sql/closing tables 0
1956 stage/sql/init 0
1957 stage/sql/Opening tables 0
1958 stage/sql/starting 0
1959 execute dump_stages_history;
1960 event_name count(event_name)
1961 stage/sql/checking permissions 16
1962 stage/sql/closing tables 24
1963 stage/sql/init 16
1964 stage/sql/Opening tables 20
1965 stage/sql/starting 36
1966 execute dump_statements_account;
1967 user host event_name count_star
1968 execute dump_statements_user;
1969 user event_name count_star
1970 execute dump_statements_host;
1971 host event_name count_star
1972 execute dump_statements_global;
1973 event_name count_star
1974 statement/com/Error 0
1975 statement/com/Quit 4
1976 statement/sp/freturn 4
1977 statement/sql/insert 4
1978 statement/sql/select 12
1979 execute dump_statements_history;
1980 event_name count(event_name)
1981 statement/com/Quit 4
1982 statement/sp/freturn 4
1983 statement/sql/insert 4
1984 statement/sql/select 12
1985 execute dump_transactions_account;
1986 user host event_name count_star
1987 execute dump_transactions_user;
1988 user event_name count_star
1989 execute dump_transactions_host;
1990 host event_name count_star
1991 execute dump_transactions_global;
1992 event_name count_star
1993 transaction 4
1994 execute dump_transactions_history;
1995 event_name count(event_name)
1996 transaction 4
1997 execute dump_accounts;
1998 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
1999 execute dump_users;
2000 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2001 execute dump_hosts;
2002 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2003 truncate performance_schema.events_statements_summary_by_thread_by_event_name;
2004 "================== STATEMENTS_BY_THREAD truncated =================="
2005 "================== Step 24 =================="
2006 call dump_thread();
2007 username status
2008 user1 not found
2009 username status
2010 user2 not found
2011 username status
2012 user3 not found
2013 username status
2014 user4 not found
2015 execute dump_waits_account;
2016 user host event_name count_star
2017 execute dump_waits_user;
2018 user event_name count_star
2019 execute dump_waits_host;
2020 host event_name count_star
2021 execute dump_waits_global;
2022 event_name count_star
2023 wait/io/file/sql/query_log 0
2024 wait/synch/mutex/sql/LOCK_connection_count 0
2025 wait/synch/mutex/sql/LOCK_uuid_generator 0
2026 execute dump_waits_history;
2027 event_name count(event_name)
2028 wait/io/file/sql/query_log 32
2029 wait/synch/mutex/sql/LOCK_connection_count 4
2030 wait/synch/mutex/sql/LOCK_uuid_generator 8
2031 execute dump_stages_account;
2032 user host event_name count_star
2033 execute dump_stages_user;
2034 user event_name count_star
2035 execute dump_stages_host;
2036 host event_name count_star
2037 execute dump_stages_global;
2038 event_name count_star
2039 stage/sql/checking permissions 0
2040 stage/sql/closing tables 0
2041 stage/sql/init 0
2042 stage/sql/Opening tables 0
2043 stage/sql/starting 0
2044 execute dump_stages_history;
2045 event_name count(event_name)
2046 stage/sql/checking permissions 16
2047 stage/sql/closing tables 24
2048 stage/sql/init 16
2049 stage/sql/Opening tables 20
2050 stage/sql/starting 36
2051 execute dump_statements_account;
2052 user host event_name count_star
2053 execute dump_statements_user;
2054 user event_name count_star
2055 execute dump_statements_host;
2056 host event_name count_star
2057 execute dump_statements_global;
2058 event_name count_star
2059 statement/com/Error 0
2060 statement/com/Quit 4
2061 statement/sp/freturn 4
2062 statement/sql/insert 4
2063 statement/sql/select 12
2064 execute dump_statements_history;
2065 event_name count(event_name)
2066 statement/com/Quit 4
2067 statement/sp/freturn 4
2068 statement/sql/insert 4
2069 statement/sql/select 12
2070 execute dump_transactions_account;
2071 user host event_name count_star
2072 execute dump_transactions_user;
2073 user event_name count_star
2074 execute dump_transactions_host;
2075 host event_name count_star
2076 execute dump_transactions_global;
2077 event_name count_star
2078 transaction 4
2079 execute dump_transactions_history;
2080 event_name count(event_name)
2081 transaction 4
2082 execute dump_accounts;
2083 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2084 execute dump_users;
2085 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2086 execute dump_hosts;
2087 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2088 truncate performance_schema.events_statements_summary_by_account_by_event_name;
2089 "================== STATEMENTS_BY_ACCOUNT truncated =================="
2090 "================== Step 25 =================="
2091 call dump_thread();
2092 username status
2093 user1 not found
2094 username status
2095 user2 not found
2096 username status
2097 user3 not found
2098 username status
2099 user4 not found
2100 execute dump_waits_account;
2101 user host event_name count_star
2102 execute dump_waits_user;
2103 user event_name count_star
2104 execute dump_waits_host;
2105 host event_name count_star
2106 execute dump_waits_global;
2107 event_name count_star
2108 wait/io/file/sql/query_log 0
2109 wait/synch/mutex/sql/LOCK_connection_count 0
2110 wait/synch/mutex/sql/LOCK_uuid_generator 0
2111 execute dump_waits_history;
2112 event_name count(event_name)
2113 wait/io/file/sql/query_log 32
2114 wait/synch/mutex/sql/LOCK_connection_count 4
2115 wait/synch/mutex/sql/LOCK_uuid_generator 8
2116 execute dump_stages_account;
2117 user host event_name count_star
2118 execute dump_stages_user;
2119 user event_name count_star
2120 execute dump_stages_host;
2121 host event_name count_star
2122 execute dump_stages_global;
2123 event_name count_star
2124 stage/sql/checking permissions 0
2125 stage/sql/closing tables 0
2126 stage/sql/init 0
2127 stage/sql/Opening tables 0
2128 stage/sql/starting 0
2129 execute dump_stages_history;
2130 event_name count(event_name)
2131 stage/sql/checking permissions 16
2132 stage/sql/closing tables 24
2133 stage/sql/init 16
2134 stage/sql/Opening tables 20
2135 stage/sql/starting 36
2136 execute dump_statements_account;
2137 user host event_name count_star
2138 execute dump_statements_user;
2139 user event_name count_star
2140 execute dump_statements_host;
2141 host event_name count_star
2142 execute dump_statements_global;
2143 event_name count_star
2144 statement/com/Error 0
2145 statement/com/Quit 4
2146 statement/sp/freturn 4
2147 statement/sql/insert 4
2148 statement/sql/select 12
2149 execute dump_statements_history;
2150 event_name count(event_name)
2151 statement/com/Quit 4
2152 statement/sp/freturn 4
2153 statement/sql/insert 4
2154 statement/sql/select 12
2155 execute dump_transactions_account;
2156 user host event_name count_star
2157 execute dump_transactions_user;
2158 user event_name count_star
2159 execute dump_transactions_host;
2160 host event_name count_star
2161 execute dump_transactions_global;
2162 event_name count_star
2163 transaction 4
2164 execute dump_transactions_history;
2165 event_name count(event_name)
2166 transaction 4
2167 execute dump_accounts;
2168 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2169 execute dump_users;
2170 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2171 execute dump_hosts;
2172 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2173 truncate performance_schema.events_statements_summary_by_user_by_event_name;
2174 "================== STATEMENTS_BY_USER truncated =================="
2175 "================== Step 26 =================="
2176 call dump_thread();
2177 username status
2178 user1 not found
2179 username status
2180 user2 not found
2181 username status
2182 user3 not found
2183 username status
2184 user4 not found
2185 execute dump_waits_account;
2186 user host event_name count_star
2187 execute dump_waits_user;
2188 user event_name count_star
2189 execute dump_waits_host;
2190 host event_name count_star
2191 execute dump_waits_global;
2192 event_name count_star
2193 wait/io/file/sql/query_log 0
2194 wait/synch/mutex/sql/LOCK_connection_count 0
2195 wait/synch/mutex/sql/LOCK_uuid_generator 0
2196 execute dump_waits_history;
2197 event_name count(event_name)
2198 wait/io/file/sql/query_log 32
2199 wait/synch/mutex/sql/LOCK_connection_count 4
2200 wait/synch/mutex/sql/LOCK_uuid_generator 8
2201 execute dump_stages_account;
2202 user host event_name count_star
2203 execute dump_stages_user;
2204 user event_name count_star
2205 execute dump_stages_host;
2206 host event_name count_star
2207 execute dump_stages_global;
2208 event_name count_star
2209 stage/sql/checking permissions 0
2210 stage/sql/closing tables 0
2211 stage/sql/init 0
2212 stage/sql/Opening tables 0
2213 stage/sql/starting 0
2214 execute dump_stages_history;
2215 event_name count(event_name)
2216 stage/sql/checking permissions 16
2217 stage/sql/closing tables 24
2218 stage/sql/init 16
2219 stage/sql/Opening tables 20
2220 stage/sql/starting 36
2221 execute dump_statements_account;
2222 user host event_name count_star
2223 execute dump_statements_user;
2224 user event_name count_star
2225 execute dump_statements_host;
2226 host event_name count_star
2227 execute dump_statements_global;
2228 event_name count_star
2229 statement/com/Error 0
2230 statement/com/Quit 4
2231 statement/sp/freturn 4
2232 statement/sql/insert 4
2233 statement/sql/select 12
2234 execute dump_statements_history;
2235 event_name count(event_name)
2236 statement/com/Quit 4
2237 statement/sp/freturn 4
2238 statement/sql/insert 4
2239 statement/sql/select 12
2240 execute dump_transactions_account;
2241 user host event_name count_star
2242 execute dump_transactions_user;
2243 user event_name count_star
2244 execute dump_transactions_host;
2245 host event_name count_star
2246 execute dump_transactions_global;
2247 event_name count_star
2248 transaction 4
2249 execute dump_transactions_history;
2250 event_name count(event_name)
2251 transaction 4
2252 execute dump_accounts;
2253 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2254 execute dump_users;
2255 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2256 execute dump_hosts;
2257 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2258 truncate performance_schema.events_statements_summary_by_host_by_event_name;
2259 "================== STATEMENTS_BY_HOST truncated =================="
2260 "================== Step 27 =================="
2261 call dump_thread();
2262 username status
2263 user1 not found
2264 username status
2265 user2 not found
2266 username status
2267 user3 not found
2268 username status
2269 user4 not found
2270 execute dump_waits_account;
2271 user host event_name count_star
2272 execute dump_waits_user;
2273 user event_name count_star
2274 execute dump_waits_host;
2275 host event_name count_star
2276 execute dump_waits_global;
2277 event_name count_star
2278 wait/io/file/sql/query_log 0
2279 wait/synch/mutex/sql/LOCK_connection_count 0
2280 wait/synch/mutex/sql/LOCK_uuid_generator 0
2281 execute dump_waits_history;
2282 event_name count(event_name)
2283 wait/io/file/sql/query_log 32
2284 wait/synch/mutex/sql/LOCK_connection_count 4
2285 wait/synch/mutex/sql/LOCK_uuid_generator 8
2286 execute dump_stages_account;
2287 user host event_name count_star
2288 execute dump_stages_user;
2289 user event_name count_star
2290 execute dump_stages_host;
2291 host event_name count_star
2292 execute dump_stages_global;
2293 event_name count_star
2294 stage/sql/checking permissions 0
2295 stage/sql/closing tables 0
2296 stage/sql/init 0
2297 stage/sql/Opening tables 0
2298 stage/sql/starting 0
2299 execute dump_stages_history;
2300 event_name count(event_name)
2301 stage/sql/checking permissions 16
2302 stage/sql/closing tables 24
2303 stage/sql/init 16
2304 stage/sql/Opening tables 20
2305 stage/sql/starting 36
2306 execute dump_statements_account;
2307 user host event_name count_star
2308 execute dump_statements_user;
2309 user event_name count_star
2310 execute dump_statements_host;
2311 host event_name count_star
2312 execute dump_statements_global;
2313 event_name count_star
2314 statement/com/Error 0
2315 statement/com/Quit 4
2316 statement/sp/freturn 4
2317 statement/sql/insert 4
2318 statement/sql/select 12
2319 execute dump_statements_history;
2320 event_name count(event_name)
2321 statement/com/Quit 4
2322 statement/sp/freturn 4
2323 statement/sql/insert 4
2324 statement/sql/select 12
2325 execute dump_transactions_account;
2326 user host event_name count_star
2327 execute dump_transactions_user;
2328 user event_name count_star
2329 execute dump_transactions_host;
2330 host event_name count_star
2331 execute dump_transactions_global;
2332 event_name count_star
2333 transaction 4
2334 execute dump_transactions_history;
2335 event_name count(event_name)
2336 transaction 4
2337 execute dump_accounts;
2338 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2339 execute dump_users;
2340 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2341 execute dump_hosts;
2342 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2343 truncate performance_schema.events_statements_summary_global_by_event_name;
2344 "================== STATEMENTS_GLOBAL truncated =================="
2345 "================== Step 28 =================="
2346 call dump_thread();
2347 username status
2348 user1 not found
2349 username status
2350 user2 not found
2351 username status
2352 user3 not found
2353 username status
2354 user4 not found
2355 execute dump_waits_account;
2356 user host event_name count_star
2357 execute dump_waits_user;
2358 user event_name count_star
2359 execute dump_waits_host;
2360 host event_name count_star
2361 execute dump_waits_global;
2362 event_name count_star
2363 wait/io/file/sql/query_log 0
2364 wait/synch/mutex/sql/LOCK_connection_count 0
2365 wait/synch/mutex/sql/LOCK_uuid_generator 0
2366 execute dump_waits_history;
2367 event_name count(event_name)
2368 wait/io/file/sql/query_log 32
2369 wait/synch/mutex/sql/LOCK_connection_count 4
2370 wait/synch/mutex/sql/LOCK_uuid_generator 8
2371 execute dump_stages_account;
2372 user host event_name count_star
2373 execute dump_stages_user;
2374 user event_name count_star
2375 execute dump_stages_host;
2376 host event_name count_star
2377 execute dump_stages_global;
2378 event_name count_star
2379 stage/sql/checking permissions 0
2380 stage/sql/closing tables 0
2381 stage/sql/init 0
2382 stage/sql/Opening tables 0
2383 stage/sql/starting 0
2384 execute dump_stages_history;
2385 event_name count(event_name)
2386 stage/sql/checking permissions 16
2387 stage/sql/closing tables 24
2388 stage/sql/init 16
2389 stage/sql/Opening tables 20
2390 stage/sql/starting 36
2391 execute dump_statements_account;
2392 user host event_name count_star
2393 execute dump_statements_user;
2394 user event_name count_star
2395 execute dump_statements_host;
2396 host event_name count_star
2397 execute dump_statements_global;
2398 event_name count_star
2399 statement/com/Error 0
2400 statement/com/Quit 0
2401 statement/sp/freturn 0
2402 statement/sql/insert 0
2403 statement/sql/select 0
2404 execute dump_statements_history;
2405 event_name count(event_name)
2406 statement/com/Quit 4
2407 statement/sp/freturn 4
2408 statement/sql/insert 4
2409 statement/sql/select 12
2410 execute dump_transactions_account;
2411 user host event_name count_star
2412 execute dump_transactions_user;
2413 user event_name count_star
2414 execute dump_transactions_host;
2415 host event_name count_star
2416 execute dump_transactions_global;
2417 event_name count_star
2418 transaction 4
2419 execute dump_transactions_history;
2420 event_name count(event_name)
2421 transaction 4
2422 execute dump_accounts;
2423 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2424 execute dump_users;
2425 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2426 execute dump_hosts;
2427 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2428 truncate performance_schema.events_transactions_summary_by_thread_by_event_name;
2429 "================== TRANSACTIONS_BY_THREAD truncated =================="
2430 "================== Step 29 =================="
2431 call dump_thread();
2432 username status
2433 user1 not found
2434 username status
2435 user2 not found
2436 username status
2437 user3 not found
2438 username status
2439 user4 not found
2440 execute dump_waits_account;
2441 user host event_name count_star
2442 execute dump_waits_user;
2443 user event_name count_star
2444 execute dump_waits_host;
2445 host event_name count_star
2446 execute dump_waits_global;
2447 event_name count_star
2448 wait/io/file/sql/query_log 0
2449 wait/synch/mutex/sql/LOCK_connection_count 0
2450 wait/synch/mutex/sql/LOCK_uuid_generator 0
2451 execute dump_waits_history;
2452 event_name count(event_name)
2453 wait/io/file/sql/query_log 32
2454 wait/synch/mutex/sql/LOCK_connection_count 4
2455 wait/synch/mutex/sql/LOCK_uuid_generator 8
2456 execute dump_stages_account;
2457 user host event_name count_star
2458 execute dump_stages_user;
2459 user event_name count_star
2460 execute dump_stages_host;
2461 host event_name count_star
2462 execute dump_stages_global;
2463 event_name count_star
2464 stage/sql/checking permissions 0
2465 stage/sql/closing tables 0
2466 stage/sql/init 0
2467 stage/sql/Opening tables 0
2468 stage/sql/starting 0
2469 execute dump_stages_history;
2470 event_name count(event_name)
2471 stage/sql/checking permissions 16
2472 stage/sql/closing tables 24
2473 stage/sql/init 16
2474 stage/sql/Opening tables 20
2475 stage/sql/starting 36
2476 execute dump_statements_account;
2477 user host event_name count_star
2478 execute dump_statements_user;
2479 user event_name count_star
2480 execute dump_statements_host;
2481 host event_name count_star
2482 execute dump_statements_global;
2483 event_name count_star
2484 statement/com/Error 0
2485 statement/com/Quit 0
2486 statement/sp/freturn 0
2487 statement/sql/insert 0
2488 statement/sql/select 0
2489 execute dump_statements_history;
2490 event_name count(event_name)
2491 statement/com/Quit 4
2492 statement/sp/freturn 4
2493 statement/sql/insert 4
2494 statement/sql/select 12
2495 execute dump_transactions_account;
2496 user host event_name count_star
2497 execute dump_transactions_user;
2498 user event_name count_star
2499 execute dump_transactions_host;
2500 host event_name count_star
2501 execute dump_transactions_global;
2502 event_name count_star
2503 transaction 4
2504 execute dump_transactions_history;
2505 event_name count(event_name)
2506 transaction 4
2507 execute dump_accounts;
2508 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2509 execute dump_users;
2510 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2511 execute dump_hosts;
2512 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2513 truncate performance_schema.events_transactions_summary_by_account_by_event_name;
2514 "================== TRANSACTIONS_BY_ACCOUNT truncated =================="
2515 "================== Step 30 =================="
2516 call dump_thread();
2517 username status
2518 user1 not found
2519 username status
2520 user2 not found
2521 username status
2522 user3 not found
2523 username status
2524 user4 not found
2525 execute dump_waits_account;
2526 user host event_name count_star
2527 execute dump_waits_user;
2528 user event_name count_star
2529 execute dump_waits_host;
2530 host event_name count_star
2531 execute dump_waits_global;
2532 event_name count_star
2533 wait/io/file/sql/query_log 0
2534 wait/synch/mutex/sql/LOCK_connection_count 0
2535 wait/synch/mutex/sql/LOCK_uuid_generator 0
2536 execute dump_waits_history;
2537 event_name count(event_name)
2538 wait/io/file/sql/query_log 32
2539 wait/synch/mutex/sql/LOCK_connection_count 4
2540 wait/synch/mutex/sql/LOCK_uuid_generator 8
2541 execute dump_stages_account;
2542 user host event_name count_star
2543 execute dump_stages_user;
2544 user event_name count_star
2545 execute dump_stages_host;
2546 host event_name count_star
2547 execute dump_stages_global;
2548 event_name count_star
2549 stage/sql/checking permissions 0
2550 stage/sql/closing tables 0
2551 stage/sql/init 0
2552 stage/sql/Opening tables 0
2553 stage/sql/starting 0
2554 execute dump_stages_history;
2555 event_name count(event_name)
2556 stage/sql/checking permissions 16
2557 stage/sql/closing tables 24
2558 stage/sql/init 16
2559 stage/sql/Opening tables 20
2560 stage/sql/starting 36
2561 execute dump_statements_account;
2562 user host event_name count_star
2563 execute dump_statements_user;
2564 user event_name count_star
2565 execute dump_statements_host;
2566 host event_name count_star
2567 execute dump_statements_global;
2568 event_name count_star
2569 statement/com/Error 0
2570 statement/com/Quit 0
2571 statement/sp/freturn 0
2572 statement/sql/insert 0
2573 statement/sql/select 0
2574 execute dump_statements_history;
2575 event_name count(event_name)
2576 statement/com/Quit 4
2577 statement/sp/freturn 4
2578 statement/sql/insert 4
2579 statement/sql/select 12
2580 execute dump_transactions_account;
2581 user host event_name count_star
2582 execute dump_transactions_user;
2583 user event_name count_star
2584 execute dump_transactions_host;
2585 host event_name count_star
2586 execute dump_transactions_global;
2587 event_name count_star
2588 transaction 4
2589 execute dump_transactions_history;
2590 event_name count(event_name)
2591 transaction 4
2592 execute dump_accounts;
2593 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2594 execute dump_users;
2595 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2596 execute dump_hosts;
2597 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2598 truncate performance_schema.events_transactions_summary_by_user_by_event_name;
2599 "================== TRANSACTIONS_BY_USER truncated =================="
2600 "================== Step 31 =================="
2601 call dump_thread();
2602 username status
2603 user1 not found
2604 username status
2605 user2 not found
2606 username status
2607 user3 not found
2608 username status
2609 user4 not found
2610 execute dump_waits_account;
2611 user host event_name count_star
2612 execute dump_waits_user;
2613 user event_name count_star
2614 execute dump_waits_host;
2615 host event_name count_star
2616 execute dump_waits_global;
2617 event_name count_star
2618 wait/io/file/sql/query_log 0
2619 wait/synch/mutex/sql/LOCK_connection_count 0
2620 wait/synch/mutex/sql/LOCK_uuid_generator 0
2621 execute dump_waits_history;
2622 event_name count(event_name)
2623 wait/io/file/sql/query_log 32
2624 wait/synch/mutex/sql/LOCK_connection_count 4
2625 wait/synch/mutex/sql/LOCK_uuid_generator 8
2626 execute dump_stages_account;
2627 user host event_name count_star
2628 execute dump_stages_user;
2629 user event_name count_star
2630 execute dump_stages_host;
2631 host event_name count_star
2632 execute dump_stages_global;
2633 event_name count_star
2634 stage/sql/checking permissions 0
2635 stage/sql/closing tables 0
2636 stage/sql/init 0
2637 stage/sql/Opening tables 0
2638 stage/sql/starting 0
2639 execute dump_stages_history;
2640 event_name count(event_name)
2641 stage/sql/checking permissions 16
2642 stage/sql/closing tables 24
2643 stage/sql/init 16
2644 stage/sql/Opening tables 20
2645 stage/sql/starting 36
2646 execute dump_statements_account;
2647 user host event_name count_star
2648 execute dump_statements_user;
2649 user event_name count_star
2650 execute dump_statements_host;
2651 host event_name count_star
2652 execute dump_statements_global;
2653 event_name count_star
2654 statement/com/Error 0
2655 statement/com/Quit 0
2656 statement/sp/freturn 0
2657 statement/sql/insert 0
2658 statement/sql/select 0
2659 execute dump_statements_history;
2660 event_name count(event_name)
2661 statement/com/Quit 4
2662 statement/sp/freturn 4
2663 statement/sql/insert 4
2664 statement/sql/select 12
2665 execute dump_transactions_account;
2666 user host event_name count_star
2667 execute dump_transactions_user;
2668 user event_name count_star
2669 execute dump_transactions_host;
2670 host event_name count_star
2671 execute dump_transactions_global;
2672 event_name count_star
2673 transaction 4
2674 execute dump_transactions_history;
2675 event_name count(event_name)
2676 transaction 4
2677 execute dump_accounts;
2678 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2679 execute dump_users;
2680 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2681 execute dump_hosts;
2682 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2683 truncate performance_schema.events_transactions_summary_by_host_by_event_name;
2684 "================== TRANSACTIONS_BY_HOST truncated =================="
2685 "================== Step 32 =================="
2686 call dump_thread();
2687 username status
2688 user1 not found
2689 username status
2690 user2 not found
2691 username status
2692 user3 not found
2693 username status
2694 user4 not found
2695 execute dump_waits_account;
2696 user host event_name count_star
2697 execute dump_waits_user;
2698 user event_name count_star
2699 execute dump_waits_host;
2700 host event_name count_star
2701 execute dump_waits_global;
2702 event_name count_star
2703 wait/io/file/sql/query_log 0
2704 wait/synch/mutex/sql/LOCK_connection_count 0
2705 wait/synch/mutex/sql/LOCK_uuid_generator 0
2706 execute dump_waits_history;
2707 event_name count(event_name)
2708 wait/io/file/sql/query_log 32
2709 wait/synch/mutex/sql/LOCK_connection_count 4
2710 wait/synch/mutex/sql/LOCK_uuid_generator 8
2711 execute dump_stages_account;
2712 user host event_name count_star
2713 execute dump_stages_user;
2714 user event_name count_star
2715 execute dump_stages_host;
2716 host event_name count_star
2717 execute dump_stages_global;
2718 event_name count_star
2719 stage/sql/checking permissions 0
2720 stage/sql/closing tables 0
2721 stage/sql/init 0
2722 stage/sql/Opening tables 0
2723 stage/sql/starting 0
2724 execute dump_stages_history;
2725 event_name count(event_name)
2726 stage/sql/checking permissions 16
2727 stage/sql/closing tables 24
2728 stage/sql/init 16
2729 stage/sql/Opening tables 20
2730 stage/sql/starting 36
2731 execute dump_statements_account;
2732 user host event_name count_star
2733 execute dump_statements_user;
2734 user event_name count_star
2735 execute dump_statements_host;
2736 host event_name count_star
2737 execute dump_statements_global;
2738 event_name count_star
2739 statement/com/Error 0
2740 statement/com/Quit 0
2741 statement/sp/freturn 0
2742 statement/sql/insert 0
2743 statement/sql/select 0
2744 execute dump_statements_history;
2745 event_name count(event_name)
2746 statement/com/Quit 4
2747 statement/sp/freturn 4
2748 statement/sql/insert 4
2749 statement/sql/select 12
2750 execute dump_transactions_account;
2751 user host event_name count_star
2752 execute dump_transactions_user;
2753 user event_name count_star
2754 execute dump_transactions_host;
2755 host event_name count_star
2756 execute dump_transactions_global;
2757 event_name count_star
2758 transaction 4
2759 execute dump_transactions_history;
2760 event_name count(event_name)
2761 transaction 4
2762 execute dump_accounts;
2763 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2764 execute dump_users;
2765 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2766 execute dump_hosts;
2767 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2768 truncate performance_schema.events_transactions_summary_global_by_event_name;
2769 "================== TRANSACTIONS_GLOBAL truncated =================="
2770 "================== Step 33 =================="
2771 call dump_thread();
2772 username status
2773 user1 not found
2774 username status
2775 user2 not found
2776 username status
2777 user3 not found
2778 username status
2779 user4 not found
2780 execute dump_waits_account;
2781 user host event_name count_star
2782 execute dump_waits_user;
2783 user event_name count_star
2784 execute dump_waits_host;
2785 host event_name count_star
2786 execute dump_waits_global;
2787 event_name count_star
2788 wait/io/file/sql/query_log 0
2789 wait/synch/mutex/sql/LOCK_connection_count 0
2790 wait/synch/mutex/sql/LOCK_uuid_generator 0
2791 execute dump_waits_history;
2792 event_name count(event_name)
2793 wait/io/file/sql/query_log 32
2794 wait/synch/mutex/sql/LOCK_connection_count 4
2795 wait/synch/mutex/sql/LOCK_uuid_generator 8
2796 execute dump_stages_account;
2797 user host event_name count_star
2798 execute dump_stages_user;
2799 user event_name count_star
2800 execute dump_stages_host;
2801 host event_name count_star
2802 execute dump_stages_global;
2803 event_name count_star
2804 stage/sql/checking permissions 0
2805 stage/sql/closing tables 0
2806 stage/sql/init 0
2807 stage/sql/Opening tables 0
2808 stage/sql/starting 0
2809 execute dump_stages_history;
2810 event_name count(event_name)
2811 stage/sql/checking permissions 16
2812 stage/sql/closing tables 24
2813 stage/sql/init 16
2814 stage/sql/Opening tables 20
2815 stage/sql/starting 36
2816 execute dump_statements_account;
2817 user host event_name count_star
2818 execute dump_statements_user;
2819 user event_name count_star
2820 execute dump_statements_host;
2821 host event_name count_star
2822 execute dump_statements_global;
2823 event_name count_star
2824 statement/com/Error 0
2825 statement/com/Quit 0
2826 statement/sp/freturn 0
2827 statement/sql/insert 0
2828 statement/sql/select 0
2829 execute dump_statements_history;
2830 event_name count(event_name)
2831 statement/com/Quit 4
2832 statement/sp/freturn 4
2833 statement/sql/insert 4
2834 statement/sql/select 12
2835 execute dump_transactions_account;
2836 user host event_name count_star
2837 execute dump_transactions_user;
2838 user event_name count_star
2839 execute dump_transactions_host;
2840 host event_name count_star
2841 execute dump_transactions_global;
2842 event_name count_star
2843 transaction 0
2844 execute dump_transactions_history;
2845 event_name count(event_name)
2846 transaction 4
2847 execute dump_accounts;
2848 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2849 execute dump_users;
2850 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2851 execute dump_hosts;
2852 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2853 truncate performance_schema.accounts;
2854 "================== ACCOUNTS truncated =================="
2855 "================== Step 34 =================="
2856 call dump_thread();
2857 username status
2858 user1 not found
2859 username status
2860 user2 not found
2861 username status
2862 user3 not found
2863 username status
2864 user4 not found
2865 execute dump_waits_account;
2866 user host event_name count_star
2867 execute dump_waits_user;
2868 user event_name count_star
2869 execute dump_waits_host;
2870 host event_name count_star
2871 execute dump_waits_global;
2872 event_name count_star
2873 wait/io/file/sql/query_log 0
2874 wait/synch/mutex/sql/LOCK_connection_count 0
2875 wait/synch/mutex/sql/LOCK_uuid_generator 0
2876 execute dump_waits_history;
2877 event_name count(event_name)
2878 wait/io/file/sql/query_log 32
2879 wait/synch/mutex/sql/LOCK_connection_count 4
2880 wait/synch/mutex/sql/LOCK_uuid_generator 8
2881 execute dump_stages_account;
2882 user host event_name count_star
2883 execute dump_stages_user;
2884 user event_name count_star
2885 execute dump_stages_host;
2886 host event_name count_star
2887 execute dump_stages_global;
2888 event_name count_star
2889 stage/sql/checking permissions 0
2890 stage/sql/closing tables 0
2891 stage/sql/init 0
2892 stage/sql/Opening tables 0
2893 stage/sql/starting 0
2894 execute dump_stages_history;
2895 event_name count(event_name)
2896 stage/sql/checking permissions 16
2897 stage/sql/closing tables 24
2898 stage/sql/init 16
2899 stage/sql/Opening tables 20
2900 stage/sql/starting 36
2901 execute dump_statements_account;
2902 user host event_name count_star
2903 execute dump_statements_user;
2904 user event_name count_star
2905 execute dump_statements_host;
2906 host event_name count_star
2907 execute dump_statements_global;
2908 event_name count_star
2909 statement/com/Error 0
2910 statement/com/Quit 0
2911 statement/sp/freturn 0
2912 statement/sql/insert 0
2913 statement/sql/select 0
2914 execute dump_statements_history;
2915 event_name count(event_name)
2916 statement/com/Quit 4
2917 statement/sp/freturn 4
2918 statement/sql/insert 4
2919 statement/sql/select 12
2920 execute dump_transactions_account;
2921 user host event_name count_star
2922 execute dump_transactions_user;
2923 user event_name count_star
2924 execute dump_transactions_host;
2925 host event_name count_star
2926 execute dump_transactions_global;
2927 event_name count_star
2928 transaction 0
2929 execute dump_transactions_history;
2930 event_name count(event_name)
2931 transaction 4
2932 execute dump_accounts;
2933 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2934 execute dump_users;
2935 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2936 execute dump_hosts;
2937 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
2938 truncate performance_schema.users;
2939 "================== USERS truncated =================="
2940 "================== Step 35 =================="
2941 call dump_thread();
2942 username status
2943 user1 not found
2944 username status
2945 user2 not found
2946 username status
2947 user3 not found
2948 username status
2949 user4 not found
2950 execute dump_waits_account;
2951 user host event_name count_star
2952 execute dump_waits_user;
2953 user event_name count_star
2954 execute dump_waits_host;
2955 host event_name count_star
2956 execute dump_waits_global;
2957 event_name count_star
2958 wait/io/file/sql/query_log 0
2959 wait/synch/mutex/sql/LOCK_connection_count 0
2960 wait/synch/mutex/sql/LOCK_uuid_generator 0
2961 execute dump_waits_history;
2962 event_name count(event_name)
2963 wait/io/file/sql/query_log 32
2964 wait/synch/mutex/sql/LOCK_connection_count 4
2965 wait/synch/mutex/sql/LOCK_uuid_generator 8
2966 execute dump_stages_account;
2967 user host event_name count_star
2968 execute dump_stages_user;
2969 user event_name count_star
2970 execute dump_stages_host;
2971 host event_name count_star
2972 execute dump_stages_global;
2973 event_name count_star
2974 stage/sql/checking permissions 0
2975 stage/sql/closing tables 0
2976 stage/sql/init 0
2977 stage/sql/Opening tables 0
2978 stage/sql/starting 0
2979 execute dump_stages_history;
2980 event_name count(event_name)
2981 stage/sql/checking permissions 16
2982 stage/sql/closing tables 24
2983 stage/sql/init 16
2984 stage/sql/Opening tables 20
2985 stage/sql/starting 36
2986 execute dump_statements_account;
2987 user host event_name count_star
2988 execute dump_statements_user;
2989 user event_name count_star
2990 execute dump_statements_host;
2991 host event_name count_star
2992 execute dump_statements_global;
2993 event_name count_star
2994 statement/com/Error 0
2995 statement/com/Quit 0
2996 statement/sp/freturn 0
2997 statement/sql/insert 0
2998 statement/sql/select 0
2999 execute dump_statements_history;
3000 event_name count(event_name)
3001 statement/com/Quit 4
3002 statement/sp/freturn 4
3003 statement/sql/insert 4
3004 statement/sql/select 12
3005 execute dump_transactions_account;
3006 user host event_name count_star
3007 execute dump_transactions_user;
3008 user event_name count_star
3009 execute dump_transactions_host;
3010 host event_name count_star
3011 execute dump_transactions_global;
3012 event_name count_star
3013 transaction 0
3014 execute dump_transactions_history;
3015 event_name count(event_name)
3016 transaction 4
3017 execute dump_accounts;
3018 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3019 execute dump_users;
3020 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3021 execute dump_hosts;
3022 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3023 truncate performance_schema.hosts;
3024 "================== HOSTS truncated =================="
3025 "================== Step 36 =================="
3026 call dump_thread();
3027 username status
3028 user1 not found
3029 username status
3030 user2 not found
3031 username status
3032 user3 not found
3033 username status
3034 user4 not found
3035 execute dump_waits_account;
3036 user host event_name count_star
3037 execute dump_waits_user;
3038 user event_name count_star
3039 execute dump_waits_host;
3040 host event_name count_star
3041 execute dump_waits_global;
3042 event_name count_star
3043 wait/io/file/sql/query_log 0
3044 wait/synch/mutex/sql/LOCK_connection_count 0
3045 wait/synch/mutex/sql/LOCK_uuid_generator 0
3046 execute dump_waits_history;
3047 event_name count(event_name)
3048 wait/io/file/sql/query_log 32
3049 wait/synch/mutex/sql/LOCK_connection_count 4
3050 wait/synch/mutex/sql/LOCK_uuid_generator 8
3051 execute dump_stages_account;
3052 user host event_name count_star
3053 execute dump_stages_user;
3054 user event_name count_star
3055 execute dump_stages_host;
3056 host event_name count_star
3057 execute dump_stages_global;
3058 event_name count_star
3059 stage/sql/checking permissions 0
3060 stage/sql/closing tables 0
3061 stage/sql/init 0
3062 stage/sql/Opening tables 0
3063 stage/sql/starting 0
3064 execute dump_stages_history;
3065 event_name count(event_name)
3066 stage/sql/checking permissions 16
3067 stage/sql/closing tables 24
3068 stage/sql/init 16
3069 stage/sql/Opening tables 20
3070 stage/sql/starting 36
3071 execute dump_statements_account;
3072 user host event_name count_star
3073 execute dump_statements_user;
3074 user event_name count_star
3075 execute dump_statements_host;
3076 host event_name count_star
3077 execute dump_statements_global;
3078 event_name count_star
3079 statement/com/Error 0
3080 statement/com/Quit 0
3081 statement/sp/freturn 0
3082 statement/sql/insert 0
3083 statement/sql/select 0
3084 execute dump_statements_history;
3085 event_name count(event_name)
3086 statement/com/Quit 4
3087 statement/sp/freturn 4
3088 statement/sql/insert 4
3089 statement/sql/select 12
3090 execute dump_transactions_account;
3091 user host event_name count_star
3092 execute dump_transactions_user;
3093 user event_name count_star
3094 execute dump_transactions_host;
3095 host event_name count_star
3096 execute dump_transactions_global;
3097 event_name count_star
3098 transaction 0
3099 execute dump_transactions_history;
3100 event_name count(event_name)
3101 transaction 4
3102 execute dump_accounts;
3103 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3104 execute dump_users;
3105 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
3106 execute dump_hosts;
3107 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS