List:Commits« Previous MessageNext Message »
From:Marc Alff Date:August 10 2011 3:37pm
Subject:bzr push into mysql-trunk-wl5378 branch (marc.alff:3374 to 3375)
View as plain text  
 3375 Marc Alff	2011-08-10
      Reverted the previous change.
      
      The test added was too unstable on heavy load, causing other issues.

    removed:
      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
 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
=== removed file 'mysql-test/suite/perfschema/r/connection_3a_twice.result'
--- a/mysql-test/suite/perfschema/r/connection_3a_twice.result	2011-08-10 13:30:54 +0000
+++ b/mysql-test/suite/perfschema/r/connection_3a_twice.result	1970-01-01 00:00:00 +0000
@@ -1,1672 +0,0 @@
-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

=== removed file 'mysql-test/suite/perfschema/t/connection_3a_twice-master.opt'
--- a/mysql-test/suite/perfschema/t/connection_3a_twice-master.opt	2011-08-10 13:30:54 +0000
+++ b/mysql-test/suite/perfschema/t/connection_3a_twice-master.opt	1970-01-01 00:00:00 +0000
@@ -1 +0,0 @@
---loose-performance_schema_accounts_size=3

=== removed file 'mysql-test/suite/perfschema/t/connection_3a_twice.test'
--- a/mysql-test/suite/perfschema/t/connection_3a_twice.test	2011-08-10 13:30:54 +0000
+++ b/mysql-test/suite/perfschema/t/connection_3a_twice.test	1970-01-01 00:00:00 +0000
@@ -1,101 +0,0 @@
-# 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).
Thread
• bzr push into mysql-trunk-wl5378 branch (marc.alff:3374 to 3375) Marc Alff11 Aug