Debian Codegraph @

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