diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/event_aggregate_no_h.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/event_aggregate_no_h.result | 5475 |
1 files changed, 3387 insertions, 2088 deletions
diff --git a/mysql-test/suite/perfschema/r/event_aggregate_no_h.result b/mysql-test/suite/perfschema/r/event_aggregate_no_h.result index c8996fa2846..2f0c96d7234 100644 --- a/mysql-test/suite/perfschema/r/event_aggregate_no_h.result +++ b/mysql-test/suite/perfschema/r/event_aggregate_no_h.result @@ -17,8 +17,6 @@ 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) @@ -30,11 +28,11 @@ 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) execute dump_statements_account; @@ -47,10 +45,22 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) +execute dump_transactions_account; +user host event_name count_star +execute dump_transactions_user; +user event_name count_star +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -65,8 +75,6 @@ connection default; 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 @@ -77,61 +85,57 @@ 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/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 user1 localhost statement/sql/insert 0 user1 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 execute dump_statements_host; @@ -140,10 +144,24 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -155,20 +173,23 @@ user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS connection con1; -select get_lock("marker", 10); -get_lock("marker", 10) +select uuid_short() <> 1; +uuid_short() <> 1 1 -select release_lock("marker"); -release_lock("marker") +select uuid_short() <> 1; +uuid_short() <> 1 1 +start transaction; insert into test.t1 values ("marker"); +commit; +select test.f(10,20); +test.f(10,20) +30 connection default; "================== Step 3 ==================" call dump_thread(); username event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username status user2 not found @@ -178,82 +199,94 @@ 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/io/file/sql/query_log 7 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_host; host event_name count_star 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/io/file/sql/query_log 7 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 4 +wait/io/file/sql/query_log 7 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 3 -stage/sql/Closing tables 6 -stage/sql/Init 5 -stage/sql/Init for update 1 -stage/sql/Opening tables 4 +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 3 -stage/sql/Closing tables 6 -stage/sql/Init 5 -stage/sql/Init for update 1 -stage/sql/Opening tables 4 +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 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/sp/freturn 1 statement/sql/insert 1 -statement/sql/select 2 +statement/sql/select 3 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 1 statement/sql/insert 1 -statement/sql/select 2 +statement/sql/select 3 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 2 +execute dump_transactions_history; +event_name count(event_name) +transaction 2 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -269,14 +302,10 @@ 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/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user2 wait/io/file/sql/query_log 1 -user2 wait/synch/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 @@ -284,94 +313,88 @@ 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/io/file/sql/query_log 7 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 user2 localhost wait/io/file/sql/query_log 1 -user2 localhost wait/synch/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/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 user2 wait/io/file/sql/query_log 1 -user2 wait/synch/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/io/file/sql/query_log 8 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 5 +wait/io/file/sql/query_log 8 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 3 -stage/sql/Closing tables 6 -stage/sql/Init 5 -stage/sql/Init for update 1 -stage/sql/Opening tables 4 +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 3 -stage/sql/Closing tables 6 -stage/sql/Init 5 -stage/sql/Init for update 1 -stage/sql/Opening tables 4 +stage/sql/checking permissions 4 +stage/sql/closing tables 11 +stage/sql/init 3 +stage/sql/Opening tables 7 +stage/sql/starting 6 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 user2 localhost statement/sql/insert 0 user2 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 execute dump_statements_host; @@ -380,12 +403,30 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 1 statement/sql/insert 1 -statement/sql/select 2 +statement/sql/select 3 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 1 statement/sql/insert 1 -statement/sql/select 2 +statement/sql/select 3 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 2 +execute dump_transactions_history; +event_name count(event_name) +transaction 2 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -399,25 +440,26 @@ user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS connection con2; -select get_lock("marker", 10); -get_lock("marker", 10) +select uuid_short() <> 1; +uuid_short() <> 1 1 -select release_lock("marker"); -release_lock("marker") +select uuid_short() <> 1; +uuid_short() <> 1 1 +start transaction; insert into test.t1 values ("marker"); +commit; +select test.f(10,20); +test.f(10,20) +30 connection default; "================== Step 5 ==================" call dump_thread(); username event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user2 wait/io/file/sql/query_log 4 -user2 wait/synch/mutex/sql/LOCK_connection_count 0 -user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username status user3 not found @@ -425,108 +467,120 @@ 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 14 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 8 +wait/io/file/sql/query_log 14 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 6 -stage/sql/Closing tables 10 -stage/sql/Init 10 -stage/sql/Init for update 2 -stage/sql/Opening tables 7 +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 6 -stage/sql/Closing tables 10 -stage/sql/Init 10 -stage/sql/Init for update 2 -stage/sql/Opening tables 7 +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 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/sp/freturn 2 statement/sql/insert 2 -statement/sql/select 4 +statement/sql/select 6 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 2 statement/sql/insert 2 -statement/sql/select 4 +statement/sql/select 6 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 4 +execute dump_transactions_history; +event_name count(event_name) +transaction 4 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -544,138 +598,124 @@ 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/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user2 wait/io/file/sql/query_log 4 -user2 wait/synch/mutex/sql/LOCK_connection_count 0 -user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user3 wait/io/file/sql/query_log 1 -user3 wait/synch/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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 user3 localhost wait/io/file/sql/query_log 1 -user3 localhost wait/synch/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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 user3 wait/io/file/sql/query_log 1 -user3 wait/synch/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/io/file/sql/query_log 15 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 9 +wait/io/file/sql/query_log 15 wait/synch/rwlock/sql/LOCK_grant 2 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 6 -stage/sql/Closing tables 10 -stage/sql/Init 10 -stage/sql/Init for update 2 -stage/sql/Opening tables 7 +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 6 -stage/sql/Closing tables 10 -stage/sql/Init 10 -stage/sql/Init for update 2 -stage/sql/Opening tables 7 +stage/sql/checking permissions 8 +stage/sql/closing tables 21 +stage/sql/init 6 +stage/sql/Opening tables 13 +stage/sql/starting 12 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 user3 localhost statement/sql/insert 0 user3 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 execute dump_statements_host; @@ -684,12 +724,32 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 2 statement/sql/insert 2 -statement/sql/select 4 +statement/sql/select 6 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 2 statement/sql/insert 2 -statement/sql/select 4 +statement/sql/select 6 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 4 +execute dump_transactions_history; +event_name count(event_name) +transaction 4 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -705,163 +765,174 @@ user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS connection con3; -select get_lock("marker", 10); -get_lock("marker", 10) +select uuid_short() <> 1; +uuid_short() <> 1 1 -select release_lock("marker"); -release_lock("marker") +select uuid_short() <> 1; +uuid_short() <> 1 1 +start transaction; insert into test.t1 values ("marker"); +commit; +select test.f(10,20); +test.f(10,20) +30 connection default; "================== Step 7 ==================" call dump_thread(); username event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user2 wait/io/file/sql/query_log 4 -user2 wait/synch/mutex/sql/LOCK_connection_count 0 -user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user3 wait/io/file/sql/query_log 4 -user3 wait/synch/mutex/sql/LOCK_connection_count 0 -user3 wait/synch/mutex/sql/LOCK_user_locks 0 +user3 wait/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 username status user4 not found execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/file/sql/query_log 4 -user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/io/file/sql/query_log 7 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user2 localhost wait/io/file/sql/query_log 4 -user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/io/file/sql/query_log 7 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user3 localhost wait/io/file/sql/query_log 4 -user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/io/file/sql/query_log 7 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 21 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 12 +wait/io/file/sql/query_log 21 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 9 -stage/sql/Closing tables 14 -stage/sql/Init 15 -stage/sql/Init for update 3 -stage/sql/Opening tables 10 +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 9 -stage/sql/Closing tables 14 -stage/sql/Init 15 -stage/sql/Init for update 3 -stage/sql/Opening tables 10 +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 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/sp/freturn 3 statement/sql/insert 3 -statement/sql/select 6 +statement/sql/select 9 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 3 statement/sql/insert 3 -statement/sql/select 6 +statement/sql/select 9 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 6 +execute dump_transactions_history; +event_name count(event_name) +transaction 6 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -881,167 +952,149 @@ 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/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user2 wait/io/file/sql/query_log 4 -user2 wait/synch/mutex/sql/LOCK_connection_count 0 -user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user3 wait/io/file/sql/query_log 4 -user3 wait/synch/mutex/sql/LOCK_connection_count 0 -user3 wait/synch/mutex/sql/LOCK_user_locks 0 +user3 wait/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star user4 wait/io/file/sql/query_log 1 -user4 wait/synch/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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 user4 localhost wait/io/file/sql/query_log 1 -user4 localhost wait/synch/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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 user4 wait/io/file/sql/query_log 1 -user4 wait/synch/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/io/file/sql/query_log 22 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 13 +wait/io/file/sql/query_log 22 wait/synch/rwlock/sql/LOCK_grant 3 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 9 -stage/sql/Closing tables 14 -stage/sql/Init 15 -stage/sql/Init for update 3 -stage/sql/Opening tables 10 +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 9 -stage/sql/Closing tables 14 -stage/sql/Init 15 -stage/sql/Init for update 3 -stage/sql/Opening tables 10 +stage/sql/checking permissions 12 +stage/sql/closing tables 31 +stage/sql/init 9 +stage/sql/Opening tables 19 +stage/sql/starting 18 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 user4 localhost statement/sql/insert 0 user4 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; @@ -1050,12 +1103,34 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 3 statement/sql/insert 3 -statement/sql/select 6 +statement/sql/select 9 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 3 statement/sql/insert 3 -statement/sql/select 6 +statement/sql/select 9 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 6 +execute dump_transactions_history; +event_name count(event_name) +transaction 6 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -1073,192 +1148,201 @@ user4 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS connection con4; -select get_lock("marker", 10); -get_lock("marker", 10) +select uuid_short() <> 1; +uuid_short() <> 1 1 -select release_lock("marker"); -release_lock("marker") +select uuid_short() <> 1; +uuid_short() <> 1 1 +start transaction; insert into test.t1 values ("marker"); +commit; +select test.f(10,20); +test.f(10,20) +30 connection default; "================== Step 9 ==================" call dump_thread(); username event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 user1 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user2 wait/io/file/sql/query_log 4 -user2 wait/synch/mutex/sql/LOCK_connection_count 0 -user2 wait/synch/mutex/sql/LOCK_user_locks 0 +user2 wait/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user3 wait/io/file/sql/query_log 4 -user3 wait/synch/mutex/sql/LOCK_connection_count 0 -user3 wait/synch/mutex/sql/LOCK_user_locks 0 +user3 wait/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user4 wait/io/file/sql/query_log 4 -user4 wait/synch/mutex/sql/LOCK_connection_count 0 -user4 wait/synch/mutex/sql/LOCK_user_locks 0 +user4 wait/io/file/sql/query_log 7 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/file/sql/query_log 4 -user1 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/io/file/sql/query_log 7 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user2 localhost wait/io/file/sql/query_log 4 -user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/io/file/sql/query_log 7 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user3 localhost wait/io/file/sql/query_log 4 -user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/io/file/sql/query_log 7 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user4 localhost wait/io/file/sql/query_log 4 -user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/io/file/sql/query_log 7 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 4 -user1 wait/synch/mutex/sql/LOCK_connection_count 0 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 28 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 16 +wait/io/file/sql/query_log 28 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 5 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 6 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 5 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 6 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 20 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 24 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 20 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 24 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -1282,178 +1366,183 @@ 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/io/file/sql/query_log 7 user2 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user3 wait/io/file/sql/query_log 4 -user3 wait/synch/mutex/sql/LOCK_connection_count 0 -user3 wait/synch/mutex/sql/LOCK_user_locks 0 +user3 wait/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user4 wait/io/file/sql/query_log 4 -user4 wait/synch/mutex/sql/LOCK_connection_count 0 -user4 wait/synch/mutex/sql/LOCK_user_locks 0 +user4 wait/io/file/sql/query_log 7 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/file/sql/query_log 5 -user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/io/file/sql/query_log 8 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user2 localhost wait/io/file/sql/query_log 4 -user2 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/io/file/sql/query_log 7 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user3 localhost wait/io/file/sql/query_log 4 -user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/io/file/sql/query_log 7 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user4 localhost wait/io/file/sql/query_log 4 -user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/io/file/sql/query_log 7 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 5 -user1 wait/synch/mutex/sql/LOCK_connection_count 1 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 8 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 29 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 17 -wait/synch/mutex/sql/LOCK_connection_count 1 +wait/io/file/sql/query_log 29 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 6 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 6 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 21 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 25 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 21 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 25 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 1 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -1479,173 +1568,180 @@ 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/io/file/sql/query_log 7 user3 wait/synch/rwlock/sql/LOCK_grant 1 username event_name count_star -user4 wait/io/file/sql/query_log 4 -user4 wait/synch/mutex/sql/LOCK_connection_count 0 -user4 wait/synch/mutex/sql/LOCK_user_locks 0 +user4 wait/io/file/sql/query_log 7 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/file/sql/query_log 5 -user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/io/file/sql/query_log 8 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user2 localhost wait/io/file/sql/query_log 5 -user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/io/file/sql/query_log 8 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user3 localhost wait/io/file/sql/query_log 4 -user3 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/io/file/sql/query_log 7 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user4 localhost wait/io/file/sql/query_log 4 -user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/io/file/sql/query_log 7 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 5 -user1 wait/synch/mutex/sql/LOCK_connection_count 1 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 7 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/io/file/sql/query_log 7 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/io/file/sql/query_log 30 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 18 -wait/synch/mutex/sql/LOCK_connection_count 2 +wait/io/file/sql/query_log 30 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 6 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 6 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 22 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 26 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 22 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 26 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 2 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -1673,168 +1769,177 @@ 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/io/file/sql/query_log 7 user4 wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_account; user host event_name count_star -user1 localhost wait/io/file/sql/query_log 5 -user1 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user1 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user1 localhost wait/io/file/sql/query_log 8 user1 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user2 localhost wait/io/file/sql/query_log 5 -user2 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user2 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user2 localhost wait/io/file/sql/query_log 8 user2 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user3 localhost wait/io/file/sql/query_log 5 -user3 localhost wait/synch/mutex/sql/LOCK_connection_count 1 -user3 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user3 localhost wait/io/file/sql/query_log 8 user3 localhost wait/synch/rwlock/sql/LOCK_grant 1 -user4 localhost wait/io/file/sql/query_log 4 -user4 localhost wait/synch/mutex/sql/LOCK_connection_count 0 -user4 localhost wait/synch/mutex/sql/LOCK_user_locks 0 +user4 localhost wait/io/file/sql/query_log 7 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 5 -user1 wait/synch/mutex/sql/LOCK_connection_count 1 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 7 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/io/file/sql/query_log 31 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 19 -wait/synch/mutex/sql/LOCK_connection_count 3 +wait/io/file/sql/query_log 31 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 6 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 6 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 23 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 27 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 23 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 27 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 3 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -1865,162 +1970,173 @@ 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 5 -user1 wait/synch/mutex/sql/LOCK_connection_count 1 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 20 -wait/synch/mutex/sql/LOCK_connection_count 4 +wait/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2052,162 +2168,173 @@ 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 user4 localhost wait/synch/rwlock/sql/LOCK_grant 1 execute dump_waits_user; user event_name count_star -user1 wait/io/file/sql/query_log 5 -user1 wait/synch/mutex/sql/LOCK_connection_count 1 -user1 wait/synch/mutex/sql/LOCK_user_locks 0 +user1 wait/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 20 -wait/synch/mutex/sql/LOCK_connection_count 4 +wait/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2239,161 +2366,172 @@ 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 8 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 20 -wait/synch/mutex/sql/LOCK_connection_count 4 +wait/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2425,161 +2563,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 20 -wait/synch/mutex/sql/LOCK_connection_count 4 +wait/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2611,161 +2760,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_waits_history; event_name count(event_name) -wait/io/file/sql/query_log 20 -wait/synch/mutex/sql/LOCK_connection_count 4 +wait/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2797,161 +2957,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -2983,161 +3154,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 3 -user1 localhost stage/sql/Closing tables 6 -user1 localhost stage/sql/Init 6 -user1 localhost stage/sql/Init for update 1 -user1 localhost stage/sql/Opening tables 4 -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 +user1 localhost stage/sql/checking permissions 4 +user1 localhost stage/sql/closing tables 11 +user1 localhost stage/sql/init 3 +user1 localhost stage/sql/Opening tables 7 +user1 localhost stage/sql/starting 7 +user2 localhost stage/sql/checking permissions 4 +user2 localhost stage/sql/closing tables 10 +user2 localhost stage/sql/init 3 +user2 localhost stage/sql/Opening tables 6 +user2 localhost stage/sql/starting 7 +user3 localhost stage/sql/checking permissions 4 +user3 localhost stage/sql/closing tables 10 +user3 localhost stage/sql/init 3 +user3 localhost stage/sql/Opening tables 6 +user3 localhost stage/sql/starting 7 +user4 localhost stage/sql/checking permissions 4 +user4 localhost stage/sql/closing tables 10 +user4 localhost stage/sql/init 3 +user4 localhost stage/sql/Opening tables 6 +user4 localhost stage/sql/starting 7 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3169,161 +3351,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 3 -user1 stage/sql/Closing tables 6 -user1 stage/sql/Init 6 -user1 stage/sql/Init for update 1 -user1 stage/sql/Opening tables 4 -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 +user1 stage/sql/checking permissions 4 +user1 stage/sql/closing tables 11 +user1 stage/sql/init 3 +user1 stage/sql/Opening tables 7 +user1 stage/sql/starting 7 +user2 stage/sql/checking permissions 4 +user2 stage/sql/closing tables 10 +user2 stage/sql/init 3 +user2 stage/sql/Opening tables 6 +user2 stage/sql/starting 7 +user3 stage/sql/checking permissions 4 +user3 stage/sql/closing tables 10 +user3 stage/sql/init 3 +user3 stage/sql/Opening tables 6 +user3 stage/sql/starting 7 +user4 stage/sql/checking permissions 4 +user4 stage/sql/closing tables 10 +user4 stage/sql/init 3 +user4 stage/sql/Opening tables 6 +user4 stage/sql/starting 7 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3355,161 +3548,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3541,161 +3745,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star execute dump_stages_global; event_name count_star -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3727,161 +3942,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3913,161 +4139,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 1 +user1 localhost statement/sp/freturn 1 user1 localhost statement/sql/insert 1 -user1 localhost statement/sql/select 2 +user1 localhost statement/sql/select 3 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 1 +user2 localhost statement/sp/freturn 1 user2 localhost statement/sql/insert 1 -user2 localhost statement/sql/select 2 +user2 localhost statement/sql/select 3 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 1 +user3 localhost statement/sp/freturn 1 user3 localhost statement/sql/insert 1 -user3 localhost statement/sql/select 2 +user3 localhost statement/sql/select 3 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 1 +user4 localhost statement/sp/freturn 1 user4 localhost statement/sql/insert 1 -user4 localhost statement/sql/select 2 +user4 localhost statement/sql/select 3 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4099,161 +4336,172 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 user1 localhost statement/sql/insert 0 user1 localhost statement/sql/select 0 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 user2 localhost statement/sql/insert 0 user2 localhost statement/sql/select 0 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 user3 localhost statement/sql/insert 0 user3 localhost statement/sql/select 0 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 user4 localhost statement/sql/insert 0 user4 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 1 +user1 statement/sp/freturn 1 user1 statement/sql/insert 1 -user1 statement/sql/select 2 +user1 statement/sql/select 3 user2 statement/com/Error 0 user2 statement/com/Quit 1 +user2 statement/sp/freturn 1 user2 statement/sql/insert 1 -user2 statement/sql/select 2 +user2 statement/sql/select 3 user3 statement/com/Error 0 user3 statement/com/Quit 1 +user3 statement/sp/freturn 1 user3 statement/sql/insert 1 -user3 statement/sql/select 2 +user3 statement/sql/select 3 user4 statement/com/Error 0 user4 statement/com/Quit 1 +user4 statement/sp/freturn 1 user4 statement/sql/insert 1 -user4 statement/sql/select 2 +user4 statement/sql/select 3 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/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4285,146 +4533,135 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 user1 localhost statement/sql/insert 0 user1 localhost statement/sql/select 0 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 user2 localhost statement/sql/insert 0 user2 localhost statement/sql/select 0 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 user3 localhost statement/sql/insert 0 user3 localhost statement/sql/select 0 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 user4 localhost statement/sql/insert 0 user4 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; @@ -4433,13 +4670,35 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4471,146 +4730,135 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 user1 localhost statement/sql/insert 0 user1 localhost statement/sql/select 0 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 user2 localhost statement/sql/insert 0 user2 localhost statement/sql/select 0 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 user3 localhost statement/sql/insert 0 user3 localhost statement/sql/select 0 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 user4 localhost statement/sql/insert 0 user4 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; @@ -4619,13 +4867,35 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4657,146 +4927,923 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star -user1 localhost stage/sql/Checking permissions 0 -user1 localhost stage/sql/Closing tables 0 -user1 localhost stage/sql/Init 0 -user1 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 user1 localhost stage/sql/Opening tables 0 -user2 localhost stage/sql/Checking permissions 0 -user2 localhost stage/sql/Closing tables 0 -user2 localhost stage/sql/Init 0 -user2 localhost stage/sql/Init for update 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 user2 localhost stage/sql/Opening tables 0 -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 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 user3 localhost stage/sql/Opening tables 0 -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 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_statements_account; +user host event_name count_star +user1 localhost statement/com/Error 0 +user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 +user1 localhost statement/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +user1 statement/com/Error 0 +user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 +user1 statement/sql/insert 0 +user1 statement/sql/select 0 +user2 statement/com/Error 0 +user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 +user2 statement/sql/insert 0 +user2 statement/sql/select 0 +user3 statement/com/Error 0 +user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 +user3 statement/sql/insert 0 +user3 statement/sql/select 0 +user4 statement/com/Error 0 +user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 +user4 statement/sql/insert 0 +user4 statement/sql/select 0 +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sp/freturn 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sp/freturn 4 +statement/sql/insert 4 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 0 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.events_transactions_summary_by_thread_by_event_name; +"================== TRANSACTIONS_BY_THREAD truncated ==================" +"================== Step 29 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/file/sql/query_log 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +user2 wait/io/file/sql/query_log 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +user3 wait/io/file/sql/query_log 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +user4 wait/io/file/sql/query_log 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 32 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 +user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 +user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 +user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 +user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 +user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 +user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 +user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 +user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 +stage/sql/Opening tables 0 +stage/sql/starting 0 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_statements_account; +user host event_name count_star +user1 localhost statement/com/Error 0 +user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 +user1 localhost statement/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +user1 statement/com/Error 0 +user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 +user1 statement/sql/insert 0 +user1 statement/sql/select 0 +user2 statement/com/Error 0 +user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 +user2 statement/sql/insert 0 +user2 statement/sql/select 0 +user3 statement/com/Error 0 +user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 +user3 statement/sql/insert 0 +user3 statement/sql/select 0 +user4 statement/com/Error 0 +user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 +user4 statement/sql/insert 0 +user4 statement/sql/select 0 +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sp/freturn 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sp/freturn 4 +statement/sql/insert 4 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 2 +user2 localhost transaction 2 +user3 localhost transaction 2 +user4 localhost transaction 2 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 0 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.events_transactions_summary_by_account_by_event_name; +"================== TRANSACTIONS_BY_ACCOUNT truncated ==================" +"================== Step 30 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/file/sql/query_log 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +user2 wait/io/file/sql/query_log 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +user3 wait/io/file/sql/query_log 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +user4 wait/io/file/sql/query_log 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 32 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 +user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 +user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 +user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 +user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 +user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 +user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 +user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 +user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 +stage/sql/Opening tables 0 +stage/sql/starting 0 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_statements_account; +user host event_name count_star +user1 localhost statement/com/Error 0 +user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 +user1 localhost statement/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +user1 statement/com/Error 0 +user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 +user1 statement/sql/insert 0 +user1 statement/sql/select 0 +user2 statement/com/Error 0 +user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 +user2 statement/sql/insert 0 +user2 statement/sql/select 0 +user3 statement/com/Error 0 +user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 +user3 statement/sql/insert 0 +user3 statement/sql/select 0 +user4 statement/com/Error 0 +user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 +user4 statement/sql/insert 0 +user4 statement/sql/select 0 +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sp/freturn 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sp/freturn 4 +statement/sql/insert 4 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 0 +user2 localhost transaction 0 +user3 localhost transaction 0 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 2 +user2 transaction 2 +user3 transaction 2 +user4 transaction 2 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 0 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.events_transactions_summary_by_user_by_event_name; +"================== TRANSACTIONS_BY_USER truncated ==================" +"================== Step 31 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/file/sql/query_log 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +user2 wait/io/file/sql/query_log 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +user3 wait/io/file/sql/query_log 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +user4 wait/io/file/sql/query_log 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 32 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 +user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 +user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 +user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 +user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 +user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 +user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 +user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 +user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 +stage/sql/Opening tables 0 +stage/sql/starting 0 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_statements_account; +user host event_name count_star +user1 localhost statement/com/Error 0 +user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 +user1 localhost statement/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +user1 statement/com/Error 0 +user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 +user1 statement/sql/insert 0 +user1 statement/sql/select 0 +user2 statement/com/Error 0 +user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 +user2 statement/sql/insert 0 +user2 statement/sql/select 0 +user3 statement/com/Error 0 +user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 +user3 statement/sql/insert 0 +user3 statement/sql/select 0 +user4 statement/com/Error 0 +user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 +user4 statement/sql/insert 0 +user4 statement/sql/select 0 +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sp/freturn 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sp/freturn 4 +statement/sql/insert 4 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 0 +user2 localhost transaction 0 +user3 localhost transaction 0 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 0 +user2 transaction 0 +user3 transaction 0 +user4 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 0 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.events_transactions_summary_by_host_by_event_name; +"================== TRANSACTIONS_BY_HOST truncated ==================" +"================== Step 32 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/file/sql/query_log 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +user2 wait/io/file/sql/query_log 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +user3 wait/io/file/sql/query_log 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +user4 wait/io/file/sql/query_log 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 32 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 +user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 +user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 +user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 +user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 +user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 +user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 +user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 +user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 +stage/sql/Opening tables 0 +stage/sql/starting 0 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star user1 localhost statement/com/Error 0 user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 user1 localhost statement/sql/insert 0 user1 localhost statement/sql/select 0 user2 localhost statement/com/Error 0 user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 user2 localhost statement/sql/insert 0 user2 localhost statement/sql/select 0 user3 localhost statement/com/Error 0 user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 user3 localhost statement/sql/insert 0 user3 localhost statement/sql/select 0 user4 localhost statement/com/Error 0 user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 user4 localhost statement/sql/insert 0 user4 localhost statement/sql/select 0 execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; @@ -4805,13 +5852,232 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 0 +user2 localhost transaction 0 +user3 localhost transaction 0 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 0 +user2 transaction 0 +user3 transaction 0 +user4 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 8 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 0 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +truncate performance_schema.events_transactions_summary_global_by_event_name; +"================== TRANSACTIONS_GLOBAL truncated ==================" +"================== Step 33 ==================" +call dump_thread(); +username status +user1 not found +username status +user2 not found +username status +user3 not found +username status +user4 not found +execute dump_waits_account; +user host event_name count_star +user1 localhost wait/io/file/sql/query_log 0 +user1 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user2 localhost wait/io/file/sql/query_log 0 +user2 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user3 localhost wait/io/file/sql/query_log 0 +user3 localhost wait/synch/rwlock/sql/LOCK_grant 0 +user4 localhost wait/io/file/sql/query_log 0 +user4 localhost wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_user; +user event_name count_star +user1 wait/io/file/sql/query_log 0 +user1 wait/synch/rwlock/sql/LOCK_grant 0 +user2 wait/io/file/sql/query_log 0 +user2 wait/synch/rwlock/sql/LOCK_grant 0 +user3 wait/io/file/sql/query_log 0 +user3 wait/synch/rwlock/sql/LOCK_grant 0 +user4 wait/io/file/sql/query_log 0 +user4 wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_host; +host event_name count_star +execute dump_waits_global; +event_name count_star +wait/io/file/sql/query_log 0 +wait/synch/rwlock/sql/LOCK_grant 0 +execute dump_waits_history; +event_name count(event_name) +wait/io/file/sql/query_log 32 +wait/synch/rwlock/sql/LOCK_grant 4 +execute dump_stages_account; +user host event_name count_star +user1 localhost stage/sql/checking permissions 0 +user1 localhost stage/sql/closing tables 0 +user1 localhost stage/sql/init 0 +user1 localhost stage/sql/Opening tables 0 +user1 localhost stage/sql/starting 0 +user2 localhost stage/sql/checking permissions 0 +user2 localhost stage/sql/closing tables 0 +user2 localhost stage/sql/init 0 +user2 localhost stage/sql/Opening tables 0 +user2 localhost stage/sql/starting 0 +user3 localhost stage/sql/checking permissions 0 +user3 localhost stage/sql/closing tables 0 +user3 localhost stage/sql/init 0 +user3 localhost stage/sql/Opening tables 0 +user3 localhost stage/sql/starting 0 +user4 localhost stage/sql/checking permissions 0 +user4 localhost stage/sql/closing tables 0 +user4 localhost stage/sql/init 0 +user4 localhost stage/sql/Opening tables 0 +user4 localhost stage/sql/starting 0 +execute dump_stages_user; +user event_name count_star +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 +user1 stage/sql/Opening tables 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 +user2 stage/sql/Opening tables 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 +user3 stage/sql/Opening tables 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 +user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 +execute dump_stages_host; +host event_name count_star +execute dump_stages_global; +event_name count_star +stage/sql/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 +stage/sql/Opening tables 0 +stage/sql/starting 0 +execute dump_stages_history; +event_name count(event_name) +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 +execute dump_statements_account; +user host event_name count_star +user1 localhost statement/com/Error 0 +user1 localhost statement/com/Quit 0 +user1 localhost statement/sp/freturn 0 +user1 localhost statement/sql/insert 0 +user1 localhost statement/sql/select 0 +user2 localhost statement/com/Error 0 +user2 localhost statement/com/Quit 0 +user2 localhost statement/sp/freturn 0 +user2 localhost statement/sql/insert 0 +user2 localhost statement/sql/select 0 +user3 localhost statement/com/Error 0 +user3 localhost statement/com/Quit 0 +user3 localhost statement/sp/freturn 0 +user3 localhost statement/sql/insert 0 +user3 localhost statement/sql/select 0 +user4 localhost statement/com/Error 0 +user4 localhost statement/com/Quit 0 +user4 localhost statement/sp/freturn 0 +user4 localhost statement/sql/insert 0 +user4 localhost statement/sql/select 0 +execute dump_statements_user; +user event_name count_star +user1 statement/com/Error 0 +user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 +user1 statement/sql/insert 0 +user1 statement/sql/select 0 +user2 statement/com/Error 0 +user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 +user2 statement/sql/insert 0 +user2 statement/sql/select 0 +user3 statement/com/Error 0 +user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 +user3 statement/sql/insert 0 +user3 statement/sql/select 0 +user4 statement/com/Error 0 +user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 +user4 statement/sql/insert 0 +user4 statement/sql/select 0 +execute dump_statements_host; +host event_name count_star +execute dump_statements_global; +event_name count_star +statement/com/Error 0 +statement/com/Quit 0 +statement/sp/freturn 0 +statement/sql/insert 0 +statement/sql/select 0 +execute dump_statements_history; +event_name count(event_name) +statement/com/Quit 4 +statement/sp/freturn 4 +statement/sql/insert 4 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +user1 localhost transaction 0 +user2 localhost transaction 0 +user3 localhost transaction 0 +user4 localhost transaction 0 +execute dump_transactions_user; +user event_name count_star +user1 transaction 0 +user2 transaction 0 +user3 transaction 0 +user4 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4830,7 +6096,7 @@ execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.accounts; "================== ACCOUNTS truncated ==================" -"================== Step 29 ==================" +"================== Step 34 ==================" call dump_thread(); username status user1 not found @@ -4845,92 +6111,85 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star execute dump_stages_user; user event_name count_star -user1 stage/sql/Checking permissions 0 -user1 stage/sql/Closing tables 0 -user1 stage/sql/Init 0 -user1 stage/sql/Init for update 0 +user1 stage/sql/checking permissions 0 +user1 stage/sql/closing tables 0 +user1 stage/sql/init 0 user1 stage/sql/Opening tables 0 -user2 stage/sql/Checking permissions 0 -user2 stage/sql/Closing tables 0 -user2 stage/sql/Init 0 -user2 stage/sql/Init for update 0 +user1 stage/sql/starting 0 +user2 stage/sql/checking permissions 0 +user2 stage/sql/closing tables 0 +user2 stage/sql/init 0 user2 stage/sql/Opening tables 0 -user3 stage/sql/Checking permissions 0 -user3 stage/sql/Closing tables 0 -user3 stage/sql/Init 0 -user3 stage/sql/Init for update 0 +user2 stage/sql/starting 0 +user3 stage/sql/checking permissions 0 +user3 stage/sql/closing tables 0 +user3 stage/sql/init 0 user3 stage/sql/Opening tables 0 -user4 stage/sql/Checking permissions 0 -user4 stage/sql/Closing tables 0 -user4 stage/sql/Init 0 -user4 stage/sql/Init for update 0 +user3 stage/sql/starting 0 +user4 stage/sql/checking permissions 0 +user4 stage/sql/closing tables 0 +user4 stage/sql/init 0 user4 stage/sql/Opening tables 0 +user4 stage/sql/starting 0 execute dump_stages_host; host event_name count_star 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star execute dump_statements_user; user event_name count_star user1 statement/com/Error 0 user1 statement/com/Quit 0 +user1 statement/sp/freturn 0 user1 statement/sql/insert 0 user1 statement/sql/select 0 user2 statement/com/Error 0 user2 statement/com/Quit 0 +user2 statement/sp/freturn 0 user2 statement/sql/insert 0 user2 statement/sql/select 0 user3 statement/com/Error 0 user3 statement/com/Quit 0 +user3 statement/sp/freturn 0 user3 statement/sql/insert 0 user3 statement/sql/select 0 user4 statement/com/Error 0 user4 statement/com/Quit 0 +user4 statement/sp/freturn 0 user4 statement/sql/insert 0 user4 statement/sql/select 0 execute dump_statements_host; @@ -4939,13 +6198,31 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +execute dump_transactions_user; +user event_name count_star +user1 transaction 0 +user2 transaction 0 +user3 transaction 0 +user4 transaction 0 +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -4960,7 +6237,7 @@ execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.users; "================== USERS truncated ==================" -"================== Step 30 ==================" +"================== Step 35 ==================" call dump_thread(); username status user1 not found @@ -4979,13 +6256,10 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star @@ -4995,18 +6269,18 @@ 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star execute dump_statements_user; @@ -5017,13 +6291,27 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +execute dump_transactions_user; +user event_name count_star +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -5034,7 +6322,7 @@ execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS truncate performance_schema.hosts; "================== HOSTS truncated ==================" -"================== Step 31 ==================" +"================== Step 36 ==================" call dump_thread(); username status user1 not found @@ -5053,13 +6341,10 @@ 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/io/file/sql/query_log 32 wait/synch/rwlock/sql/LOCK_grant 4 execute dump_stages_account; user host event_name count_star @@ -5069,18 +6354,18 @@ 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/checking permissions 0 +stage/sql/closing tables 0 +stage/sql/init 0 stage/sql/Opening tables 0 +stage/sql/starting 0 execute dump_stages_history; event_name count(event_name) -stage/sql/Checking permissions 12 -stage/sql/Closing tables 18 -stage/sql/Init 24 -stage/sql/Init for update 4 -stage/sql/Opening tables 13 +stage/sql/checking permissions 16 +stage/sql/closing tables 41 +stage/sql/init 12 +stage/sql/Opening tables 25 +stage/sql/starting 28 execute dump_statements_account; user host event_name count_star execute dump_statements_user; @@ -5091,13 +6376,27 @@ execute dump_statements_global; event_name count_star statement/com/Error 0 statement/com/Quit 0 +statement/sp/freturn 0 statement/sql/insert 0 statement/sql/select 0 execute dump_statements_history; event_name count(event_name) statement/com/Quit 4 +statement/sp/freturn 4 statement/sql/insert 4 -statement/sql/select 8 +statement/sql/select 12 +execute dump_transactions_account; +user host event_name count_star +execute dump_transactions_user; +user event_name count_star +execute dump_transactions_host; +host event_name count_star +execute dump_transactions_global; +event_name count_star +transaction 0 +execute dump_transactions_history; +event_name count(event_name) +transaction 8 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 |