| Server IP : 104.21.38.3 / Your IP : 172.70.147.22 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/include/ |
Upload File : |
# Tests for the performance schema # ======================================= # HELPER include/connection_load.inc # ======================================= call dump_all(); connect (con1a, localhost, user1, , ); select "user1 in con1a" as status; call dump_all(); connect (con1b, localhost, user1, , ); select "user1 in con1b" as status; call dump_all(); connect (con1c, localhost, user1, , ); select "user1 in con1c" as status; call dump_all(); connect (con2a, localhost, user2, , ); select "user2 in con2a" as status; call dump_all(); connect (con2b, localhost, user2, , ); select "user2 in con2b" as status; call dump_all(); connect (con2c, localhost, user2, , ); select "user2 in con2c" as status; call dump_all(); connect (con3a, localhost, user3, , ); select "user3 in con3a" as status; call dump_all(); connect (con3b, localhost, user3, , ); select "user3 in con3b" as status; call dump_all(); connect (con3c, localhost, user3, , ); select "user3 in con3c" as status; call dump_all(); --connection default --disconnect con1a # Wait for the disconnect to complete let $wait_condition= select count(*) = 8 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con1a disconnected" as status; call dump_all(); --disconnect con2a # Wait for the disconnect to complete let $wait_condition= select count(*) = 7 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con2a disconnected" as status; call dump_all(); --disconnect con3a # Wait for the disconnect to complete let $wait_condition= select count(*) = 6 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con3a disconnected" as status; call dump_all(); truncate table performance_schema.accounts; call dump_all(); truncate table performance_schema.users; call dump_all(); truncate table performance_schema.hosts; call dump_all(); connect (con4a, localhost, user4, , ); select "user4 in con4a" as status; call dump_all(); connect (con4b, localhost, user4, , ); select "user4 in con4b" as status; call dump_all(); connect (con4c, localhost, user4, , ); select "user4 in con4c" as status; call dump_all(); --connection default --disconnect con1b # Wait for the disconnect to complete let $wait_condition= select count(*) = 8 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con1b disconnected" as status; call dump_all(); --disconnect con2b # Wait for the disconnect to complete let $wait_condition= select count(*) = 7 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con2b disconnected" as status; call dump_all(); --disconnect con3b # Wait for the disconnect to complete let $wait_condition= select count(*) = 6 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con3b disconnected" as status; call dump_all(); --disconnect con1c # Wait for the disconnect to complete let $wait_condition= select count(*) = 5 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con1c disconnected" as status; call dump_all(); --disconnect con2c # Wait for the disconnect to complete let $wait_condition= select count(*) = 4 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con2c disconnected" as status; call dump_all(); --disconnect con3c # Wait for the disconnect to complete let $wait_condition= select count(*) = 3 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con3c disconnected" as status; call dump_all(); truncate table performance_schema.accounts; call dump_all(); truncate table performance_schema.users; call dump_all(); truncate table performance_schema.hosts; call dump_all(); connect (con5a, localhost, user5, , ); select "user5 in con5a" as status; call dump_all(); connect (con5b, localhost, user5, , ); select "user5 in con5b" as status; call dump_all(); connect (con5c, localhost, user5, , ); select "user5 in con5c" as status; call dump_all(); --connection default --disconnect con4a # Wait for the disconnect to complete let $wait_condition= select count(*) = 5 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc --disconnect con4b # Wait for the disconnect to complete let $wait_condition= select count(*) = 4 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc --disconnect con4c # Wait for the disconnect to complete let $wait_condition= select count(*) = 3 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc --disconnect con5a # Wait for the disconnect to complete let $wait_condition= select count(*) = 2 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc --disconnect con5b # Wait for the disconnect to complete let $wait_condition= select count(*) = 1 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc --disconnect con5c # Wait for the disconnect to complete let $wait_condition= select count(*) = 0 from performance_schema.threads where `TYPE`='FOREGROUND' and PROCESSLIST_USER like 'user%'; --source include/wait_condition.inc select "con 5a, 5b, 5c, 6a, 6b, 6c disconnected" as status; call dump_all(); truncate table performance_schema.hosts; call dump_all(); truncate table performance_schema.users; call dump_all(); truncate table performance_schema.accounts; call dump_all();