EVOLUTION-MANAGER

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/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) execute dump_statements_account; user host event_name count_star execute dump_statements_user; user event_name count_star execute dump_statements_host; host event_name count_star 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 connect con1, localhost, user1, , ; connection default; "================== Step 2 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 1 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 0 username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star 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/Init for update 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/Init for update 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/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) execute dump_statements_account; user host event_name count_star 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 connection con1; select get_lock("marker", 10); get_lock("marker", 10) 1 select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); connection default; "================== Step 3 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 4 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 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 4 stage/sql/Init 5 stage/sql/Init for update 1 stage/sql/Opening tables 3 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 3 stage/sql/Closing tables 4 stage/sql/Init 5 stage/sql/Init for update 1 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 connect con2, localhost, user2, , ; connection default; "================== Step 4 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 1 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 1 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 5 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 5 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 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/Init for update 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 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/Init for update 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 4 stage/sql/Init 5 stage/sql/Init for update 1 stage/sql/Opening tables 3 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 3 stage/sql/Closing tables 4 stage/sql/Init 5 stage/sql/Init for update 1 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 connection con2; select get_lock("marker", 10); get_lock("marker", 10) 1 select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 8 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 8 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 6 stage/sql/Closing tables 8 stage/sql/Init 10 stage/sql/Init for update 2 stage/sql/Opening tables 6 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 6 stage/sql/Closing tables 8 stage/sql/Init 10 stage/sql/Init for update 2 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 connect con3, localhost, user3, , ; connection default; "================== Step 6 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 1 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 username status user4 not found execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 1 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 9 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 9 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 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/Init for update 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 6 stage/sql/Closing tables 8 stage/sql/Init 10 stage/sql/Init for update 2 stage/sql/Opening tables 6 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 6 stage/sql/Closing tables 8 stage/sql/Init 10 stage/sql/Init for update 2 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 connection con3; select get_lock("marker", 10); get_lock("marker", 10) 1 select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 username status user4 not found execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 12 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 12 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 5 user3 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 5 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 9 stage/sql/Closing tables 12 stage/sql/Init 15 stage/sql/Init for update 3 stage/sql/Opening tables 9 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 9 stage/sql/Closing tables 12 stage/sql/Init 15 stage/sql/Init for update 3 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 connect con4, localhost, user4, , ; connection default; "================== Step 8 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user4 wait/io/file/sql/query_log 1 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 1 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 0 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 13 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 13 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 5 user3 localhost stage/sql/Init for update 1 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/Init for update 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 5 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 9 stage/sql/Closing tables 12 stage/sql/Init 15 stage/sql/Init for update 3 stage/sql/Opening tables 9 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 9 stage/sql/Closing tables 12 stage/sql/Init 15 stage/sql/Init for update 3 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 connection con4; select get_lock("marker", 10); get_lock("marker", 10) 1 select release_lock("marker"); release_lock("marker") 1 insert into test.t1 values ("marker"); connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 4 user1 wait/synch/mutex/sql/LOCK_connection_count 0 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 16 wait/synch/mutex/sql/LOCK_connection_count 0 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 16 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 5 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 5 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 5 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 5 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 5 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 5 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 20 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 20 stage/sql/Init for update 4 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 disconnect con1; connection default; "================== Step 10 ==================" call dump_thread(); username status user1 not found username event_name count_star user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 4 user2 wait/synch/mutex/sql/LOCK_connection_count 0 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 17 wait/synch/mutex/sql/LOCK_connection_count 1 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 17 wait/synch/mutex/sql/LOCK_connection_count 1 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 5 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 5 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 5 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 5 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 5 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 5 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 21 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 21 stage/sql/Init for update 4 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 disconnect con2; connection default; "================== Step 11 ==================" call dump_thread(); username status user1 not found username status user2 not found username event_name count_star user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 4 user3 wait/synch/mutex/sql/LOCK_connection_count 0 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 18 wait/synch/mutex/sql/LOCK_connection_count 2 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 18 wait/synch/mutex/sql/LOCK_connection_count 2 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 5 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 5 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 5 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 5 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 22 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 22 stage/sql/Init for update 4 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 disconnect con3; connection default; "================== Step 12 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username event_name count_star user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star 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 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 4 user4 wait/synch/mutex/sql/LOCK_connection_count 0 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 19 wait/synch/mutex/sql/LOCK_connection_count 3 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 19 wait/synch/mutex/sql/LOCK_connection_count 3 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 5 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 5 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 23 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 23 stage/sql/Init for update 4 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 disconnect con4; connection default; "================== Step 13 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/file/sql/query_log 5 user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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 connection default; truncate performance_schema.events_waits_summary_by_thread_by_event_name; "================== WAITS_BY_THREAD truncated ==================" "================== Step 14 ==================" call dump_thread(); username status user1 not found username status user2 not found username status user3 not found username status user4 not found execute dump_waits_account; user host event_name count_star user1 localhost wait/io/file/sql/query_log 5 user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 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 0 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star user1 wait/io/file/sql/query_log 5 user1 wait/synch/mutex/sql/LOCK_connection_count 1 user1 wait/synch/mutex/sql/LOCK_user_locks 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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 0 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 5 user2 wait/synch/mutex/sql/LOCK_connection_count 1 user2 wait/synch/mutex/sql/LOCK_user_locks 0 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 5 user3 wait/synch/mutex/sql/LOCK_connection_count 1 user3 wait/synch/mutex/sql/LOCK_user_locks 0 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 5 user4 wait/synch/mutex/sql/LOCK_connection_count 1 user4 wait/synch/mutex/sql/LOCK_user_locks 0 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star execute dump_waits_global; event_name count_star wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/mutex/sql/LOCK_user_locks 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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 0 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) wait/io/file/sql/query_log 20 wait/synch/mutex/sql/LOCK_connection_count 4 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 3 user1 localhost stage/sql/Closing tables 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/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 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/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 4 user1 localhost stage/sql/Init 6 user1 localhost stage/sql/Init for update 1 user1 localhost stage/sql/Opening tables 3 user2 localhost stage/sql/Checking permissions 3 user2 localhost stage/sql/Closing tables 4 user2 localhost stage/sql/Init 6 user2 localhost stage/sql/Init for update 1 user2 localhost stage/sql/Opening tables 3 user3 localhost stage/sql/Checking permissions 3 user3 localhost stage/sql/Closing tables 4 user3 localhost stage/sql/Init 6 user3 localhost stage/sql/Init for update 1 user3 localhost stage/sql/Opening tables 3 user4 localhost stage/sql/Checking permissions 3 user4 localhost stage/sql/Closing tables 4 user4 localhost stage/sql/Init 6 user4 localhost stage/sql/Init for update 1 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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 4 user1 stage/sql/Init 6 user1 stage/sql/Init for update 1 user1 stage/sql/Opening tables 3 user2 stage/sql/Checking permissions 3 user2 stage/sql/Closing tables 4 user2 stage/sql/Init 6 user2 stage/sql/Init for update 1 user2 stage/sql/Opening tables 3 user3 stage/sql/Checking permissions 3 user3 stage/sql/Closing tables 4 user3 stage/sql/Init 6 user3 stage/sql/Init for update 1 user3 stage/sql/Opening tables 3 user4 stage/sql/Checking permissions 3 user4 stage/sql/Closing tables 4 user4 stage/sql/Init 6 user4 stage/sql/Init for update 1 user4 stage/sql/Opening tables 3 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 stage/sql/Opening tables 12 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star user1 localhost stage/sql/Checking permissions 0 user1 localhost stage/sql/Closing tables 0 user1 localhost stage/sql/Init 0 user1 localhost stage/sql/Init for update 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/Init for update 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/Init for update 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/Init for update 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/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star execute dump_stages_user; user event_name count_star user1 stage/sql/Checking permissions 0 user1 stage/sql/Closing tables 0 user1 stage/sql/Init 0 user1 stage/sql/Init for update 0 user1 stage/sql/Opening tables 0 user2 stage/sql/Checking permissions 0 user2 stage/sql/Closing tables 0 user2 stage/sql/Init 0 user2 stage/sql/Init for update 0 user2 stage/sql/Opening tables 0 user3 stage/sql/Checking permissions 0 user3 stage/sql/Closing tables 0 user3 stage/sql/Init 0 user3 stage/sql/Init for update 0 user3 stage/sql/Opening tables 0 user4 stage/sql/Checking permissions 0 user4 stage/sql/Closing tables 0 user4 stage/sql/Init 0 user4 stage/sql/Init for update 0 user4 stage/sql/Opening tables 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star execute dump_stages_user; user event_name count_star execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star execute dump_stages_user; user event_name count_star execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star stage/sql/Checking permissions 0 stage/sql/Closing tables 0 stage/sql/Init 0 stage/sql/Init for update 0 stage/sql/Opening tables 0 execute dump_stages_history; event_name count(event_name) stage/sql/Checking permissions 12 stage/sql/Closing tables 16 stage/sql/Init 24 stage/sql/Init for update 4 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