diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/memory_aggregate.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/memory_aggregate.result | 5602 |
1 files changed, 5602 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/memory_aggregate.result b/mysql-test/suite/perfschema/r/memory_aggregate.result new file mode 100644 index 00000000..69eb033e --- /dev/null +++ b/mysql-test/suite/perfschema/r/memory_aggregate.result @@ -0,0 +1,5602 @@ +show global status like "performance_schema_memory_classes_lost"; +Variable_name Value +Performance_schema_memory_classes_lost 0 +"================== Step 1 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 1 +connect con1, localhost, user1, , ; +"================== con1 connected ==================" +connection default; +"================== Step 2 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 2 2 +connection con1; +set GLOBAL query_cache_size=1000*1024; +select get_lock("marker_1", 10); +get_lock("marker_1", 10) +1 +select release_lock("marker_1"); +release_lock("marker_1") +1 +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); +"================== con1 marker ==================" +connection default; +"================== Step 3 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 4 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7120 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 7120 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 4 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7120 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 7120 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 2 2 +connect con2, localhost, user2, , ; +"================== con2 connected ==================" +connection default; +"================== Step 4 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 4 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7120 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 7120 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 4 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7120 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 7120 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 3 3 +connection con2; +set GLOBAL query_cache_size=2000*1024; +select get_lock("marker_2", 10); +get_lock("marker_2", 10) +1 +select release_lock("marker_2"); +release_lock("marker_2") +1 +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); +"================== con2 marker ==================" +connection default; +"================== Step 5 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 3 3 +truncate table performance_schema.memory_summary_by_thread_by_event_name; +"================== MEMORY_BY_THREAD truncated ==================" +"================== Step 5b ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 3 3 +connect con3, localhost, user3, , ; +"================== con3 connected ==================" +connection default; +"================== Step 6 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 7 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14144 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 7 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 14144 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +user3 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 4 4 +connection con3; +set GLOBAL query_cache_size=500*1024; +select get_lock("marker_3", 10); +get_lock("marker_3", 10) +1 +select release_lock("marker_3"); +release_lock("marker_3") +1 +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); +"================== con3 marker ==================" +connection default; +"================== Step 7 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 816 +SUM_NUMBER_OF_BYTES_FREE 48 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 816 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 10 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 21168 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 21168 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 65536 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 816 +SUM_NUMBER_OF_BYTES_FREE 48 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 816 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 10 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 21168 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 21168 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +user3 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 4 4 +connect con4, localhost, user4, , ; +connect con5, localhost, user4, , ; +"================== con4/con5 (both user4) connected ==================" +connection default; +"================== Step 8 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +username user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 816 +SUM_NUMBER_OF_BYTES_FREE 48 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 816 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 10 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 21168 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 21168 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 65536 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 816 +SUM_NUMBER_OF_BYTES_FREE 48 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 816 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 10 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 21168 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 21168 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +user4 localhost 2 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +user3 1 1 +user4 2 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 6 6 +connection con4; +set GLOBAL query_cache_size=4000*1024; +select get_lock("marker_4", 10); +get_lock("marker_4", 10) +1 +select release_lock("marker_4"); +release_lock("marker_4") +1 +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); +connection con5; +select get_lock("marker_5", 10); +get_lock("marker_5", 10) +1 +select release_lock("marker_5"); +release_lock("marker_5") +1 +set @v1 = repeat("a", 1000); +set @v2 = repeat("b", 2000); +set @v3 = repeat("c", 4000); +"================== con4/con5 marker ==================" +connection default; +"================== Step 9 ==================" +call dump_thread(); +username user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 6 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 14048 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 32 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 6 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 14048 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 5 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 80 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 5 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 1280 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 16 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 35216 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 5 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 80 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 5 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 1280 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 16 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 35216 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 1 1 +user2 localhost 1 1 +user3 localhost 1 1 +user4 localhost 2 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 1 1 +user2 1 1 +user3 1 1 +user4 2 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 6 6 +disconnect con1; +disconnect con5; +connection default; +"================== con1/con5 disconnected ==================" +"================== Step 10 ==================" +call dump_thread(); +username user1 +status not found +username user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 256 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 256 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 256 +username user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 3 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 7024 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 7 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 592 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 7 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 592 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 768 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 10 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 21168 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 1 1 +user3 localhost 1 1 +user4 localhost 1 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 1 1 +user3 1 1 +user4 1 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 4 6 +disconnect con2; +connection default; +"================== con2 disconnected ==================" +"================== Step 11 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +username user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 8 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 848 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 9 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 21072 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 8 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 848 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 512 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 9 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 21072 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 7 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 14144 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 1 1 +user4 localhost 1 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 1 1 +user4 1 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 3 6 +disconnect con3; +connection default; +"================== con3 disconnected ==================" +"================== Step 12 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 1 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 16 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 272 +username user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 288 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 3 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 9 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1104 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 12 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 28096 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 9 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1104 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 256 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 12 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 28096 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 4 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 7120 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +user1 localhost 0 1 +user2 localhost 0 1 +user3 localhost 0 1 +user4 localhost 1 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 1 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 2 6 +disconnect con4; +connection default; +"================== con4 disconnected ==================" +"================== Step 13 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 544 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 544 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +connection default; +truncate performance_schema.memory_summary_by_thread_by_event_name; +"================== MEMORY_BY_THREAD truncated ==================" +"================== Step 14 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 544 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 544 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.memory_summary_by_account_by_event_name; +"================== MEMORY_BY_ACCOUNT truncated ==================" +"================== Step 15 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 2 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_FREE 272 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 272 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 3 +COUNT_FREE 3 +SUM_NUMBER_OF_BYTES_ALLOC 7024 +SUM_NUMBER_OF_BYTES_FREE 7024 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 3 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 7024 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 4 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 544 +SUM_NUMBER_OF_BYTES_FREE 544 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 4 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 544 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 6 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 14048 +SUM_NUMBER_OF_BYTES_FREE 14048 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 6 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 14048 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.memory_summary_by_user_by_event_name; +"================== MEMORY_BY_USER truncated ==================" +"================== Step 16 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.memory_summary_by_host_by_event_name; +"================== MEMORY_BY_HOST truncated ==================" +"================== Step 17 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 10 +COUNT_FREE 10 +SUM_NUMBER_OF_BYTES_ALLOC 1360 +SUM_NUMBER_OF_BYTES_FREE 1360 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 10 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 1360 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 16 +COUNT_FREE 15 +SUM_NUMBER_OF_BYTES_ALLOC 35216 +SUM_NUMBER_OF_BYTES_FREE 35120 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 16 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 35216 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.memory_summary_global_by_event_name; +"================== MEMORY_GLOBAL truncated ==================" +"================== Step 18 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +USER user1 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +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 2 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.accounts; +"================== ACCOUNTS truncated ==================" +"================== Step 19 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +execute dump_memory_user; +USER user1 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user1 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user2 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user3 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +USER user4 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +user1 0 1 +user2 0 1 +user3 0 1 +user4 0 2 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.users; +"================== USERS truncated ==================" +"================== Step 20 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 6 +truncate performance_schema.hosts; +"================== HOSTS truncated ==================" +"================== Step 21 ==================" +call dump_thread(); +username user1 +status not found +username user2 +status not found +username user3 +status not found +username user4 +status not found +execute dump_memory_account; +execute dump_memory_user; +execute dump_memory_host; +HOST localhost +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +HOST localhost +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_memory_global; +EVENT_NAME memory/sql/Query_cache +COUNT_ALLOC 2 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 32768 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 +EVENT_NAME memory/sql/User_level_lock +COUNT_ALLOC 0 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 0 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 0 +CURRENT_COUNT_USED 0 +HIGH_COUNT_USED 0 +LOW_NUMBER_OF_BYTES_USED 0 +CURRENT_NUMBER_OF_BYTES_USED 0 +HIGH_NUMBER_OF_BYTES_USED 0 +EVENT_NAME memory/sql/user_var_entry::value +COUNT_ALLOC 1 +COUNT_FREE 0 +SUM_NUMBER_OF_BYTES_ALLOC 96 +SUM_NUMBER_OF_BYTES_FREE 0 +LOW_COUNT_USED 1 +CURRENT_COUNT_USED 1 +HIGH_COUNT_USED 1 +LOW_NUMBER_OF_BYTES_USED 96 +CURRENT_NUMBER_OF_BYTES_USED 96 +HIGH_NUMBER_OF_BYTES_USED 96 +execute dump_accounts; +USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root localhost 1 1 +execute dump_users; +USER CURRENT_CONNECTIONS TOTAL_CONNECTIONS +root 1 1 +execute dump_hosts; +HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS +localhost 1 1 |