Debian Codegraph @

mysql-test/suite/perfschema/r/connection_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 user2 localhost 1 1
92 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
93 root 1 1
94 user1 3 3
95 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
96 localhost 5 5
97 variable_name variable_value
98 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
99 PERFORMANCE_SCHEMA_HOSTS_LOST 0
100 PERFORMANCE_SCHEMA_USERS_LOST 1
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 user2 localhost 2 2
117 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
118 root 1 1
119 user1 3 3
120 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
121 localhost 6 6
122 variable_name variable_value
123 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
124 PERFORMANCE_SCHEMA_HOSTS_LOST 0
125 PERFORMANCE_SCHEMA_USERS_LOST 1
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 user2 localhost 3 3
143 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
144 root 1 1
145 user1 3 3
146 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
147 localhost 7 7
148 variable_name variable_value
149 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
150 PERFORMANCE_SCHEMA_HOSTS_LOST 0
151 PERFORMANCE_SCHEMA_USERS_LOST 1
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 user2 localhost 3 3
170 user3 localhost 1 1
171 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
172 root 1 1
173 user1 3 3
174 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
175 localhost 8 8
176 variable_name variable_value
177 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
178 PERFORMANCE_SCHEMA_HOSTS_LOST 0
179 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 3 3
199 user3 localhost 2 2
200 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
201 root 1 1
202 user1 3 3
203 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
204 localhost 9 9
205 variable_name variable_value
206 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
207 PERFORMANCE_SCHEMA_HOSTS_LOST 0
208 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 3 3
229 user3 localhost 3 3
230 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
231 root 1 1
232 user1 3 3
233 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
234 localhost 10 10
235 variable_name variable_value
236 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
237 PERFORMANCE_SCHEMA_HOSTS_LOST 0
238 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 3 3
259 user3 localhost 3 3
260 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
261 root 1 1
262 user1 2 3
263 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
264 localhost 9 10
265 variable_name variable_value
266 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
267 PERFORMANCE_SCHEMA_HOSTS_LOST 0
268 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 3
287 user3 localhost 3 3
288 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
289 root 1 1
290 user1 2 3
291 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
292 localhost 8 10
293 variable_name variable_value
294 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
295 PERFORMANCE_SCHEMA_HOSTS_LOST 0
296 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 3
314 user3 localhost 2 3
315 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
316 root 1 1
317 user1 2 3
318 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
319 localhost 7 10
320 variable_name variable_value
321 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
322 PERFORMANCE_SCHEMA_HOSTS_LOST 0
323 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 2
338 user3 localhost 2 2
339 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
340 root 1 1
341 user1 2 3
342 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
343 localhost 7 10
344 variable_name variable_value
345 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
346 PERFORMANCE_SCHEMA_HOSTS_LOST 0
347 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 2
362 user3 localhost 2 2
363 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
364 root 1 1
365 user1 2 2
366 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
367 localhost 7 10
368 variable_name variable_value
369 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
370 PERFORMANCE_SCHEMA_HOSTS_LOST 0
371 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 2
386 user3 localhost 2 2
387 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
388 root 1 1
389 user1 2 2
390 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
391 localhost 7 7
392 variable_name variable_value
393 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
394 PERFORMANCE_SCHEMA_HOSTS_LOST 0
395 PERFORMANCE_SCHEMA_USERS_LOST 2
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 user2 localhost 2 2
414 user3 localhost 2 2
415 user4 localhost 1 1
416 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
417 root 1 1
418 user1 2 2
419 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
420 localhost 8 8
421 variable_name variable_value
422 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
423 PERFORMANCE_SCHEMA_HOSTS_LOST 0
424 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 2 2
444 user3 localhost 2 2
445 user4 localhost 2 2
446 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
447 root 1 1
448 user1 2 2
449 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
450 localhost 9 9
451 variable_name variable_value
452 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
453 PERFORMANCE_SCHEMA_HOSTS_LOST 0
454 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 2 2
475 user3 localhost 2 2
476 user4 localhost 3 3
477 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
478 root 1 1
479 user1 2 2
480 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
481 localhost 10 10
482 variable_name variable_value
483 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
484 PERFORMANCE_SCHEMA_HOSTS_LOST 0
485 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 2 2
506 user3 localhost 2 2
507 user4 localhost 3 3
508 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
509 root 1 1
510 user1 1 2
511 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
512 localhost 9 10
513 variable_name variable_value
514 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
515 PERFORMANCE_SCHEMA_HOSTS_LOST 0
516 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 1 2
535 user3 localhost 2 2
536 user4 localhost 3 3
537 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
538 root 1 1
539 user1 1 2
540 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
541 localhost 8 10
542 variable_name variable_value
543 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
544 PERFORMANCE_SCHEMA_HOSTS_LOST 0
545 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 1 2
563 user3 localhost 1 2
564 user4 localhost 3 3
565 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
566 root 1 1
567 user1 1 2
568 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
569 localhost 7 10
570 variable_name variable_value
571 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
572 PERFORMANCE_SCHEMA_HOSTS_LOST 0
573 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 1 2
590 user3 localhost 1 2
591 user4 localhost 3 3
592 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
593 root 1 1
594 user1 0 2
595 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
596 localhost 6 10
597 variable_name variable_value
598 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
599 PERFORMANCE_SCHEMA_HOSTS_LOST 0
600 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 0 2
616 user3 localhost 1 2
617 user4 localhost 3 3
618 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
619 root 1 1
620 user1 0 2
621 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
622 localhost 5 10
623 variable_name variable_value
624 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
625 PERFORMANCE_SCHEMA_HOSTS_LOST 0
626 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user2 localhost 0 2
641 user3 localhost 0 2
642 user4 localhost 3 3
643 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
644 root 1 1
645 user1 0 2
646 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
647 localhost 4 10
648 variable_name variable_value
649 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
650 PERFORMANCE_SCHEMA_HOSTS_LOST 0
651 PERFORMANCE_SCHEMA_USERS_LOST 3
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 user4 localhost 3 3
662 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
663 root 1 1
664 user1 0 2
665 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
666 localhost 4 10
667 variable_name variable_value
668 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
669 PERFORMANCE_SCHEMA_HOSTS_LOST 0
670 PERFORMANCE_SCHEMA_USERS_LOST 3
671 truncate table performance_schema.users;
672 call dump_all();
673 processlist_user processlist_host
674 root localhost
675 user4 localhost
676 user4 localhost
677 user4 localhost
678 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
679 root localhost 1 1
680 user4 localhost 3 3
681 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
682 root 1 1
683 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
684 localhost 4 10
685 variable_name variable_value
686 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
687 PERFORMANCE_SCHEMA_HOSTS_LOST 0
688 PERFORMANCE_SCHEMA_USERS_LOST 3
689 truncate table performance_schema.hosts;
690 call dump_all();
691 processlist_user processlist_host
692 root localhost
693 user4 localhost
694 user4 localhost
695 user4 localhost
696 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
697 root localhost 1 1
698 user4 localhost 3 3
699 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
700 root 1 1
701 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
702 localhost 4 4
703 variable_name variable_value
704 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
705 PERFORMANCE_SCHEMA_HOSTS_LOST 0
706 PERFORMANCE_SCHEMA_USERS_LOST 3
707 connect con5a, localhost, user5, , ;
708 select "user5 in con5a" as status;
709 status
710 user5 in con5a
711 call dump_all();
712 processlist_user processlist_host
713 root localhost
714 user4 localhost
715 user4 localhost
716 user4 localhost
717 user5 localhost
718 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
719 root localhost 1 1
720 user4 localhost 3 3
721 user5 localhost 1 1
722 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
723 root 1 1
724 user5 1 1
725 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
726 localhost 5 5
727 variable_name variable_value
728 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
729 PERFORMANCE_SCHEMA_HOSTS_LOST 0
730 PERFORMANCE_SCHEMA_USERS_LOST 3
731 connect con5b, localhost, user5, , ;
732 select "user5 in con5b" as status;
733 status
734 user5 in con5b
735 call dump_all();
736 processlist_user processlist_host
737 root localhost
738 user4 localhost
739 user4 localhost
740 user4 localhost
741 user5 localhost
742 user5 localhost
743 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
744 root localhost 1 1
745 user4 localhost 3 3
746 user5 localhost 2 2
747 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
748 root 1 1
749 user5 2 2
750 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
751 localhost 6 6
752 variable_name variable_value
753 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
754 PERFORMANCE_SCHEMA_HOSTS_LOST 0
755 PERFORMANCE_SCHEMA_USERS_LOST 3
756 connect con5c, localhost, user5, , ;
757 select "user5 in con5c" as status;
758 status
759 user5 in con5c
760 call dump_all();
761 processlist_user processlist_host
762 root localhost
763 user4 localhost
764 user4 localhost
765 user4 localhost
766 user5 localhost
767 user5 localhost
768 user5 localhost
769 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
770 root localhost 1 1
771 user4 localhost 3 3
772 user5 localhost 3 3
773 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
774 root 1 1
775 user5 3 3
776 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
777 localhost 7 7
778 variable_name variable_value
779 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
780 PERFORMANCE_SCHEMA_HOSTS_LOST 0
781 PERFORMANCE_SCHEMA_USERS_LOST 3
782 connection default;
783 disconnect con4a;
784 disconnect con4b;
785 disconnect con4c;
786 disconnect con5a;
787 disconnect con5b;
788 disconnect con5c;
789 select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status;
790 status
791 con 5a, 5b, 5c, 6a, 6b, 6c disconnected
792 call dump_all();
793 processlist_user processlist_host
794 root localhost
795 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
796 root localhost 1 1
797 user4 localhost 0 3
798 user5 localhost 0 3
799 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
800 root 1 1
801 user5 0 3
802 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
803 localhost 1 7
804 variable_name variable_value
805 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
806 PERFORMANCE_SCHEMA_HOSTS_LOST 0
807 PERFORMANCE_SCHEMA_USERS_LOST 3
808 truncate table performance_schema.hosts;
809 call dump_all();
810 processlist_user processlist_host
811 root localhost
812 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
813 root localhost 1 1
814 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
815 root 1 1
816 user5 0 3
817 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
818 localhost 1 1
819 variable_name variable_value
820 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
821 PERFORMANCE_SCHEMA_HOSTS_LOST 0
822 PERFORMANCE_SCHEMA_USERS_LOST 3
823 truncate table performance_schema.users;
824 call dump_all();
825 processlist_user processlist_host
826 root localhost
827 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
828 root localhost 1 1
829 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
830 root 1 1
831 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
832 localhost 1 1
833 variable_name variable_value
834 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
835 PERFORMANCE_SCHEMA_HOSTS_LOST 0
836 PERFORMANCE_SCHEMA_USERS_LOST 3
837 truncate table performance_schema.accounts;
838 call dump_all();
839 processlist_user processlist_host
840 root localhost
841 USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
842 root localhost 1 1
843 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
844 root 1 1
845 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
846 localhost 1 1
847 variable_name variable_value
848 PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0
849 PERFORMANCE_SCHEMA_HOSTS_LOST 0
850 PERFORMANCE_SCHEMA_USERS_LOST 3