"================== Step 1 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	1
connect  con1, localhost, user1, , ;
connection default;
"================== Step 2 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	1
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	1
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	1
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	1
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	1
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	0
user1	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	2	2
connection con1;
select get_lock("marker", 10);
get_lock("marker", 10)
1
select release_lock("marker");
release_lock("marker")
1
insert into test.t1 values ("marker");
connection default;
"================== Step 3 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	4
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	4
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	4
wait/synch/rwlock/sql/LOCK_grant	1
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	3
localhost	stage/sql/Closing tables	6
localhost	stage/sql/Init	5
localhost	stage/sql/Init for update	1
localhost	stage/sql/Opening tables	4
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	3
stage/sql/Closing tables	6
stage/sql/Init	5
stage/sql/Init for update	1
stage/sql/Opening tables	4
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	3
stage/sql/Closing tables	6
stage/sql/Init	5
stage/sql/Init for update	1
stage/sql/Opening tables	4
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	1
localhost	statement/sql/select	2
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	1
statement/sql/select	2
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	1
statement/sql/select	2
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	2	2
connect  con2, localhost, user2, , ;
connection default;
"================== Step 4 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	1
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	1
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	5
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	5
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	5
wait/synch/rwlock/sql/LOCK_grant	1
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	3
localhost	stage/sql/Closing tables	6
localhost	stage/sql/Init	5
localhost	stage/sql/Init for update	1
localhost	stage/sql/Opening tables	4
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	3
stage/sql/Closing tables	6
stage/sql/Init	5
stage/sql/Init for update	1
stage/sql/Opening tables	4
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	3
stage/sql/Closing tables	6
stage/sql/Init	5
stage/sql/Init for update	1
stage/sql/Opening tables	4
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	0
user2	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	1
localhost	statement/sql/select	2
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	1
statement/sql/select	2
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	1
statement/sql/select	2
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	3	3
connection con2;
select get_lock("marker", 10);
get_lock("marker", 10)
1
select release_lock("marker");
release_lock("marker")
1
insert into test.t1 values ("marker");
connection default;
"================== Step 5 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	8
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	2
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	8
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	2
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	8
wait/synch/rwlock/sql/LOCK_grant	2
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	6
localhost	stage/sql/Closing tables	10
localhost	stage/sql/Init	10
localhost	stage/sql/Init for update	2
localhost	stage/sql/Opening tables	7
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	6
stage/sql/Closing tables	10
stage/sql/Init	10
stage/sql/Init for update	2
stage/sql/Opening tables	7
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	6
stage/sql/Closing tables	10
stage/sql/Init	10
stage/sql/Init for update	2
stage/sql/Opening tables	7
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	2
localhost	statement/sql/select	4
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	2
statement/sql/select	4
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	2
statement/sql/select	4
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	3	3
connect  con3, localhost, user3, , ;
connection default;
"================== Step 6 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user3	wait/io/file/sql/query_log	1
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	1
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	9
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	2
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	9
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	2
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	9
wait/synch/rwlock/sql/LOCK_grant	2
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	6
localhost	stage/sql/Closing tables	10
localhost	stage/sql/Init	10
localhost	stage/sql/Init for update	2
localhost	stage/sql/Opening tables	7
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	6
stage/sql/Closing tables	10
stage/sql/Init	10
stage/sql/Init for update	2
stage/sql/Opening tables	7
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	6
stage/sql/Closing tables	10
stage/sql/Init	10
stage/sql/Init for update	2
stage/sql/Opening tables	7
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	0
user3	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	2
localhost	statement/sql/select	4
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	2
statement/sql/select	4
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	2
statement/sql/select	4
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
user3	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	4	4
connection con3;
select get_lock("marker", 10);
get_lock("marker", 10)
1
select release_lock("marker");
release_lock("marker")
1
insert into test.t1 values ("marker");
connection default;
"================== Step 7 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	12
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	3
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	12
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	3
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	12
wait/synch/rwlock/sql/LOCK_grant	3
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	5
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	9
localhost	stage/sql/Closing tables	14
localhost	stage/sql/Init	15
localhost	stage/sql/Init for update	3
localhost	stage/sql/Opening tables	10
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	9
stage/sql/Closing tables	14
stage/sql/Init	15
stage/sql/Init for update	3
stage/sql/Opening tables	10
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	9
stage/sql/Closing tables	14
stage/sql/Init	15
stage/sql/Init for update	3
stage/sql/Opening tables	10
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	1
user3	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	3
localhost	statement/sql/select	6
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	3
statement/sql/select	6
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	3
statement/sql/select	6
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
user3	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	4	4
connect  con4, localhost, user4, , ;
connection default;
"================== Step 8 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user4	wait/io/file/sql/query_log	1
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	1
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	13
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	3
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	13
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	3
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	13
wait/synch/rwlock/sql/LOCK_grant	3
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	5
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	9
localhost	stage/sql/Closing tables	14
localhost	stage/sql/Init	15
localhost	stage/sql/Init for update	3
localhost	stage/sql/Opening tables	10
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	9
stage/sql/Closing tables	14
stage/sql/Init	15
stage/sql/Init for update	3
stage/sql/Opening tables	10
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	9
stage/sql/Closing tables	14
stage/sql/Init	15
stage/sql/Init for update	3
stage/sql/Opening tables	10
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	0
user4	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	3
localhost	statement/sql/select	6
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	3
statement/sql/select	6
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	3
statement/sql/select	6
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
user3	1	1
user4	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	5	5
connection con4;
select get_lock("marker", 10);
get_lock("marker", 10)
1
select release_lock("marker");
release_lock("marker")
1
insert into test.t1 values ("marker");
connection default;
"================== Step 9 =================="
call dump_thread();
username	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	4
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	16
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	16
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	16
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	5
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	5
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	5
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	20
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	20
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	20
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	1	1
user2	1	1
user3	1	1
user4	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	5	5
disconnect con1;
connection default;
"================== Step 10 =================="
call dump_thread();
username	status
user1	not found
username	event_name	count_star
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	4
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	17
localhost	wait/synch/mutex/sql/LOCK_connection_count	1
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	17
wait/synch/mutex/sql/LOCK_connection_count	1
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	17
wait/synch/mutex/sql/LOCK_connection_count	1
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	5
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	5
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	5
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	21
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	21
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	21
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	1
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	1
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	1
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	1	1
user3	1	1
user4	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	4	5
disconnect con2;
connection default;
"================== Step 11 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	event_name	count_star
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
username	event_name	count_star
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	5
user2	wait/synch/mutex/sql/LOCK_connection_count	1
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	4
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	18
localhost	wait/synch/mutex/sql/LOCK_connection_count	2
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	18
wait/synch/mutex/sql/LOCK_connection_count	2
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	18
wait/synch/mutex/sql/LOCK_connection_count	2
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	5
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	5
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	22
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	22
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	22
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	2
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	2
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	2
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	1	1
user4	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	3	5
disconnect con3;
connection default;
"================== Step 12 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	event_name	count_star
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	5
user2	wait/synch/mutex/sql/LOCK_connection_count	1
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	5
user3	wait/synch/mutex/sql/LOCK_connection_count	1
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	4
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	19
localhost	wait/synch/mutex/sql/LOCK_connection_count	3
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	19
wait/synch/mutex/sql/LOCK_connection_count	3
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	19
wait/synch/mutex/sql/LOCK_connection_count	3
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	5
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	23
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	23
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	23
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	3
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	3
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	3
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	2	5
disconnect con4;
connection default;
"================== Step 13 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	5
user2	wait/synch/mutex/sql/LOCK_connection_count	1
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	5
user3	wait/synch/mutex/sql/LOCK_connection_count	1
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	5
user4	wait/synch/mutex/sql/LOCK_connection_count	1
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	20
localhost	wait/synch/mutex/sql/LOCK_connection_count	4
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
connection default;
truncate performance_schema.events_waits_summary_by_thread_by_event_name;
"================== WAITS_BY_THREAD truncated =================="
"================== Step 14 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	5
user2	wait/synch/mutex/sql/LOCK_connection_count	1
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	5
user3	wait/synch/mutex/sql/LOCK_connection_count	1
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	5
user4	wait/synch/mutex/sql/LOCK_connection_count	1
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	20
localhost	wait/synch/mutex/sql/LOCK_connection_count	4
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_waits_summary_by_account_by_event_name;
"================== WAITS_BY_ACCOUNT truncated =================="
"================== Step 15 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	5
user1	wait/synch/mutex/sql/LOCK_connection_count	1
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	1
user2	wait/io/file/sql/query_log	5
user2	wait/synch/mutex/sql/LOCK_connection_count	1
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	1
user3	wait/io/file/sql/query_log	5
user3	wait/synch/mutex/sql/LOCK_connection_count	1
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	1
user4	wait/io/file/sql/query_log	5
user4	wait/synch/mutex/sql/LOCK_connection_count	1
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	1
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	20
localhost	wait/synch/mutex/sql/LOCK_connection_count	4
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_waits_summary_by_user_by_event_name;
"================== WAITS_BY_USER truncated =================="
"================== Step 16 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	20
localhost	wait/synch/mutex/sql/LOCK_connection_count	4
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_waits_summary_by_host_by_event_name;
"================== WAITS_BY_HOST truncated =================="
"================== Step 17 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_waits_summary_global_by_event_name;
"================== WAITS_GLOBAL truncated =================="
"================== Step 18 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_stages_summary_by_thread_by_event_name;
"================== STAGES_BY_THREAD truncated =================="
"================== Step 19 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_stages_summary_by_account_by_event_name;
"================== STAGES_BY_ACCOUNT truncated =================="
"================== Step 20 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	3
user1	stage/sql/Closing tables	6
user1	stage/sql/Init	6
user1	stage/sql/Init for update	1
user1	stage/sql/Opening tables	4
user2	stage/sql/Checking permissions	3
user2	stage/sql/Closing tables	4
user2	stage/sql/Init	6
user2	stage/sql/Init for update	1
user2	stage/sql/Opening tables	3
user3	stage/sql/Checking permissions	3
user3	stage/sql/Closing tables	4
user3	stage/sql/Init	6
user3	stage/sql/Init for update	1
user3	stage/sql/Opening tables	3
user4	stage/sql/Checking permissions	3
user4	stage/sql/Closing tables	4
user4	stage/sql/Init	6
user4	stage/sql/Init for update	1
user4	stage/sql/Opening tables	3
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_stages_summary_by_user_by_event_name;
"================== STAGES_BY_USER truncated =================="
"================== Step 21 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	12
localhost	stage/sql/Closing tables	18
localhost	stage/sql/Init	24
localhost	stage/sql/Init for update	4
localhost	stage/sql/Opening tables	13
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_stages_summary_by_host_by_event_name;
"================== STAGES_BY_HOST truncated =================="
"================== Step 22 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_stages_summary_global_by_event_name;
"================== STAGES_GLOBAL truncated =================="
"================== Step 23 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_statements_summary_by_thread_by_event_name;
"================== STATEMENTS_BY_THREAD truncated =================="
"================== Step 24 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_statements_summary_by_account_by_event_name;
"================== STATEMENTS_BY_ACCOUNT truncated =================="
"================== Step 25 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	1
user1	statement/sql/insert	1
user1	statement/sql/select	2
user2	statement/com/Error	0
user2	statement/com/Quit	1
user2	statement/sql/insert	1
user2	statement/sql/select	2
user3	statement/com/Error	0
user3	statement/com/Quit	1
user3	statement/sql/insert	1
user3	statement/sql/select	2
user4	statement/com/Error	0
user4	statement/com/Quit	1
user4	statement/sql/insert	1
user4	statement/sql/select	2
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_statements_summary_by_user_by_event_name;
"================== STATEMENTS_BY_USER truncated =================="
"================== Step 26 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	0
user1	statement/sql/select	0
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	0
user2	statement/sql/select	0
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	0
user3	statement/sql/select	0
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	0
user4	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	4
localhost	statement/sql/insert	4
localhost	statement/sql/select	8
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_statements_summary_by_host_by_event_name;
"================== STATEMENTS_BY_HOST truncated =================="
"================== Step 27 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	0
user1	statement/sql/select	0
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	0
user2	statement/sql/select	0
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	0
user3	statement/sql/select	0
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	0
user4	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.events_statements_summary_global_by_event_name;
"================== STATEMENTS_GLOBAL truncated =================="
"================== Step 28 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	0
user1	statement/sql/select	0
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	0
user2	statement/sql/select	0
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	0
user3	statement/sql/select	0
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	0
user4	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.accounts;
"================== ACCOUNTS truncated =================="
"================== Step 29 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
user1	wait/io/file/sql/query_log	0
user1	wait/synch/mutex/sql/LOCK_connection_count	0
user1	wait/synch/mutex/sql/LOCK_user_locks	0
user1	wait/synch/rwlock/sql/LOCK_grant	0
user2	wait/io/file/sql/query_log	0
user2	wait/synch/mutex/sql/LOCK_connection_count	0
user2	wait/synch/mutex/sql/LOCK_user_locks	0
user2	wait/synch/rwlock/sql/LOCK_grant	0
user3	wait/io/file/sql/query_log	0
user3	wait/synch/mutex/sql/LOCK_connection_count	0
user3	wait/synch/mutex/sql/LOCK_user_locks	0
user3	wait/synch/rwlock/sql/LOCK_grant	0
user4	wait/io/file/sql/query_log	0
user4	wait/synch/mutex/sql/LOCK_connection_count	0
user4	wait/synch/mutex/sql/LOCK_user_locks	0
user4	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
user1	stage/sql/Checking permissions	0
user1	stage/sql/Closing tables	0
user1	stage/sql/Init	0
user1	stage/sql/Init for update	0
user1	stage/sql/Opening tables	0
user2	stage/sql/Checking permissions	0
user2	stage/sql/Closing tables	0
user2	stage/sql/Init	0
user2	stage/sql/Init for update	0
user2	stage/sql/Opening tables	0
user3	stage/sql/Checking permissions	0
user3	stage/sql/Closing tables	0
user3	stage/sql/Init	0
user3	stage/sql/Init for update	0
user3	stage/sql/Opening tables	0
user4	stage/sql/Checking permissions	0
user4	stage/sql/Closing tables	0
user4	stage/sql/Init	0
user4	stage/sql/Init for update	0
user4	stage/sql/Opening tables	0
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
user1	statement/com/Error	0
user1	statement/com/Quit	0
user1	statement/sql/insert	0
user1	statement/sql/select	0
user2	statement/com/Error	0
user2	statement/com/Quit	0
user2	statement/sql/insert	0
user2	statement/sql/select	0
user3	statement/com/Error	0
user3	statement/com/Quit	0
user3	statement/sql/insert	0
user3	statement/sql/select	0
user4	statement/com/Error	0
user4	statement/com/Quit	0
user4	statement/sql/insert	0
user4	statement/sql/select	0
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
user1	0	1
user2	0	1
user3	0	1
user4	0	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.users;
"================== USERS truncated =================="
"================== Step 30 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	5
truncate performance_schema.hosts;
"================== HOSTS truncated =================="
"================== Step 31 =================="
call dump_thread();
username	status
user1	not found
username	status
user2	not found
username	status
user3	not found
username	status
user4	not found
execute dump_waits_account;
user	host	event_name	count_star
execute dump_waits_user;
user	event_name	count_star
execute dump_waits_host;
host	event_name	count_star
localhost	wait/io/file/sql/query_log	0
localhost	wait/synch/mutex/sql/LOCK_connection_count	0
localhost	wait/synch/mutex/sql/LOCK_user_locks	0
localhost	wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_global;
event_name	count_star
wait/io/file/sql/query_log	0
wait/synch/mutex/sql/LOCK_connection_count	0
wait/synch/mutex/sql/LOCK_user_locks	0
wait/synch/rwlock/sql/LOCK_grant	0
execute dump_waits_history;
event_name	count(event_name)
wait/io/file/sql/query_log	20
wait/synch/mutex/sql/LOCK_connection_count	4
wait/synch/rwlock/sql/LOCK_grant	4
execute dump_stages_account;
user	host	event_name	count_star
execute dump_stages_user;
user	event_name	count_star
execute dump_stages_host;
host	event_name	count_star
localhost	stage/sql/Checking permissions	0
localhost	stage/sql/Closing tables	0
localhost	stage/sql/Init	0
localhost	stage/sql/Init for update	0
localhost	stage/sql/Opening tables	0
execute dump_stages_global;
event_name	count_star
stage/sql/Checking permissions	0
stage/sql/Closing tables	0
stage/sql/Init	0
stage/sql/Init for update	0
stage/sql/Opening tables	0
execute dump_stages_history;
event_name	count(event_name)
stage/sql/Checking permissions	12
stage/sql/Closing tables	18
stage/sql/Init	24
stage/sql/Init for update	4
stage/sql/Opening tables	13
execute dump_statements_account;
user	host	event_name	count_star
execute dump_statements_user;
user	event_name	count_star
execute dump_statements_host;
host	event_name	count_star
localhost	statement/com/Error	0
localhost	statement/com/Quit	0
localhost	statement/sql/insert	0
localhost	statement/sql/select	0
execute dump_statements_global;
event_name	count_star
statement/com/Error	0
statement/com/Quit	0
statement/sql/insert	0
statement/sql/select	0
execute dump_statements_history;
event_name	count(event_name)
statement/com/Quit	4
statement/sql/insert	4
statement/sql/select	8
execute dump_accounts;
USER	HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
execute dump_users;
USER	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
root	1	1
execute dump_hosts;
HOST	CURRENT_CONNECTIONS	TOTAL_CONNECTIONS
localhost	1	1