diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/event_aggregate.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/event_aggregate.result | 6911 |
1 files changed, 6911 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/event_aggregate.result b/mysql-test/suite/perfschema/r/event_aggregate.result new file mode 100644 index 00000000..805378f5 --- /dev/null +++ b/mysql-test/suite/perfschema/r/event_aggregate.result @@ -0,0 +1,6911 @@ +"================== 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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 4 +localhost stage/sql/closing tables 11 +localhost stage/sql/init 3 +localhost stage/sql/Opening tables 7 +localhost stage/sql/starting 6 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 +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 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 2 +execute dump_transactions_global; +event_name count_star +transaction 2 +execute dump_transactions_history; +event_name count(event_name) +transaction 2 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +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 11 +localhost stage/sql/init 3 +localhost stage/sql/Opening tables 7 +localhost stage/sql/starting 6 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 +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 2 +user2 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 0 +execute dump_transactions_host; +host event_name count_star +localhost transaction 2 +execute dump_transactions_global; +event_name count_star +transaction 2 +execute dump_transactions_history; +event_name count(event_name) +transaction 2 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 8 +localhost stage/sql/closing tables 21 +localhost stage/sql/init 6 +localhost stage/sql/Opening tables 13 +localhost stage/sql/starting 12 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 +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 2 +user2 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 4 +execute dump_transactions_global; +event_name count_star +transaction 4 +execute dump_transactions_history; +event_name count(event_name) +transaction 4 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +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 21 +localhost stage/sql/init 6 +localhost stage/sql/Opening tables 13 +localhost stage/sql/starting 12 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 0 +execute dump_transactions_host; +host event_name count_star +localhost transaction 4 +execute dump_transactions_global; +event_name count_star +transaction 4 +execute dump_transactions_history; +event_name count(event_name) +transaction 4 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 12 +localhost stage/sql/closing tables 31 +localhost stage/sql/init 9 +localhost stage/sql/Opening tables 19 +localhost stage/sql/starting 18 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +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 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +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 31 +localhost stage/sql/init 9 +localhost stage/sql/Opening tables 19 +localhost stage/sql/starting 18 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 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 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 16 +localhost stage/sql/closing tables 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 24 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 24 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 24 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 16 +localhost stage/sql/closing tables 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 25 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 25 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 25 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 16 +localhost stage/sql/closing tables 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 26 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 26 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 26 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 +execute dump_stages_host; +host event_name count_star +localhost stage/sql/checking permissions 16 +localhost stage/sql/closing tables 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 27 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 27 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 27 +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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +localhost stage/sql/init 12 +localhost stage/sql/Opening tables 25 +localhost stage/sql/starting 28 +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +localhost transaction 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 8 +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +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 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 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +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 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +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 8 +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 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +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 8 +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 |