Edit File: event_aggregate_no_h.result
"================== 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 root 1 1 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 user1 wait/io/file/sql/query_log 1 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 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 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 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 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 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 user2 wait/io/file/sql/query_log 1 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 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 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 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 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 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 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 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 user3 wait/io/file/sql/query_log 1 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 user3 1 1 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 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 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 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 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 6 user3 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 1 user3 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 user3 1 1 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 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 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 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 user4 wait/io/file/sql/query_log 1 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 6 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 user3 1 1 user4 1 1 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 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 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 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 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_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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 6 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 6 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 6 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 1 1 user2 1 1 user3 1 1 user4 1 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 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 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 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_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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 6 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 6 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 6 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 1 1 user3 1 1 user4 1 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 2 user2 wait/synch/rwlock/sql/LOCK_grant 2 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 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_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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 6 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 6 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 1 1 user4 1 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 2 user2 wait/synch/rwlock/sql/LOCK_grant 2 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 2 user3 wait/synch/rwlock/sql/LOCK_grant 2 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_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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 6 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 1 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 2 user2 wait/synch/rwlock/sql/LOCK_grant 2 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 2 user3 wait/synch/rwlock/sql/LOCK_grant 2 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 2 user4 wait/synch/rwlock/sql/LOCK_grant 2 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 2 user2 wait/synch/rwlock/sql/LOCK_grant 2 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 2 user3 wait/synch/rwlock/sql/LOCK_grant 2 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 2 user4 wait/synch/rwlock/sql/LOCK_grant 2 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 2 user1 wait/synch/rwlock/sql/LOCK_grant 2 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 2 user2 wait/synch/rwlock/sql/LOCK_grant 2 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 2 user3 wait/synch/rwlock/sql/LOCK_grant 2 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 2 user4 wait/synch/rwlock/sql/LOCK_grant 2 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 3 user1 stage/sql/closing tables 3 user1 stage/sql/init 7 user1 stage/sql/Opening tables 3 user2 stage/sql/checking permissions 3 user2 stage/sql/closing tables 3 user2 stage/sql/init 7 user2 stage/sql/Opening tables 3 user3 stage/sql/checking permissions 3 user3 stage/sql/closing tables 3 user3 stage/sql/init 7 user3 stage/sql/Opening tables 3 user4 stage/sql/checking permissions 3 user4 stage/sql/closing tables 3 user4 stage/sql/init 7 user4 stage/sql/Opening tables 3 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 1 user1 statement/sql/insert 1 user1 statement/sql/select 2 user2 statement/com/Error 0 user2 statement/com/Quit 1 user2 statement/sql/insert 1 user2 statement/sql/select 2 user3 statement/com/Error 0 user3 statement/com/Quit 1 user3 statement/sql/insert 1 user3 statement/sql/select 2 user4 statement/com/Error 0 user4 statement/com/Quit 1 user4 statement/sql/insert 1 user4 statement/sql/select 2 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 user1 wait/io/file/sql/query_log 0 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 user2 wait/io/file/sql/query_log 0 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 user3 wait/io/file/sql/query_log 0 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 user4 wait/io/file/sql/query_log 0 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star 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 user1 stage/sql/checking permissions 0 user1 stage/sql/closing tables 0 user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 user2 stage/sql/checking permissions 0 user2 stage/sql/closing tables 0 user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 user3 stage/sql/checking permissions 0 user3 stage/sql/closing tables 0 user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 user4 stage/sql/checking permissions 0 user4 stage/sql/closing tables 0 user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 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 user1 statement/com/Error 0 user1 statement/com/Quit 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; host event_name count_star 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 root 1 1 user1 0 1 user2 0 1 user3 0 1 user4 0 1 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 root 1 1 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 root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS