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