diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result | 3537 |
1 files changed, 3537 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result b/mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result new file mode 100644 index 00000000000..6de38e218ab --- /dev/null +++ b/mysql-test/suite/perfschema/r/event_aggregate_no_u_no_h.result @@ -0,0 +1,3537 @@ +"================== 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 +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +execute dump_stages_account; +user host event_name count_star +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +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 +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con1 connected ==================" +"================== Step 2 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 1 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 1 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 1 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 1 +execute dump_stages_account; +user host event_name count_star +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +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/sql/insert 0 +user1 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +select get_lock("marker", 10); +get_lock("marker", 10) +1 +select release_lock("marker"); +release_lock("marker") +1 +insert into test.t1 values ("marker"); +"================== con1 marker ==================" +"================== Step 3 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +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 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 4 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 2 +wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 4 +wait/synch/mutex/sql/LOCK_user_locks 2 +wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 3 +stage/sql/closing tables 3 +stage/sql/init 6 +stage/sql/Opening tables 3 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 3 +stage/sql/closing tables 3 +stage/sql/init 6 +stage/sql/Opening tables 3 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 1 +statement/sql/select 2 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 1 +statement/sql/select 2 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con2 connected ==================" +"================== Step 4 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 1 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 1 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 5 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 2 +wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 5 +wait/synch/mutex/sql/LOCK_user_locks 2 +wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 3 +stage/sql/closing tables 3 +stage/sql/init 6 +stage/sql/Opening tables 3 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 3 +stage/sql/closing tables 3 +stage/sql/init 6 +stage/sql/Opening tables 3 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 1 +statement/sql/select 2 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 1 +statement/sql/select 2 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +select get_lock("marker", 10); +get_lock("marker", 10) +1 +select release_lock("marker"); +release_lock("marker") +1 +insert into test.t1 values ("marker"); +"================== con2 marker ==================" +"================== Step 5 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +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 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 8 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 4 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 8 +wait/synch/mutex/sql/LOCK_user_locks 4 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 6 +stage/sql/closing tables 6 +stage/sql/init 12 +stage/sql/Opening tables 6 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 6 +stage/sql/closing tables 6 +stage/sql/init 12 +stage/sql/Opening tables 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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 2 +statement/sql/select 4 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 2 +statement/sql/select 4 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con3 connected ==================" +"================== Step 6 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user3 wait/io/file/sql/query_log 1 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 1 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 9 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 4 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 9 +wait/synch/mutex/sql/LOCK_user_locks 4 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 6 +stage/sql/closing tables 6 +stage/sql/init 12 +stage/sql/Opening tables 6 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 6 +stage/sql/closing tables 6 +stage/sql/init 12 +stage/sql/Opening tables 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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 2 +statement/sql/select 4 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 2 +statement/sql/select 4 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +select get_lock("marker", 10); +get_lock("marker", 10) +1 +select release_lock("marker"); +release_lock("marker") +1 +insert into test.t1 values ("marker"); +"================== con3 marker ==================" +"================== Step 7 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user3 wait/io/file/sql/query_log 4 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 2 +user3 wait/synch/rwlock/sql/LOCK_grant 2 +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 4 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 12 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 6 +wait/synch/rwlock/sql/LOCK_grant 6 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 12 +wait/synch/mutex/sql/LOCK_user_locks 6 +wait/synch/rwlock/sql/LOCK_grant 6 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 6 +user3 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 9 +stage/sql/closing tables 9 +stage/sql/init 18 +stage/sql/Opening tables 9 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 9 +stage/sql/closing tables 9 +stage/sql/init 18 +stage/sql/Opening tables 9 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 3 +statement/sql/select 6 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 3 +statement/sql/select 6 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con4 connected ==================" +"================== Step 8 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user3 wait/io/file/sql/query_log 4 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 2 +user3 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user4 wait/io/file/sql/query_log 1 +user4 wait/synch/mutex/sql/LOCK_connection_count 0 +user4 wait/synch/mutex/sql/LOCK_user_locks 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 4 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 1 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 13 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 6 +wait/synch/rwlock/sql/LOCK_grant 6 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 13 +wait/synch/mutex/sql/LOCK_user_locks 6 +wait/synch/rwlock/sql/LOCK_grant 6 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 6 +user3 localhost stage/sql/Opening tables 3 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 9 +stage/sql/closing tables 9 +stage/sql/init 18 +stage/sql/Opening tables 9 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 9 +stage/sql/closing tables 9 +stage/sql/init 18 +stage/sql/Opening tables 9 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 3 +statement/sql/select 6 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 3 +statement/sql/select 6 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +select get_lock("marker", 10); +get_lock("marker", 10) +1 +select release_lock("marker"); +release_lock("marker") +1 +insert into test.t1 values ("marker"); +"================== con4 marker ==================" +"================== Step 9 ==================" +call dump_thread(); +username event_name count_star +user1 wait/io/file/sql/query_log 4 +user1 wait/synch/mutex/sql/LOCK_connection_count 0 +user1 wait/synch/mutex/sql/LOCK_user_locks 2 +user1 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user3 wait/io/file/sql/query_log 4 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 2 +user3 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user4 wait/io/file/sql/query_log 4 +user4 wait/synch/mutex/sql/LOCK_connection_count 0 +user4 wait/synch/mutex/sql/LOCK_user_locks 2 +user4 wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 4 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 4 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 4 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 16 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 16 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 6 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 6 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 6 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 24 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 24 +stage/sql/Opening tables 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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con1 disconnected ==================" +"================== Step 10 ==================" +call dump_thread(); +username status +user1 not found +username event_name count_star +user2 wait/io/file/sql/query_log 4 +user2 wait/synch/mutex/sql/LOCK_connection_count 0 +user2 wait/synch/mutex/sql/LOCK_user_locks 2 +user2 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user3 wait/io/file/sql/query_log 4 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 2 +user3 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user4 wait/io/file/sql/query_log 4 +user4 wait/synch/mutex/sql/LOCK_connection_count 0 +user4 wait/synch/mutex/sql/LOCK_user_locks 2 +user4 wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 5 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 4 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 4 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 4 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 17 +wait/synch/mutex/sql/LOCK_connection_count 1 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 17 +wait/synch/mutex/sql/LOCK_connection_count 1 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 6 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 6 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 6 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 25 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 25 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 1 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 1 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con2 disconnected ==================" +"================== Step 11 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username event_name count_star +user3 wait/io/file/sql/query_log 4 +user3 wait/synch/mutex/sql/LOCK_connection_count 0 +user3 wait/synch/mutex/sql/LOCK_user_locks 2 +user3 wait/synch/rwlock/sql/LOCK_grant 2 +username event_name count_star +user4 wait/io/file/sql/query_log 4 +user4 wait/synch/mutex/sql/LOCK_connection_count 0 +user4 wait/synch/mutex/sql/LOCK_user_locks 2 +user4 wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 5 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 5 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 4 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 4 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 18 +wait/synch/mutex/sql/LOCK_connection_count 2 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 18 +wait/synch/mutex/sql/LOCK_connection_count 2 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 6 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 6 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 26 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 26 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 2 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 2 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con3 disconnected ==================" +"================== Step 12 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username event_name count_star +user4 wait/io/file/sql/query_log 4 +user4 wait/synch/mutex/sql/LOCK_connection_count 0 +user4 wait/synch/mutex/sql/LOCK_user_locks 2 +user4 wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 5 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 5 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 5 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 4 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 19 +wait/synch/mutex/sql/LOCK_connection_count 3 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 19 +wait/synch/mutex/sql/LOCK_connection_count 3 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 6 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 27 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 27 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 3 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 3 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +"================== con4 disconnected ==================" +"================== 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 5 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 5 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 5 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 5 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 5 +user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user2 localhost wait/io/file/sql/query_log 5 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user3 localhost wait/io/file/sql/query_log 5 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 2 +user4 localhost wait/io/file/sql/query_log 5 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 1 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 2 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 2 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 3 +user1 localhost stage/sql/closing tables 3 +user1 localhost stage/sql/init 7 +user1 localhost stage/sql/Opening tables 3 +user2 localhost stage/sql/checking permissions 3 +user2 localhost stage/sql/closing tables 3 +user2 localhost stage/sql/init 7 +user2 localhost stage/sql/Opening tables 3 +user3 localhost stage/sql/checking permissions 3 +user3 localhost stage/sql/closing tables 3 +user3 localhost stage/sql/init 7 +user3 localhost stage/sql/Opening tables 3 +user4 localhost stage/sql/checking permissions 3 +user4 localhost stage/sql/closing tables 3 +user4 localhost stage/sql/init 7 +user4 localhost stage/sql/Opening tables 3 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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/sql/insert 1 +user1 localhost statement/sql/select 2 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 1 +user2 localhost statement/sql/insert 1 +user2 localhost statement/sql/select 2 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 1 +user3 localhost statement/sql/insert 1 +user3 localhost statement/sql/select 2 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 1 +user4 localhost statement/sql/insert 1 +user4 localhost statement/sql/select 2 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 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/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 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/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 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/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 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/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 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/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 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/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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/mutex/sql/LOCK_connection_count 0 +user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 +user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +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 +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 +execute dump_stages_user; +user event_name count_star +execute dump_stages_host; +host event_name count_star +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 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/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 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/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +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 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.accounts; +"================== ACCOUNTS truncated ==================" +"================== Step 29 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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 +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.users; +"================== USERS truncated ==================" +"================== Step 30 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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 +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.hosts; +"================== HOSTS truncated ==================" +"================== Step 31 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +execute dump_waits_user; +user event_name count_star +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/mutex/sql/LOCK_connection_count 0 +wait/synch/mutex/sql/LOCK_user_locks 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 20 +wait/synch/mutex/sql/LOCK_connection_count 4 +wait/synch/mutex/sql/LOCK_user_locks 8 +wait/synch/rwlock/sql/LOCK_grant 8 +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 +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 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 12 +stage/sql/closing tables 12 +stage/sql/init 28 +stage/sql/Opening tables 12 +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 +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sql/insert 4 +statement/sql/select 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS |