Debian Codegraph @

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