Debian Codegraph @

mysql-test/suite/perfschema/r/connection_3u.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 user1 localhost 1 1
29 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
30 event_scheduler 1 1
31 root 1 1
32 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
33 localhost 3 3
34 variable_name variable_value
35 Performance_schema_accounts_lost 0
36 Performance_schema_hosts_lost 0
37 Performance_schema_users_lost 1
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 user1 localhost 2 2
51 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
52 event_scheduler 1 1
53 root 1 1
54 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
55 localhost 4 4
56 variable_name variable_value
57 Performance_schema_accounts_lost 0
58 Performance_schema_hosts_lost 0
59 Performance_schema_users_lost 1
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 user1 localhost 3 3
74 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
75 event_scheduler 1 1
76 root 1 1
77 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
78 localhost 5 5
79 variable_name variable_value
80 Performance_schema_accounts_lost 0
81 Performance_schema_hosts_lost 0
82 Performance_schema_users_lost 1
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 user1 localhost 3 3
98 user2 localhost 1 1
99 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
100 event_scheduler 1 1
101 root 1 1
102 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
103 localhost 6 6
104 variable_name variable_value
105 Performance_schema_accounts_lost 0
106 Performance_schema_hosts_lost 0
107 Performance_schema_users_lost 2
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 user1 localhost 3 3
124 user2 localhost 2 2
125 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
126 event_scheduler 1 1
127 root 1 1
128 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
129 localhost 7 7
130 variable_name variable_value
131 Performance_schema_accounts_lost 0
132 Performance_schema_hosts_lost 0
133 Performance_schema_users_lost 2
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 user1 localhost 3 3
151 user2 localhost 3 3
152 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
153 event_scheduler 1 1
154 root 1 1
155 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
156 localhost 8 8
157 variable_name variable_value
158 Performance_schema_accounts_lost 0
159 Performance_schema_hosts_lost 0
160 Performance_schema_users_lost 2
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 user1 localhost 3 3
179 user2 localhost 3 3
180 user3 localhost 1 1
181 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
182 event_scheduler 1 1
183 root 1 1
184 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
185 localhost 9 9
186 variable_name variable_value
187 Performance_schema_accounts_lost 0
188 Performance_schema_hosts_lost 0
189 Performance_schema_users_lost 3
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 user1 localhost 3 3
209 user2 localhost 3 3
210 user3 localhost 2 2
211 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
212 event_scheduler 1 1
213 root 1 1
214 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
215 localhost 10 10
216 variable_name variable_value
217 Performance_schema_accounts_lost 0
218 Performance_schema_hosts_lost 0
219 Performance_schema_users_lost 3
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 user1 localhost 3 3
240 user2 localhost 3 3
241 user3 localhost 3 3
242 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
243 event_scheduler 1 1
244 root 1 1
245 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
246 localhost 11 11
247 variable_name variable_value
248 Performance_schema_accounts_lost 0
249 Performance_schema_hosts_lost 0
250 Performance_schema_users_lost 3
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 user1 localhost 2 3
270 user2 localhost 3 3
271 user3 localhost 3 3
272 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
273 event_scheduler 1 1
274 root 1 1
275 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
276 localhost 10 11
277 variable_name variable_value
278 Performance_schema_accounts_lost 0
279 Performance_schema_hosts_lost 0
280 Performance_schema_users_lost 3
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 user1 localhost 2 3
299 user2 localhost 2 3
300 user3 localhost 3 3
301 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
302 event_scheduler 1 1
303 root 1 1
304 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
305 localhost 9 11
306 variable_name variable_value
307 Performance_schema_accounts_lost 0
308 Performance_schema_hosts_lost 0
309 Performance_schema_users_lost 3
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 user1 localhost 2 3
327 user2 localhost 2 3
328 user3 localhost 2 3
329 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
330 event_scheduler 1 1
331 root 1 1
332 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
333 localhost 8 11
334 variable_name variable_value
335 Performance_schema_accounts_lost 0
336 Performance_schema_hosts_lost 0
337 Performance_schema_users_lost 3
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 user1 localhost 2 2
353 user2 localhost 2 2
354 user3 localhost 2 2
355 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
356 event_scheduler 1 1
357 root 1 1
358 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
359 localhost 8 11
360 variable_name variable_value
361 Performance_schema_accounts_lost 0
362 Performance_schema_hosts_lost 0
363 Performance_schema_users_lost 3
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 user1 localhost 2 2
379 user2 localhost 2 2
380 user3 localhost 2 2
381 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
382 event_scheduler 1 1
383 root 1 1
384 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
385 localhost 8 11
386 variable_name variable_value
387 Performance_schema_accounts_lost 0
388 Performance_schema_hosts_lost 0
389 Performance_schema_users_lost 3
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 user1 localhost 2 2
405 user2 localhost 2 2
406 user3 localhost 2 2
407 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
408 event_scheduler 1 1
409 root 1 1
410 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
411 localhost 8 8
412 variable_name variable_value
413 Performance_schema_accounts_lost 0
414 Performance_schema_hosts_lost 0
415 Performance_schema_users_lost 3
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 user1 localhost 2 2
434 user2 localhost 2 2
435 user3 localhost 2 2
436 user4 localhost 1 1
437 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
438 event_scheduler 1 1
439 root 1 1
440 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
441 localhost 9 9
442 variable_name variable_value
443 Performance_schema_accounts_lost 0
444 Performance_schema_hosts_lost 0
445 Performance_schema_users_lost 4
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 user1 localhost 2 2
465 user2 localhost 2 2
466 user3 localhost 2 2
467 user4 localhost 2 2
468 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
469 event_scheduler 1 1
470 root 1 1
471 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
472 localhost 10 10
473 variable_name variable_value
474 Performance_schema_accounts_lost 0
475 Performance_schema_hosts_lost 0
476 Performance_schema_users_lost 4
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 user1 localhost 2 2
497 user2 localhost 2 2
498 user3 localhost 2 2
499 user4 localhost 3 3
500 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
501 event_scheduler 1 1
502 root 1 1
503 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
504 localhost 11 11
505 variable_name variable_value
506 Performance_schema_accounts_lost 0
507 Performance_schema_hosts_lost 0
508 Performance_schema_users_lost 4
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 user1 localhost 1 2
528 user2 localhost 2 2
529 user3 localhost 2 2
530 user4 localhost 3 3
531 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
532 event_scheduler 1 1
533 root 1 1
534 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
535 localhost 10 11
536 variable_name variable_value
537 Performance_schema_accounts_lost 0
538 Performance_schema_hosts_lost 0
539 Performance_schema_users_lost 4
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 user1 localhost 1 2
558 user2 localhost 1 2
559 user3 localhost 2 2
560 user4 localhost 3 3
561 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
562 event_scheduler 1 1
563 root 1 1
564 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
565 localhost 9 11
566 variable_name variable_value
567 Performance_schema_accounts_lost 0
568 Performance_schema_hosts_lost 0
569 Performance_schema_users_lost 4
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 user1 localhost 1 2
587 user2 localhost 1 2
588 user3 localhost 1 2
589 user4 localhost 3 3
590 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
591 event_scheduler 1 1
592 root 1 1
593 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
594 localhost 8 11
595 variable_name variable_value
596 Performance_schema_accounts_lost 0
597 Performance_schema_hosts_lost 0
598 Performance_schema_users_lost 4
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 user1 localhost 0 2
615 user2 localhost 1 2
616 user3 localhost 1 2
617 user4 localhost 3 3
618 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
619 event_scheduler 1 1
620 root 1 1
621 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
622 localhost 7 11
623 variable_name variable_value
624 Performance_schema_accounts_lost 0
625 Performance_schema_hosts_lost 0
626 Performance_schema_users_lost 4
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 user1 localhost 0 2
642 user2 localhost 0 2
643 user3 localhost 1 2
644 user4 localhost 3 3
645 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
646 event_scheduler 1 1
647 root 1 1
648 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
649 localhost 6 11
650 variable_name variable_value
651 Performance_schema_accounts_lost 0
652 Performance_schema_hosts_lost 0
653 Performance_schema_users_lost 4
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 user1 localhost 0 2
668 user2 localhost 0 2
669 user3 localhost 0 2
670 user4 localhost 3 3
671 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
672 event_scheduler 1 1
673 root 1 1
674 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
675 localhost 5 11
676 variable_name variable_value
677 Performance_schema_accounts_lost 0
678 Performance_schema_hosts_lost 0
679 Performance_schema_users_lost 4
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 user4 localhost 3 3
692 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
693 event_scheduler 1 1
694 root 1 1
695 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
696 localhost 5 11
697 variable_name variable_value
698 Performance_schema_accounts_lost 0
699 Performance_schema_hosts_lost 0
700 Performance_schema_users_lost 4
701 truncate table performance_schema.users;
702 call dump_all();
703 processlist_user processlist_host
704 event_scheduler localhost
705 root localhost
706 user4 localhost
707 user4 localhost
708 user4 localhost
709 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
710 event_scheduler localhost 1 1
711 root localhost 1 1
712 user4 localhost 3 3
713 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
714 event_scheduler 1 1
715 root 1 1
716 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
717 localhost 5 11
718 variable_name variable_value
719 Performance_schema_accounts_lost 0
720 Performance_schema_hosts_lost 0
721 Performance_schema_users_lost 4
722 truncate table performance_schema.hosts;
723 call dump_all();
724 processlist_user processlist_host
725 event_scheduler localhost
726 root localhost
727 user4 localhost
728 user4 localhost
729 user4 localhost
730 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
731 event_scheduler localhost 1 1
732 root localhost 1 1
733 user4 localhost 3 3
734 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
735 event_scheduler 1 1
736 root 1 1
737 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
738 localhost 5 5
739 variable_name variable_value
740 Performance_schema_accounts_lost 0
741 Performance_schema_hosts_lost 0
742 Performance_schema_users_lost 4
743 select "user5 in con5a" as status;
744 status
745 user5 in con5a
746 call dump_all();
747 processlist_user processlist_host
748 event_scheduler localhost
749 root localhost
750 user4 localhost
751 user4 localhost
752 user4 localhost
753 user5 localhost
754 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
755 event_scheduler localhost 1 1
756 root localhost 1 1
757 user4 localhost 3 3
758 user5 localhost 1 1
759 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
760 event_scheduler 1 1
761 root 1 1
762 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
763 localhost 6 6
764 variable_name variable_value
765 Performance_schema_accounts_lost 0
766 Performance_schema_hosts_lost 0
767 Performance_schema_users_lost 5
768 select "user5 in con5b" as status;
769 status
770 user5 in con5b
771 call dump_all();
772 processlist_user processlist_host
773 event_scheduler localhost
774 root localhost
775 user4 localhost
776 user4 localhost
777 user4 localhost
778 user5 localhost
779 user5 localhost
780 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
781 event_scheduler localhost 1 1
782 root localhost 1 1
783 user4 localhost 3 3
784 user5 localhost 2 2
785 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
786 event_scheduler 1 1
787 root 1 1
788 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
789 localhost 7 7
790 variable_name variable_value
791 Performance_schema_accounts_lost 0
792 Performance_schema_hosts_lost 0
793 Performance_schema_users_lost 5
794 select "user5 in con5c" as status;
795 status
796 user5 in con5c
797 call dump_all();
798 processlist_user processlist_host
799 event_scheduler localhost
800 root localhost
801 user4 localhost
802 user4 localhost
803 user4 localhost
804 user5 localhost
805 user5 localhost
806 user5 localhost
807 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
808 event_scheduler localhost 1 1
809 root localhost 1 1
810 user4 localhost 3 3
811 user5 localhost 3 3
812 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
813 event_scheduler 1 1
814 root 1 1
815 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
816 localhost 8 8
817 variable_name variable_value
818 Performance_schema_accounts_lost 0
819 Performance_schema_hosts_lost 0
820 Performance_schema_users_lost 5
821 select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status;
822 status
823 con 5a, 5b, 5c, 6a, 6b, 6c disconnected
824 call dump_all();
825 processlist_user processlist_host
826 event_scheduler localhost
827 root localhost
828 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
829 event_scheduler localhost 1 1
830 root localhost 1 1
831 user4 localhost 0 3
832 user5 localhost 0 3
833 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
834 event_scheduler 1 1
835 root 1 1
836 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
837 localhost 2 8
838 variable_name variable_value
839 Performance_schema_accounts_lost 0
840 Performance_schema_hosts_lost 0
841 Performance_schema_users_lost 5
842 truncate table performance_schema.hosts;
843 call dump_all();
844 processlist_user processlist_host
845 event_scheduler localhost
846 root localhost
847 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
848 event_scheduler localhost 1 1
849 root localhost 1 1
850 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
851 event_scheduler 1 1
852 root 1 1
853 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
854 localhost 2 2
855 variable_name variable_value
856 Performance_schema_accounts_lost 0
857 Performance_schema_hosts_lost 0
858 Performance_schema_users_lost 5
859 truncate table performance_schema.users;
860 call dump_all();
861 processlist_user processlist_host
862 event_scheduler localhost
863 root localhost
864 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
865 event_scheduler localhost 1 1
866 root localhost 1 1
867 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
868 event_scheduler 1 1
869 root 1 1
870 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
871 localhost 2 2
872 variable_name variable_value
873 Performance_schema_accounts_lost 0
874 Performance_schema_hosts_lost 0
875 Performance_schema_users_lost 5
876 truncate table performance_schema.accounts;
877 call dump_all();
878 processlist_user processlist_host
879 event_scheduler localhost
880 root localhost
881 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
882 event_scheduler localhost 1 1
883 root localhost 1 1
884 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
885 event_scheduler 1 1
886 root 1 1
887 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
888 localhost 2 2
889 variable_name variable_value
890 Performance_schema_accounts_lost 0
891 Performance_schema_hosts_lost 0
892 Performance_schema_users_lost 5