| Server IP : 104.21.38.3 / Your IP : 172.69.176.137 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/perfschema/r/ |
Upload File : |
Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. call dump_all(); processlist_user processlist_host root localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 1 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user1 in con1a" as status; status user1 in con1a call dump_all(); processlist_user processlist_host root localhost user1 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 2 2 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user1 in con1b" as status; status user1 in con1b call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 3 3 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user1 in con1c" as status; status user1 in con1c call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 4 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 0 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 0 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user2 in con2a" as status; status user2 in con2a call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 5 5 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 1 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 1 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user2 in con2b" as status; status user2 in con2b call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost user2 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 6 6 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 2 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 2 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user2 in con2c" as status; status user2 in con2c call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost user2 localhost user2 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 7 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 3 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 3 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user3 in con3a" as status; status user3 in con3a call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost user2 localhost user2 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 8 8 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 4 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 4 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user3 in con3b" as status; status user3 in con3b call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost user2 localhost user2 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 9 9 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 5 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 5 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user3 in con3c" as status; status user3 in con3c call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user1 localhost user2 localhost user2 localhost user2 localhost user3 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 10 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con1a disconnected" as status; status con1a disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user2 localhost user3 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 9 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con2a disconnected" as status; status con2a disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 8 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con3a disconnected" as status; status con3a disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.accounts; call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.users; call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.hosts; call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 7 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 6 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 6 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user4 in con4a" as status; status user4 in con4a call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 8 8 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 7 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 7 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user4 in con4b" as status; status user4 in con4b call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 9 9 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 8 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 8 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user4 in con4c" as status; status user4 in con4c call dump_all(); processlist_user processlist_host root localhost user1 localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 10 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con1b disconnected" as status; status con1b disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user2 localhost user2 localhost user3 localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 9 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con2b disconnected" as status; status con2b disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user2 localhost user3 localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 8 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con3b disconnected" as status; status con3b disconnected call dump_all(); processlist_user processlist_host root localhost user1 localhost user2 localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 1 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 1 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con1c disconnected" as status; status con1c disconnected call dump_all(); processlist_user processlist_host root localhost user2 localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 6 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con2c disconnected" as status; status con2c disconnected call dump_all(); processlist_user processlist_host root localhost user3 localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 5 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con3c disconnected" as status; status con3c disconnected call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user1 localhost 0 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.accounts; call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user1 0 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.users; call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 10 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.hosts; call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 4 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user5 in con5a" as status; status user5 in con5a call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost user5 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user5 localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user5 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 5 5 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user5 in con5b" as status; status user5 in con5b call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost user5 localhost user5 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user5 localhost 2 2 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user5 2 2 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 6 6 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "user5 in con5c" as status; status user5 in con5c call dump_all(); processlist_user processlist_host root localhost user4 localhost user4 localhost user4 localhost user5 localhost user5 localhost user5 localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user5 localhost 3 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user5 3 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 7 7 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status; status con 5a, 5b, 5c, 6a, 6b, 6c disconnected call dump_all(); processlist_user processlist_host root localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 user5 localhost 0 3 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user5 0 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 7 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.hosts; call dump_all(); processlist_user processlist_host root localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 user5 0 3 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 1 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.users; call dump_all(); processlist_user processlist_host root localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 1 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead truncate table performance_schema.accounts; call dump_all(); processlist_user processlist_host root localhost USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS root 1 1 HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 1 variable_name variable_value PERFORMANCE_SCHEMA_ACCOUNTS_LOST 9 PERFORMANCE_SCHEMA_HOSTS_LOST 0 PERFORMANCE_SCHEMA_USERS_LOST 9 Warnings: Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead