Debian Codegraph @

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