Debian Codegraph @

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