From: Marc Alff Date: August 10 2011 1:31pm Subject: bzr push into mysql-trunk-wl5378 branch (marc.alff:3373 to 3374) WL#5378 List-Archive: http://lists.mysql.com/commits/140568 Message-Id: <201108101331.p7ADVxk2014458@acsmt356.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3374 Marc Alff 2011-08-10 WL#5378 PERFORMANCE_SCHEMA SUMMARY BY USER / HOST Added new tests. added: mysql-test/suite/perfschema/r/connection_3a_twice.result mysql-test/suite/perfschema/t/connection_3a_twice-master.opt mysql-test/suite/perfschema/t/connection_3a_twice.test 3373 Marc Alff 2011-08-10 [merge] Merge mysql-trunk --> mysql-trunk-wl5378 modified: mysql-test/collections/default.experimental mysql-test/include/mrr_tests.inc mysql-test/r/innodb_mrr.result mysql-test/r/innodb_mrr_cost.result mysql-test/r/innodb_mrr_cost_icp.result mysql-test/r/innodb_mrr_icp.result mysql-test/r/innodb_mrr_none.result mysql-test/r/myisam_mrr.result mysql-test/r/myisam_mrr_cost.result mysql-test/r/myisam_mrr_cost_icp.result mysql-test/r/myisam_mrr_icp.result mysql-test/r/myisam_mrr_none.result mysql-test/suite/innodb/r/innodb-zip.result mysql-test/suite/innodb/t/innodb-zip.test mysql-test/suite/opt_trace/include/general2.inc mysql-test/suite/opt_trace/r/general2_no_prot.result mysql-test/suite/opt_trace/r/general2_ps_prot.result sql/sql_select.cc storage/innobase/handler/ha_innodb.cc storage/perfschema/pfs_instr.cc storage/perfschema/pfs_instr_class.cc storage/perfschema/pfs_setup_actor.cc storage/perfschema/pfs_setup_object.cc support-files/mysql.spec.sh === added file 'mysql-test/suite/perfschema/r/connection_3a_twice.result' --- a/mysql-test/suite/perfschema/r/connection_3a_twice.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/r/connection_3a_twice.result 2011-08-10 13:30:54 +0000 @@ -0,0 +1,1672 @@ +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 +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 +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 +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 +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 +user2 1 1 +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 0 +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 +user2 2 2 +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 0 +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 +user2 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 0 +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 +user2 3 3 +user3 1 1 +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 0 +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 +user2 3 3 +user3 2 2 +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 0 +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 +user2 3 3 +user3 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 0 +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 +user2 3 3 +user3 3 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 0 +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 +user2 2 3 +user3 3 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 0 +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 +user2 2 3 +user3 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 0 +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 +user2 2 3 +user3 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 0 +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 +user2 2 2 +user3 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 0 +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 +user2 2 2 +user3 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 0 +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 +user2 2 2 +user3 2 2 +user4 1 1 +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 0 +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 +user2 2 2 +user3 2 2 +user4 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 0 +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 +user2 2 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 2 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 0 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 0 2 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 0 3 +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 0 +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 +user4 0 3 +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 0 +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 0 +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 0 +"conrootb connected" +select count(*) from information_schema.processlist; +count(*) +2 +select count(*) from performance_schema.threads +where `TYPE` = 'foreground' and processlist_user='root'; +count(*) +2 +"default disconnected" +select count(*) from information_schema.processlist; +count(*) +1 +select count(*) from performance_schema.threads +where `TYPE` = 'foreground' and processlist_user='root'; +count(*) +1 +"default re connected" +select count(*) from information_schema.processlist; +count(*) +2 +select count(*) from performance_schema.threads +where `TYPE` = 'foreground' and processlist_user='root'; +count(*) +2 +"conrootb disconnected" +select count(*) from information_schema.processlist; +count(*) +1 +select count(*) from performance_schema.threads +where `TYPE` = 'foreground' and processlist_user='root'; +count(*) +1 +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 +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 +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 +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 +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 +user2 1 1 +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 0 +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 +user2 2 2 +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 0 +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 +user2 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 0 +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 +user2 3 3 +user3 1 1 +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 0 +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 +user2 3 3 +user3 2 2 +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 0 +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 +user2 3 3 +user3 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 0 +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 +user2 3 3 +user3 3 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 0 +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 +user2 2 3 +user3 3 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 0 +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 +user2 2 3 +user3 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 0 +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 +user2 2 3 +user3 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 0 +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 +user2 2 2 +user3 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 0 +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 +user2 2 2 +user3 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 0 +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 +user2 2 2 +user3 2 2 +user4 1 1 +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 0 +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 +user2 2 2 +user3 2 2 +user4 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 0 +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 +user2 2 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 2 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 2 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 1 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 1 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 0 2 +user4 3 3 +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 0 +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 +user2 0 2 +user3 0 2 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 3 3 +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 0 +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 +user4 0 3 +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 0 +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 +user4 0 3 +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 0 +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 0 +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 0 === added file 'mysql-test/suite/perfschema/t/connection_3a_twice-master.opt' --- a/mysql-test/suite/perfschema/t/connection_3a_twice-master.opt 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/t/connection_3a_twice-master.opt 2011-08-10 13:30:54 +0000 @@ -0,0 +1 @@ +--loose-performance_schema_accounts_size=3 === added file 'mysql-test/suite/perfschema/t/connection_3a_twice.test' --- a/mysql-test/suite/perfschema/t/connection_3a_twice.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/t/connection_3a_twice.test 2011-08-10 13:30:54 +0000 @@ -0,0 +1,101 @@ +# Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved. +# +# This program is free software; you can redistribute it and/or modify +# it under the terms of the GNU General Public License as published by +# the Free Software Foundation; version 2 of the License. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. +# +# You should have received a copy of the GNU General Public License +# along with this program; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +# Tests for the performance schema +# + +--source ../include/connection_setup.inc +--source ../include/connection_load.inc +--source ../include/connection_cleanup.inc + +# The reason for repeating this test twice is as follows: +# after the first payload, the default root@localhost session +# sometimes deadlocks during disconnect, in a state where: +# the session is removed from information_schema.processlist +# the session is still present in performance_schema.threads +# This was originally found with: +# ./mtr --suite=perfschema --repeat=2 connection_3a +# +# This test verifies that a disconnect of the default session +# is performed gracefully + +connect (conrootb, localhost, root, , ); + +echo "conrootb connected"; + +select count(*) from information_schema.processlist; +select count(*) from performance_schema.threads + where `TYPE` = 'foreground' and processlist_user='root'; + +--disconnect default + +--connection conrootb + +# Wait for the disconnect to complete in the information_schema + +let $wait_condition= + select count(*) = 1 from information_schema.processlist; +--source include/wait_condition.inc + +# Wait for the disconnect to complete in the performance_schema + +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER = 'root'; +--source include/wait_condition.inc + +echo "default disconnected"; + +select count(*) from information_schema.processlist; +select count(*) from performance_schema.threads + where `TYPE` = 'foreground' and processlist_user='root'; + +# Now, restore a default connection again, and resume testing + +connect (default, localhost, root, , ); + +echo "default re connected"; + +select count(*) from information_schema.processlist; +select count(*) from performance_schema.threads + where `TYPE` = 'foreground' and processlist_user='root'; + +--disconnect conrootb + +--connection default + +# Wait for the disconnect to complete in the information_schema + +let $wait_condition= + select count(*) = 1 from information_schema.processlist; +--source include/wait_condition.inc + +# Wait for the disconnect to complete in the performance_schema + +let $wait_condition= + select count(*) = 1 from performance_schema.threads + where `TYPE`='FOREGROUND' and PROCESSLIST_USER = 'root'; +--source include/wait_condition.inc + +echo "conrootb disconnected"; + +select count(*) from information_schema.processlist; +select count(*) from performance_schema.threads + where `TYPE` = 'foreground' and processlist_user='root'; + +--source ../include/connection_setup.inc +--source ../include/connection_load.inc +--source ../include/connection_cleanup.inc + No bundle (reason: useless for push emails).