"================== 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
execute dump_transactions_account;
user host event_name count_star
execute dump_transactions_user;
user event_name count_star
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
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, ,test;
connection default;
"================== Step 2 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 1
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
user1 localhost wait/io/file/sql/query_log 1
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 1
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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 1
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
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
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 uuid_short() <> 1;
uuid_short() <> 1
1
select uuid_short() <> 1;
uuid_short() <> 1
1
start transaction;
insert into test.t1 values ("marker");
commit;
select test.f(10,20);
test.f(10,20)
30
connection default;
"================== Step 3 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
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
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 7
localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 7
wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 7
wait/synch/rwlock/sql/LOCK_grant 1
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 4
localhost stage/sql/closing tables 12
localhost stage/sql/init 3
localhost stage/sql/Opening tables 8
localhost stage/sql/starting 7
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 4
stage/sql/closing tables 12
stage/sql/init 3
stage/sql/Opening tables 8
stage/sql/starting 7
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 4
stage/sql/closing tables 12
stage/sql/init 3
stage/sql/Opening tables 8
stage/sql/starting 7
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 0
localhost statement/sp/freturn 1
localhost statement/sql/insert 1
localhost statement/sql/select 3
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 1
statement/sql/insert 1
statement/sql/select 3
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 1
statement/sql/insert 1
statement/sql/select 3
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 3
execute dump_transactions_global;
event_name count_star
transaction 3
execute dump_transactions_history;
event_name count(event_name)
transaction 3
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
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, ,test;
connection default;
"================== Step 4 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 1
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
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 1
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 1
user2 wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 8
localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 8
wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 8
wait/synch/rwlock/sql/LOCK_grant 1
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 4
localhost stage/sql/closing tables 12
localhost stage/sql/init 3
localhost stage/sql/Opening tables 8
localhost stage/sql/starting 7
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 4
stage/sql/closing tables 12
stage/sql/init 3
stage/sql/Opening tables 8
stage/sql/starting 7
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 4
stage/sql/closing tables 12
stage/sql/init 3
stage/sql/Opening tables 8
stage/sql/starting 7
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 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/sp/freturn 1
localhost statement/sql/insert 1
localhost statement/sql/select 3
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 1
statement/sql/insert 1
statement/sql/select 3
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 1
statement/sql/insert 1
statement/sql/select 3
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 3
execute dump_transactions_global;
event_name count_star
transaction 3
execute dump_transactions_history;
event_name count(event_name)
transaction 3
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
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 uuid_short() <> 1;
uuid_short() <> 1
1
select uuid_short() <> 1;
uuid_short() <> 1
1
start transaction;
insert into test.t1 values ("marker");
commit;
select test.f(10,20);
test.f(10,20)
30
connection default;
"================== Step 5 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 7
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
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 14
localhost wait/synch/rwlock/sql/LOCK_grant 2
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 14
wait/synch/rwlock/sql/LOCK_grant 2
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 14
wait/synch/rwlock/sql/LOCK_grant 2
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 8
localhost stage/sql/closing tables 23
localhost stage/sql/init 6
localhost stage/sql/Opening tables 15
localhost stage/sql/starting 14
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 8
stage/sql/closing tables 23
stage/sql/init 6
stage/sql/Opening tables 15
stage/sql/starting 14
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 8
stage/sql/closing tables 23
stage/sql/init 6
stage/sql/Opening tables 15
stage/sql/starting 14
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 0
localhost statement/sp/freturn 2
localhost statement/sql/insert 2
localhost statement/sql/select 6
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 2
statement/sql/insert 2
statement/sql/select 6
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 2
statement/sql/insert 2
statement/sql/select 6
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 6
execute dump_transactions_global;
event_name count_star
transaction 6
execute dump_transactions_history;
event_name count(event_name)
transaction 6
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
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, ,test;
connection default;
"================== Step 6 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user3 wait/io/file/sql/query_log 1
user3 wait/synch/rwlock/sql/LOCK_grant 0
username status
user4 not found
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 1
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 1
user3 wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 15
localhost wait/synch/rwlock/sql/LOCK_grant 2
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 15
wait/synch/rwlock/sql/LOCK_grant 2
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 15
wait/synch/rwlock/sql/LOCK_grant 2
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 8
localhost stage/sql/closing tables 23
localhost stage/sql/init 6
localhost stage/sql/Opening tables 15
localhost stage/sql/starting 14
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 8
stage/sql/closing tables 23
stage/sql/init 6
stage/sql/Opening tables 15
stage/sql/starting 14
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 8
stage/sql/closing tables 23
stage/sql/init 6
stage/sql/Opening tables 15
stage/sql/starting 14
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 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/sp/freturn 2
localhost statement/sql/insert 2
localhost statement/sql/select 6
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 2
statement/sql/insert 2
statement/sql/select 6
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 2
statement/sql/insert 2
statement/sql/select 6
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 6
execute dump_transactions_global;
event_name count_star
transaction 6
execute dump_transactions_history;
event_name count(event_name)
transaction 6
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
user3 localhost 1 1
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 uuid_short() <> 1;
uuid_short() <> 1
1
select uuid_short() <> 1;
uuid_short() <> 1
1
start transaction;
insert into test.t1 values ("marker");
commit;
select test.f(10,20);
test.f(10,20)
30
connection default;
"================== Step 7 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
username status
user4 not found
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 7
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 21
localhost wait/synch/rwlock/sql/LOCK_grant 3
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 21
wait/synch/rwlock/sql/LOCK_grant 3
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 21
wait/synch/rwlock/sql/LOCK_grant 3
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 12
localhost stage/sql/closing tables 34
localhost stage/sql/init 9
localhost stage/sql/Opening tables 22
localhost stage/sql/starting 21
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 12
stage/sql/closing tables 34
stage/sql/init 9
stage/sql/Opening tables 22
stage/sql/starting 21
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 12
stage/sql/closing tables 34
stage/sql/init 9
stage/sql/Opening tables 22
stage/sql/starting 21
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 0
localhost statement/sp/freturn 3
localhost statement/sql/insert 3
localhost statement/sql/select 9
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 3
statement/sql/insert 3
statement/sql/select 9
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 3
statement/sql/insert 3
statement/sql/select 9
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 9
execute dump_transactions_global;
event_name count_star
transaction 9
execute dump_transactions_history;
event_name count(event_name)
transaction 9
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
user3 localhost 1 1
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, ,test;
connection default;
"================== Step 8 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user4 wait/io/file/sql/query_log 1
user4 wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 7
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 1
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 1
user4 wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 22
localhost wait/synch/rwlock/sql/LOCK_grant 3
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 22
wait/synch/rwlock/sql/LOCK_grant 3
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 22
wait/synch/rwlock/sql/LOCK_grant 3
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 7
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 7
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 0
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 12
localhost stage/sql/closing tables 34
localhost stage/sql/init 9
localhost stage/sql/Opening tables 22
localhost stage/sql/starting 21
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 12
stage/sql/closing tables 34
stage/sql/init 9
stage/sql/Opening tables 22
stage/sql/starting 21
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 12
stage/sql/closing tables 34
stage/sql/init 9
stage/sql/Opening tables 22
stage/sql/starting 21
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 3
localhost statement/sql/insert 3
localhost statement/sql/select 9
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 3
statement/sql/insert 3
statement/sql/select 9
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 3
statement/sql/insert 3
statement/sql/select 9
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 9
execute dump_transactions_global;
event_name count_star
transaction 9
execute dump_transactions_history;
event_name count(event_name)
transaction 9
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
user3 localhost 1 1
user4 localhost 1 1
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 uuid_short() <> 1;
uuid_short() <> 1
1
select uuid_short() <> 1;
uuid_short() <> 1
1
start transaction;
insert into test.t1 values ("marker");
commit;
select test.f(10,20);
test.f(10,20)
30
connection default;
"================== Step 9 =================="
call dump_thread();
username event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 7
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 7
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 7
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 7
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 28
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 28
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 28
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 7
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 7
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 7
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 7
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 28
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 28
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 28
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 0
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 0
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 1 1
user2 localhost 1 1
user3 localhost 1 1
user4 localhost 1 1
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 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 8
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 7
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 7
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 7
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 7
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 29
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 29
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 29
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 7
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 7
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 7
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 7
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 29
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 29
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 29
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 1
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 1
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 1
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 1 1
user3 localhost 1 1
user4 localhost 1 1
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 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
username event_name count_star
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 8
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 8
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 7
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 7
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 8
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 7
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 30
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 30
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 30
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 7
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 7
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 30
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 30
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 30
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 2
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 2
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 2
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 1 1
user4 localhost 1 1
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 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_account;
user host event_name count_star
user1 localhost wait/io/file/sql/query_log 8
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 8
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 8
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 7
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 8
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 8
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 7
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 31
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 31
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 31
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 7
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 7
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 31
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 31
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 31
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 3
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 3
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 3
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 1 1
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
user1 localhost wait/io/file/sql/query_log 8
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 8
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 8
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 8
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 8
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 8
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 8
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 32
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 8
user1 localhost wait/synch/rwlock/sql/LOCK_grant 1
user2 localhost wait/io/file/sql/query_log 8
user2 localhost wait/synch/rwlock/sql/LOCK_grant 1
user3 localhost wait/io/file/sql/query_log 8
user3 localhost wait/synch/rwlock/sql/LOCK_grant 1
user4 localhost wait/io/file/sql/query_log 8
user4 localhost wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 8
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 8
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 8
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 32
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 8
user1 wait/synch/rwlock/sql/LOCK_grant 1
user2 wait/io/file/sql/query_log 8
user2 wait/synch/rwlock/sql/LOCK_grant 1
user3 wait/io/file/sql/query_log 8
user3 wait/synch/rwlock/sql/LOCK_grant 1
user4 wait/io/file/sql/query_log 8
user4 wait/synch/rwlock/sql/LOCK_grant 1
execute dump_waits_host;
host event_name count_star
localhost wait/io/file/sql/query_log 32
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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 32
localhost wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 4
user1 localhost stage/sql/closing tables 12
user1 localhost stage/sql/init 3
user1 localhost stage/sql/Opening tables 8
user1 localhost stage/sql/starting 8
user2 localhost stage/sql/checking permissions 4
user2 localhost stage/sql/closing tables 11
user2 localhost stage/sql/init 3
user2 localhost stage/sql/Opening tables 7
user2 localhost stage/sql/starting 8
user3 localhost stage/sql/checking permissions 4
user3 localhost stage/sql/closing tables 11
user3 localhost stage/sql/init 3
user3 localhost stage/sql/Opening tables 7
user3 localhost stage/sql/starting 8
user4 localhost stage/sql/checking permissions 4
user4 localhost stage/sql/closing tables 11
user4 localhost stage/sql/init 3
user4 localhost stage/sql/Opening tables 7
user4 localhost stage/sql/starting 8
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
execute dump_stages_user;
user event_name count_star
user1 stage/sql/checking permissions 4
user1 stage/sql/closing tables 12
user1 stage/sql/init 3
user1 stage/sql/Opening tables 8
user1 stage/sql/starting 8
user2 stage/sql/checking permissions 4
user2 stage/sql/closing tables 11
user2 stage/sql/init 3
user2 stage/sql/Opening tables 7
user2 stage/sql/starting 8
user3 stage/sql/checking permissions 4
user3 stage/sql/closing tables 11
user3 stage/sql/init 3
user3 stage/sql/Opening tables 7
user3 stage/sql/starting 8
user4 stage/sql/checking permissions 4
user4 stage/sql/closing tables 11
user4 stage/sql/init 3
user4 stage/sql/Opening tables 7
user4 stage/sql/starting 8
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 0
execute dump_stages_host;
host event_name count_star
localhost stage/sql/checking permissions 16
localhost stage/sql/closing tables 45
localhost stage/sql/init 12
localhost stage/sql/Opening tables 29
localhost stage/sql/starting 32
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 0
execute dump_stages_global;
event_name count_star
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 1
user1 localhost statement/sp/freturn 1
user1 localhost statement/sql/insert 1
user1 localhost statement/sql/select 3
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 1
user2 localhost statement/sp/freturn 1
user2 localhost statement/sql/insert 1
user2 localhost statement/sql/select 3
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 1
user3 localhost statement/sp/freturn 1
user3 localhost statement/sql/insert 1
user3 localhost statement/sql/select 3
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 1
user4 localhost statement/sp/freturn 1
user4 localhost statement/sql/insert 1
user4 localhost statement/sql/select 3
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 1
user1 statement/sp/freturn 1
user1 statement/sql/insert 1
user1 statement/sql/select 3
user2 statement/com/Error 0
user2 statement/com/Quit 1
user2 statement/sp/freturn 1
user2 statement/sql/insert 1
user2 statement/sql/select 3
user3 statement/com/Error 0
user3 statement/com/Quit 1
user3 statement/sp/freturn 1
user3 statement/sql/insert 1
user3 statement/sql/select 3
user4 statement/com/Error 0
user4 statement/com/Quit 1
user4 statement/sp/freturn 1
user4 statement/sql/insert 1
user4 statement/sql/select 3
execute dump_statements_host;
host event_name count_star
localhost statement/com/Error 0
localhost statement/com/Quit 4
localhost statement/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 4
localhost statement/sql/insert 4
localhost statement/sql/select 12
execute dump_statements_global;
event_name count_star
statement/com/Error 0
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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_transactions_summary_by_thread_by_event_name;
"================== TRANSACTIONS_BY_THREAD 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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 3
user2 localhost transaction 3
user3 localhost transaction 3
user4 localhost transaction 3
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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_transactions_summary_by_account_by_event_name;
"================== TRANSACTIONS_BY_ACCOUNT 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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 0
user2 localhost transaction 0
user3 localhost transaction 0
user4 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 3
user2 transaction 3
user3 transaction 3
user4 transaction 3
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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_transactions_summary_by_user_by_event_name;
"================== TRANSACTIONS_BY_USER 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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 0
user2 localhost transaction 0
user3 localhost transaction 0
user4 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 0
user2 transaction 0
user3 transaction 0
user4 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 12
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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_transactions_summary_by_host_by_event_name;
"================== TRANSACTIONS_BY_HOST truncated =================="
"================== Step 32 =================="
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 0
user2 localhost transaction 0
user3 localhost transaction 0
user4 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 0
user2 transaction 0
user3 transaction 0
user4 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 12
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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_transactions_summary_global_by_event_name;
"================== TRANSACTIONS_GLOBAL truncated =================="
"================== Step 33 =================="
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
user1 localhost wait/io/file/sql/query_log 0
user1 localhost wait/synch/rwlock/sql/LOCK_grant 0
user2 localhost wait/io/file/sql/query_log 0
user2 localhost wait/synch/rwlock/sql/LOCK_grant 0
user3 localhost wait/io/file/sql/query_log 0
user3 localhost wait/synch/rwlock/sql/LOCK_grant 0
user4 localhost wait/io/file/sql/query_log 0
user4 localhost wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_user;
user event_name count_star
user1 wait/io/file/sql/query_log 0
user1 wait/synch/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
wait/synch/rwlock/sql/LOCK_grant 4
execute dump_stages_account;
user host event_name count_star
user1 localhost stage/sql/checking permissions 0
user1 localhost stage/sql/closing tables 0
user1 localhost stage/sql/init 0
user1 localhost stage/sql/Opening tables 0
user1 localhost stage/sql/starting 0
user2 localhost stage/sql/checking permissions 0
user2 localhost stage/sql/closing tables 0
user2 localhost stage/sql/init 0
user2 localhost stage/sql/Opening tables 0
user2 localhost stage/sql/starting 0
user3 localhost stage/sql/checking permissions 0
user3 localhost stage/sql/closing tables 0
user3 localhost stage/sql/init 0
user3 localhost stage/sql/Opening tables 0
user3 localhost stage/sql/starting 0
user4 localhost stage/sql/checking permissions 0
user4 localhost stage/sql/closing tables 0
user4 localhost stage/sql/init 0
user4 localhost stage/sql/Opening tables 0
user4 localhost stage/sql/starting 0
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
execute dump_statements_account;
user host event_name count_star
user1 localhost statement/com/Error 0
user1 localhost statement/com/Quit 0
user1 localhost statement/sp/freturn 0
user1 localhost statement/sql/insert 0
user1 localhost statement/sql/select 0
user2 localhost statement/com/Error 0
user2 localhost statement/com/Quit 0
user2 localhost statement/sp/freturn 0
user2 localhost statement/sql/insert 0
user2 localhost statement/sql/select 0
user3 localhost statement/com/Error 0
user3 localhost statement/com/Quit 0
user3 localhost statement/sp/freturn 0
user3 localhost statement/sql/insert 0
user3 localhost statement/sql/select 0
user4 localhost statement/com/Error 0
user4 localhost statement/com/Quit 0
user4 localhost statement/sp/freturn 0
user4 localhost statement/sql/insert 0
user4 localhost statement/sql/select 0
execute dump_statements_user;
user event_name count_star
user1 statement/com/Error 0
user1 statement/com/Quit 0
user1 statement/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
user1 localhost transaction 0
user2 localhost transaction 0
user3 localhost transaction 0
user4 localhost transaction 0
execute dump_transactions_user;
user event_name count_star
user1 transaction 0
user2 transaction 0
user3 transaction 0
user4 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
user1 localhost 0 1
user2 localhost 0 1
user3 localhost 0 1
user4 localhost 0 1
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 34 =================="
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/rwlock/sql/LOCK_grant 0
user2 wait/io/file/sql/query_log 0
user2 wait/synch/rwlock/sql/LOCK_grant 0
user3 wait/io/file/sql/query_log 0
user3 wait/synch/rwlock/sql/LOCK_grant 0
user4 wait/io/file/sql/query_log 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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
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/Opening tables 0
user1 stage/sql/starting 0
user2 stage/sql/checking permissions 0
user2 stage/sql/closing tables 0
user2 stage/sql/init 0
user2 stage/sql/Opening tables 0
user2 stage/sql/starting 0
user3 stage/sql/checking permissions 0
user3 stage/sql/closing tables 0
user3 stage/sql/init 0
user3 stage/sql/Opening tables 0
user3 stage/sql/starting 0
user4 stage/sql/checking permissions 0
user4 stage/sql/closing tables 0
user4 stage/sql/init 0
user4 stage/sql/Opening tables 0
user4 stage/sql/starting 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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
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/sp/freturn 0
user1 statement/sql/insert 0
user1 statement/sql/select 0
user2 statement/com/Error 0
user2 statement/com/Quit 0
user2 statement/sp/freturn 0
user2 statement/sql/insert 0
user2 statement/sql/select 0
user3 statement/com/Error 0
user3 statement/com/Quit 0
user3 statement/sp/freturn 0
user3 statement/sql/insert 0
user3 statement/sql/select 0
user4 statement/com/Error 0
user4 statement/com/Quit 0
user4 statement/sp/freturn 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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
execute dump_transactions_user;
user event_name count_star
user1 transaction 0
user2 transaction 0
user3 transaction 0
user4 transaction 0
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
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 35 =================="
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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
execute dump_transactions_user;
user event_name count_star
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
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 36 =================="
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/rwlock/sql/LOCK_grant 0
execute dump_waits_global;
event_name count_star
wait/io/file/sql/query_log 0
wait/synch/rwlock/sql/LOCK_grant 0
execute dump_waits_history;
event_name count(event_name)
wait/io/file/sql/query_log 32
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/Opening tables 0
localhost stage/sql/starting 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/Opening tables 0
stage/sql/starting 0
execute dump_stages_history;
event_name count(event_name)
stage/sql/checking permissions 16
stage/sql/closing tables 45
stage/sql/init 12
stage/sql/Opening tables 29
stage/sql/starting 32
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/sp/freturn 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/sp/freturn 0
statement/sql/insert 0
statement/sql/select 0
execute dump_statements_history;
event_name count(event_name)
statement/com/Quit 4
statement/sp/freturn 4
statement/sql/insert 4
statement/sql/select 12
execute dump_transactions_account;
user host event_name count_star
execute dump_transactions_user;
user event_name count_star
execute dump_transactions_host;
host event_name count_star
localhost transaction 0
execute dump_transactions_global;
event_name count_star
transaction 0
execute dump_transactions_history;
event_name count(event_name)
transaction 12
execute dump_accounts;
USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root localhost 1 1
execute dump_users;
USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS
root 1 1
execute dump_hosts;
HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS
localhost 1 1