Debian Codegraph @

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

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