Debian Codegraph @

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

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