Debian Codegraph @

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

raw
1 call dump_all();
2 processlist_user processlist_host
3 event_scheduler localhost
4 root localhost
5 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
6 event_scheduler localhost 1 1
7 root localhost 1 1
8 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
9 event_scheduler 1 1
10 root 1 1
11 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
12 localhost 2 2
13 variable_name variable_value
14 Performance_schema_accounts_lost 0
15 Performance_schema_hosts_lost 0
16 Performance_schema_users_lost 0
17 select "user1 in con1a" as status;
18 status
19 user1 in con1a
20 call dump_all();
21 processlist_user processlist_host
22 event_scheduler localhost
23 root localhost
24 user1 localhost
25 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
26 event_scheduler localhost 1 1
27 root localhost 1 1
28 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
29 event_scheduler 1 1
30 root 1 1
31 user1 1 1
32 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
33 localhost 3 3
34 variable_name variable_value
35 Performance_schema_accounts_lost 1
36 Performance_schema_hosts_lost 0
37 Performance_schema_users_lost 0
38 select "user1 in con1b" as status;
39 status
40 user1 in con1b
41 call dump_all();
42 processlist_user processlist_host
43 event_scheduler localhost
44 root localhost
45 user1 localhost
46 user1 localhost
47 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
48 event_scheduler localhost 1 1
49 root localhost 1 1
50 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
51 event_scheduler 1 1
52 root 1 1
53 user1 2 2
54 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
55 localhost 4 4
56 variable_name variable_value
57 Performance_schema_accounts_lost 2
58 Performance_schema_hosts_lost 0
59 Performance_schema_users_lost 0
60 select "user1 in con1c" as status;
61 status
62 user1 in con1c
63 call dump_all();
64 processlist_user processlist_host
65 event_scheduler localhost
66 root localhost
67 user1 localhost
68 user1 localhost
69 user1 localhost
70 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
71 event_scheduler localhost 1 1
72 root localhost 1 1
73 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
74 event_scheduler 1 1
75 root 1 1
76 user1 3 3
77 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
78 localhost 5 5
79 variable_name variable_value
80 Performance_schema_accounts_lost 3
81 Performance_schema_hosts_lost 0
82 Performance_schema_users_lost 0
83 select "user2 in con2a" as status;
84 status
85 user2 in con2a
86 call dump_all();
87 processlist_user processlist_host
88 event_scheduler localhost
89 root localhost
90 user1 localhost
91 user1 localhost
92 user1 localhost
93 user2 localhost
94 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
95 event_scheduler localhost 1 1
96 root localhost 1 1
97 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
98 event_scheduler 1 1
99 root 1 1
100 user1 3 3
101 user2 1 1
102 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
103 localhost 6 6
104 variable_name variable_value
105 Performance_schema_accounts_lost 4
106 Performance_schema_hosts_lost 0
107 Performance_schema_users_lost 0
108 select "user2 in con2b" as status;
109 status
110 user2 in con2b
111 call dump_all();
112 processlist_user processlist_host
113 event_scheduler localhost
114 root localhost
115 user1 localhost
116 user1 localhost
117 user1 localhost
118 user2 localhost
119 user2 localhost
120 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
121 event_scheduler localhost 1 1
122 root localhost 1 1
123 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
124 event_scheduler 1 1
125 root 1 1
126 user1 3 3
127 user2 2 2
128 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
129 localhost 7 7
130 variable_name variable_value
131 Performance_schema_accounts_lost 5
132 Performance_schema_hosts_lost 0
133 Performance_schema_users_lost 0
134 select "user2 in con2c" as status;
135 status
136 user2 in con2c
137 call dump_all();
138 processlist_user processlist_host
139 event_scheduler localhost
140 root localhost
141 user1 localhost
142 user1 localhost
143 user1 localhost
144 user2 localhost
145 user2 localhost
146 user2 localhost
147 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
148 event_scheduler localhost 1 1
149 root localhost 1 1
150 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
151 event_scheduler 1 1
152 root 1 1
153 user1 3 3
154 user2 3 3
155 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
156 localhost 8 8
157 variable_name variable_value
158 Performance_schema_accounts_lost 6
159 Performance_schema_hosts_lost 0
160 Performance_schema_users_lost 0
161 select "user3 in con3a" as status;
162 status
163 user3 in con3a
164 call dump_all();
165 processlist_user processlist_host
166 event_scheduler localhost
167 root localhost
168 user1 localhost
169 user1 localhost
170 user1 localhost
171 user2 localhost
172 user2 localhost
173 user2 localhost
174 user3 localhost
175 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
176 event_scheduler localhost 1 1
177 root localhost 1 1
178 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
179 event_scheduler 1 1
180 root 1 1
181 user1 3 3
182 user2 3 3
183 user3 1 1
184 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
185 localhost 9 9
186 variable_name variable_value
187 Performance_schema_accounts_lost 7
188 Performance_schema_hosts_lost 0
189 Performance_schema_users_lost 0
190 select "user3 in con3b" as status;
191 status
192 user3 in con3b
193 call dump_all();
194 processlist_user processlist_host
195 event_scheduler localhost
196 root localhost
197 user1 localhost
198 user1 localhost
199 user1 localhost
200 user2 localhost
201 user2 localhost
202 user2 localhost
203 user3 localhost
204 user3 localhost
205 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
206 event_scheduler localhost 1 1
207 root localhost 1 1
208 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
209 event_scheduler 1 1
210 root 1 1
211 user1 3 3
212 user2 3 3
213 user3 2 2
214 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
215 localhost 10 10
216 variable_name variable_value
217 Performance_schema_accounts_lost 8
218 Performance_schema_hosts_lost 0
219 Performance_schema_users_lost 0
220 select "user3 in con3c" as status;
221 status
222 user3 in con3c
223 call dump_all();
224 processlist_user processlist_host
225 event_scheduler localhost
226 root localhost
227 user1 localhost
228 user1 localhost
229 user1 localhost
230 user2 localhost
231 user2 localhost
232 user2 localhost
233 user3 localhost
234 user3 localhost
235 user3 localhost
236 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
237 event_scheduler localhost 1 1
238 root localhost 1 1
239 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
240 event_scheduler 1 1
241 root 1 1
242 user1 3 3
243 user2 3 3
244 user3 3 3
245 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
246 localhost 11 11
247 variable_name variable_value
248 Performance_schema_accounts_lost 9
249 Performance_schema_hosts_lost 0
250 Performance_schema_users_lost 0
251 select "con1a disconnected" as status;
252 status
253 con1a disconnected
254 call dump_all();
255 processlist_user processlist_host
256 event_scheduler localhost
257 root localhost
258 user1 localhost
259 user1 localhost
260 user2 localhost
261 user2 localhost
262 user2 localhost
263 user3 localhost
264 user3 localhost
265 user3 localhost
266 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
267 event_scheduler localhost 1 1
268 root localhost 1 1
269 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
270 event_scheduler 1 1
271 root 1 1
272 user1 2 3
273 user2 3 3
274 user3 3 3
275 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
276 localhost 10 11
277 variable_name variable_value
278 Performance_schema_accounts_lost 9
279 Performance_schema_hosts_lost 0
280 Performance_schema_users_lost 0
281 select "con2a disconnected" as status;
282 status
283 con2a disconnected
284 call dump_all();
285 processlist_user processlist_host
286 event_scheduler localhost
287 root localhost
288 user1 localhost
289 user1 localhost
290 user2 localhost
291 user2 localhost
292 user3 localhost
293 user3 localhost
294 user3 localhost
295 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
296 event_scheduler localhost 1 1
297 root localhost 1 1
298 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
299 event_scheduler 1 1
300 root 1 1
301 user1 2 3
302 user2 2 3
303 user3 3 3
304 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
305 localhost 9 11
306 variable_name variable_value
307 Performance_schema_accounts_lost 9
308 Performance_schema_hosts_lost 0
309 Performance_schema_users_lost 0
310 select "con3a disconnected" as status;
311 status
312 con3a disconnected
313 call dump_all();
314 processlist_user processlist_host
315 event_scheduler localhost
316 root localhost
317 user1 localhost
318 user1 localhost
319 user2 localhost
320 user2 localhost
321 user3 localhost
322 user3 localhost
323 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
324 event_scheduler localhost 1 1
325 root localhost 1 1
326 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
327 event_scheduler 1 1
328 root 1 1
329 user1 2 3
330 user2 2 3
331 user3 2 3
332 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
333 localhost 8 11
334 variable_name variable_value
335 Performance_schema_accounts_lost 9
336 Performance_schema_hosts_lost 0
337 Performance_schema_users_lost 0
338 truncate table performance_schema.accounts;
339 call dump_all();
340 processlist_user processlist_host
341 event_scheduler localhost
342 root localhost
343 user1 localhost
344 user1 localhost
345 user2 localhost
346 user2 localhost
347 user3 localhost
348 user3 localhost
349 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
350 event_scheduler localhost 1 1
351 root localhost 1 1
352 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
353 event_scheduler 1 1
354 root 1 1
355 user1 2 3
356 user2 2 3
357 user3 2 3
358 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
359 localhost 8 11
360 variable_name variable_value
361 Performance_schema_accounts_lost 9
362 Performance_schema_hosts_lost 0
363 Performance_schema_users_lost 0
364 truncate table performance_schema.users;
365 call dump_all();
366 processlist_user processlist_host
367 event_scheduler localhost
368 root localhost
369 user1 localhost
370 user1 localhost
371 user2 localhost
372 user2 localhost
373 user3 localhost
374 user3 localhost
375 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
376 event_scheduler localhost 1 1
377 root localhost 1 1
378 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
379 event_scheduler 1 1
380 root 1 1
381 user1 2 2
382 user2 2 2
383 user3 2 2
384 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
385 localhost 8 11
386 variable_name variable_value
387 Performance_schema_accounts_lost 9
388 Performance_schema_hosts_lost 0
389 Performance_schema_users_lost 0
390 truncate table performance_schema.hosts;
391 call dump_all();
392 processlist_user processlist_host
393 event_scheduler localhost
394 root localhost
395 user1 localhost
396 user1 localhost
397 user2 localhost
398 user2 localhost
399 user3 localhost
400 user3 localhost
401 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
402 event_scheduler localhost 1 1
403 root localhost 1 1
404 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
405 event_scheduler 1 1
406 root 1 1
407 user1 2 2
408 user2 2 2
409 user3 2 2
410 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
411 localhost 8 8
412 variable_name variable_value
413 Performance_schema_accounts_lost 9
414 Performance_schema_hosts_lost 0
415 Performance_schema_users_lost 0
416 select "user4 in con4a" as status;
417 status
418 user4 in con4a
419 call dump_all();
420 processlist_user processlist_host
421 event_scheduler localhost
422 root localhost
423 user1 localhost
424 user1 localhost
425 user2 localhost
426 user2 localhost
427 user3 localhost
428 user3 localhost
429 user4 localhost
430 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
431 event_scheduler localhost 1 1
432 root localhost 1 1
433 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
434 event_scheduler 1 1
435 root 1 1
436 user1 2 2
437 user2 2 2
438 user3 2 2
439 user4 1 1
440 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
441 localhost 9 9
442 variable_name variable_value
443 Performance_schema_accounts_lost 10
444 Performance_schema_hosts_lost 0
445 Performance_schema_users_lost 0
446 select "user4 in con4b" as status;
447 status
448 user4 in con4b
449 call dump_all();
450 processlist_user processlist_host
451 event_scheduler localhost
452 root localhost
453 user1 localhost
454 user1 localhost
455 user2 localhost
456 user2 localhost
457 user3 localhost
458 user3 localhost
459 user4 localhost
460 user4 localhost
461 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
462 event_scheduler localhost 1 1
463 root localhost 1 1
464 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
465 event_scheduler 1 1
466 root 1 1
467 user1 2 2
468 user2 2 2
469 user3 2 2
470 user4 2 2
471 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
472 localhost 10 10
473 variable_name variable_value
474 Performance_schema_accounts_lost 11
475 Performance_schema_hosts_lost 0
476 Performance_schema_users_lost 0
477 select "user4 in con4c" as status;
478 status
479 user4 in con4c
480 call dump_all();
481 processlist_user processlist_host
482 event_scheduler localhost
483 root localhost
484 user1 localhost
485 user1 localhost
486 user2 localhost
487 user2 localhost
488 user3 localhost
489 user3 localhost
490 user4 localhost
491 user4 localhost
492 user4 localhost
493 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
494 event_scheduler localhost 1 1
495 root localhost 1 1
496 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
497 event_scheduler 1 1
498 root 1 1
499 user1 2 2
500 user2 2 2
501 user3 2 2
502 user4 3 3
503 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
504 localhost 11 11
505 variable_name variable_value
506 Performance_schema_accounts_lost 12
507 Performance_schema_hosts_lost 0
508 Performance_schema_users_lost 0
509 select "con1b disconnected" as status;
510 status
511 con1b disconnected
512 call dump_all();
513 processlist_user processlist_host
514 event_scheduler localhost
515 root localhost
516 user1 localhost
517 user2 localhost
518 user2 localhost
519 user3 localhost
520 user3 localhost
521 user4 localhost
522 user4 localhost
523 user4 localhost
524 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
525 event_scheduler localhost 1 1
526 root localhost 1 1
527 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
528 event_scheduler 1 1
529 root 1 1
530 user1 1 2
531 user2 2 2
532 user3 2 2
533 user4 3 3
534 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
535 localhost 10 11
536 variable_name variable_value
537 Performance_schema_accounts_lost 12
538 Performance_schema_hosts_lost 0
539 Performance_schema_users_lost 0
540 select "con2b disconnected" as status;
541 status
542 con2b disconnected
543 call dump_all();
544 processlist_user processlist_host
545 event_scheduler localhost
546 root localhost
547 user1 localhost
548 user2 localhost
549 user3 localhost
550 user3 localhost
551 user4 localhost
552 user4 localhost
553 user4 localhost
554 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
555 event_scheduler localhost 1 1
556 root localhost 1 1
557 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
558 event_scheduler 1 1
559 root 1 1
560 user1 1 2
561 user2 1 2
562 user3 2 2
563 user4 3 3
564 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
565 localhost 9 11
566 variable_name variable_value
567 Performance_schema_accounts_lost 12
568 Performance_schema_hosts_lost 0
569 Performance_schema_users_lost 0
570 select "con3b disconnected" as status;
571 status
572 con3b disconnected
573 call dump_all();
574 processlist_user processlist_host
575 event_scheduler localhost
576 root localhost
577 user1 localhost
578 user2 localhost
579 user3 localhost
580 user4 localhost
581 user4 localhost
582 user4 localhost
583 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
584 event_scheduler localhost 1 1
585 root localhost 1 1
586 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
587 event_scheduler 1 1
588 root 1 1
589 user1 1 2
590 user2 1 2
591 user3 1 2
592 user4 3 3
593 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
594 localhost 8 11
595 variable_name variable_value
596 Performance_schema_accounts_lost 12
597 Performance_schema_hosts_lost 0
598 Performance_schema_users_lost 0
599 select "con1c disconnected" as status;
600 status
601 con1c disconnected
602 call dump_all();
603 processlist_user processlist_host
604 event_scheduler localhost
605 root localhost
606 user2 localhost
607 user3 localhost
608 user4 localhost
609 user4 localhost
610 user4 localhost
611 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
612 event_scheduler localhost 1 1
613 root localhost 1 1
614 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
615 event_scheduler 1 1
616 root 1 1
617 user1 0 2
618 user2 1 2
619 user3 1 2
620 user4 3 3
621 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
622 localhost 7 11
623 variable_name variable_value
624 Performance_schema_accounts_lost 12
625 Performance_schema_hosts_lost 0
626 Performance_schema_users_lost 0
627 select "con2c disconnected" as status;
628 status
629 con2c disconnected
630 call dump_all();
631 processlist_user processlist_host
632 event_scheduler localhost
633 root localhost
634 user3 localhost
635 user4 localhost
636 user4 localhost
637 user4 localhost
638 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
639 event_scheduler localhost 1 1
640 root localhost 1 1
641 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
642 event_scheduler 1 1
643 root 1 1
644 user1 0 2
645 user2 0 2
646 user3 1 2
647 user4 3 3
648 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
649 localhost 6 11
650 variable_name variable_value
651 Performance_schema_accounts_lost 12
652 Performance_schema_hosts_lost 0
653 Performance_schema_users_lost 0
654 select "con3c disconnected" as status;
655 status
656 con3c disconnected
657 call dump_all();
658 processlist_user processlist_host
659 event_scheduler localhost
660 root localhost
661 user4 localhost
662 user4 localhost
663 user4 localhost
664 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
665 event_scheduler localhost 1 1
666 root localhost 1 1
667 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
668 event_scheduler 1 1
669 root 1 1
670 user1 0 2
671 user2 0 2
672 user3 0 2
673 user4 3 3
674 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
675 localhost 5 11
676 variable_name variable_value
677 Performance_schema_accounts_lost 12
678 Performance_schema_hosts_lost 0
679 Performance_schema_users_lost 0
680 truncate table performance_schema.accounts;
681 call dump_all();
682 processlist_user processlist_host
683 event_scheduler localhost
684 root localhost
685 user4 localhost
686 user4 localhost
687 user4 localhost
688 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
689 event_scheduler localhost 1 1
690 root localhost 1 1
691 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
692 event_scheduler 1 1
693 root 1 1
694 user1 0 2
695 user2 0 2
696 user3 0 2
697 user4 3 3
698 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
699 localhost 5 11
700 variable_name variable_value
701 Performance_schema_accounts_lost 12
702 Performance_schema_hosts_lost 0
703 Performance_schema_users_lost 0
704 truncate table performance_schema.users;
705 call dump_all();
706 processlist_user processlist_host
707 event_scheduler localhost
708 root localhost
709 user4 localhost
710 user4 localhost
711 user4 localhost
712 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
713 event_scheduler localhost 1 1
714 root localhost 1 1
715 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
716 event_scheduler 1 1
717 root 1 1
718 user4 3 3
719 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
720 localhost 5 11
721 variable_name variable_value
722 Performance_schema_accounts_lost 12
723 Performance_schema_hosts_lost 0
724 Performance_schema_users_lost 0
725 truncate table performance_schema.hosts;
726 call dump_all();
727 processlist_user processlist_host
728 event_scheduler localhost
729 root localhost
730 user4 localhost
731 user4 localhost
732 user4 localhost
733 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
734 event_scheduler localhost 1 1
735 root localhost 1 1
736 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
737 event_scheduler 1 1
738 root 1 1
739 user4 3 3
740 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
741 localhost 5 5
742 variable_name variable_value
743 Performance_schema_accounts_lost 12
744 Performance_schema_hosts_lost 0
745 Performance_schema_users_lost 0
746 select "user5 in con5a" as status;
747 status
748 user5 in con5a
749 call dump_all();
750 processlist_user processlist_host
751 event_scheduler localhost
752 root localhost
753 user4 localhost
754 user4 localhost
755 user4 localhost
756 user5 localhost
757 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
758 event_scheduler localhost 1 1
759 root localhost 1 1
760 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
761 event_scheduler 1 1
762 root 1 1
763 user4 3 3
764 user5 1 1
765 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
766 localhost 6 6
767 variable_name variable_value
768 Performance_schema_accounts_lost 13
769 Performance_schema_hosts_lost 0
770 Performance_schema_users_lost 0
771 select "user5 in con5b" as status;
772 status
773 user5 in con5b
774 call dump_all();
775 processlist_user processlist_host
776 event_scheduler localhost
777 root localhost
778 user4 localhost
779 user4 localhost
780 user4 localhost
781 user5 localhost
782 user5 localhost
783 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
784 event_scheduler localhost 1 1
785 root localhost 1 1
786 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
787 event_scheduler 1 1
788 root 1 1
789 user4 3 3
790 user5 2 2
791 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
792 localhost 7 7
793 variable_name variable_value
794 Performance_schema_accounts_lost 14
795 Performance_schema_hosts_lost 0
796 Performance_schema_users_lost 0
797 select "user5 in con5c" as status;
798 status
799 user5 in con5c
800 call dump_all();
801 processlist_user processlist_host
802 event_scheduler localhost
803 root localhost
804 user4 localhost
805 user4 localhost
806 user4 localhost
807 user5 localhost
808 user5 localhost
809 user5 localhost
810 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
811 event_scheduler localhost 1 1
812 root localhost 1 1
813 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
814 event_scheduler 1 1
815 root 1 1
816 user4 3 3
817 user5 3 3
818 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
819 localhost 8 8
820 variable_name variable_value
821 Performance_schema_accounts_lost 15
822 Performance_schema_hosts_lost 0
823 Performance_schema_users_lost 0
824 select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status;
825 status
826 con 5a, 5b, 5c, 6a, 6b, 6c disconnected
827 call dump_all();
828 processlist_user processlist_host
829 event_scheduler localhost
830 root localhost
831 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
832 event_scheduler localhost 1 1
833 root localhost 1 1
834 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
835 event_scheduler 1 1
836 root 1 1
837 user4 0 3
838 user5 0 3
839 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
840 localhost 2 8
841 variable_name variable_value
842 Performance_schema_accounts_lost 15
843 Performance_schema_hosts_lost 0
844 Performance_schema_users_lost 0
845 truncate table performance_schema.hosts;
846 call dump_all();
847 processlist_user processlist_host
848 event_scheduler localhost
849 root localhost
850 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
851 event_scheduler localhost 1 1
852 root localhost 1 1
853 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
854 event_scheduler 1 1
855 root 1 1
856 user4 0 3
857 user5 0 3
858 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
859 localhost 2 2
860 variable_name variable_value
861 Performance_schema_accounts_lost 15
862 Performance_schema_hosts_lost 0
863 Performance_schema_users_lost 0
864 truncate table performance_schema.users;
865 call dump_all();
866 processlist_user processlist_host
867 event_scheduler localhost
868 root localhost
869 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
870 event_scheduler localhost 1 1
871 root localhost 1 1
872 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
873 event_scheduler 1 1
874 root 1 1
875 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
876 localhost 2 2
877 variable_name variable_value
878 Performance_schema_accounts_lost 15
879 Performance_schema_hosts_lost 0
880 Performance_schema_users_lost 0
881 truncate table performance_schema.accounts;
882 call dump_all();
883 processlist_user processlist_host
884 event_scheduler localhost
885 root localhost
886 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
887 event_scheduler localhost 1 1
888 root localhost 1 1
889 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
890 event_scheduler 1 1
891 root 1 1
892 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
893 localhost 2 2
894 variable_name variable_value
895 Performance_schema_accounts_lost 15
896 Performance_schema_hosts_lost 0
897 Performance_schema_users_lost 0