diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/memory_aggregate_32bit.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/memory_aggregate_32bit.result | 2218 |
1 files changed, 1112 insertions, 1106 deletions
diff --git a/mysql-test/suite/perfschema/r/memory_aggregate_32bit.result b/mysql-test/suite/perfschema/r/memory_aggregate_32bit.result index 5639a62cbc5..2b8ee675650 100644 --- a/mysql-test/suite/perfschema/r/memory_aggregate_32bit.result +++ b/mysql-test/suite/perfschema/r/memory_aggregate_32bit.result @@ -1,15 +1,3 @@ -Warnings: -Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. -Warnings: -Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. -Warnings: -Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. -Warnings: -Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. -Warnings: -Warning 1287 Using GRANT for creating new user is deprecated and will be removed in future release. Create new user with CREATE USER statement. -Warnings: -Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. show global status like "performance_schema_memory_classes_lost"; Variable_name Value Performance_schema_memory_classes_lost 0 @@ -42,14 +30,14 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -76,14 +64,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -93,7 +81,9 @@ 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 @@ -195,14 +185,14 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -229,14 +219,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -248,9 +238,8 @@ user1 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 2 2 +connection con1; set GLOBAL query_cache_size=1000*1024; -Warnings: -Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_1", 10); get_lock("marker_1", 10) 1 @@ -261,32 +250,33 @@ 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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 username user2 status not found username user3 @@ -299,111 +289,111 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7141 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 7141 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 1032192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 1032192 -HIGH_NUMBER_OF_BYTES_USED 1032192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7141 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 7141 +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 @@ -415,33 +405,35 @@ 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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 @@ -476,27 +468,27 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user2 HOST localhost EVENT_NAME memory/sql/User_level_lock @@ -528,26 +520,26 @@ USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 @@ -577,60 +569,60 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7141 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 7141 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 1032192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 1032192 -HIGH_NUMBER_OF_BYTES_USED 1032192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7141 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 7141 +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 @@ -644,9 +636,8 @@ user2 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 3 3 +connection con2; set GLOBAL query_cache_size=2000*1024; -Warnings: -Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_2", 10); get_lock("marker_2", 10) 1 @@ -657,56 +648,57 @@ 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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 username user3 status not found username user4 @@ -717,115 +709,115 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 @@ -835,32 +827,32 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +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 6 -COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 3088384 -SUM_NUMBER_OF_BYTES_FREE 1032192 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 49152 +SUM_NUMBER_OF_BYTES_FREE 24576 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2056192 -HIGH_NUMBER_OF_BYTES_USED 2056192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 @@ -869,7 +861,7 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +LOW_NUMBER_OF_BYTES_USED 96 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; @@ -893,50 +885,50 @@ username user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 @@ -947,115 +939,115 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 @@ -1065,32 +1057,32 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +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 6 -COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 3088384 -SUM_NUMBER_OF_BYTES_FREE 1032192 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 49152 +SUM_NUMBER_OF_BYTES_FREE 24576 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2056192 -HIGH_NUMBER_OF_BYTES_USED 2056192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 @@ -1099,7 +1091,7 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +LOW_NUMBER_OF_BYTES_USED 96 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; @@ -1115,57 +1107,59 @@ 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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 @@ -1198,53 +1192,53 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user3 HOST localhost EVENT_NAME memory/sql/User_level_lock @@ -1276,50 +1270,50 @@ USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 @@ -1349,14 +1343,14 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 @@ -1366,32 +1360,32 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +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 6 -COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 3088384 -SUM_NUMBER_OF_BYTES_FREE 1032192 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 49152 +SUM_NUMBER_OF_BYTES_FREE 24576 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2056192 -HIGH_NUMBER_OF_BYTES_USED 2056192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 7 COUNT_FREE 0 @@ -1400,7 +1394,7 @@ SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 7 HIGH_COUNT_USED 7 -LOW_NUMBER_OF_BYTES_USED 138 +LOW_NUMBER_OF_BYTES_USED 96 CURRENT_NUMBER_OF_BYTES_USED 14144 HIGH_NUMBER_OF_BYTES_USED 14144 execute dump_accounts; @@ -1418,9 +1412,8 @@ user3 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 4 4 +connection con3; set GLOBAL query_cache_size=500*1024; -Warnings: -Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_3", 10); get_lock("marker_3", 10) 1 @@ -1431,80 +1424,81 @@ 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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 username user4 status not found execute dump_memory_account; @@ -1513,211 +1507,211 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 408 +SUM_NUMBER_OF_BYTES_ALLOC 600 SUM_NUMBER_OF_BYTES_FREE 24 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 408 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 600 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 21147 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 21147 +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 9 -COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 3608576 -SUM_NUMBER_OF_BYTES_FREE 3088384 +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 73728 +SUM_NUMBER_OF_BYTES_FREE 49152 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 520192 -HIGH_NUMBER_OF_BYTES_USED 2056192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 408 +SUM_NUMBER_OF_BYTES_ALLOC 600 SUM_NUMBER_OF_BYTES_FREE 24 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 408 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 600 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 21147 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 21147 +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 @@ -1733,81 +1727,84 @@ 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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 @@ -1838,79 +1835,79 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user4 HOST localhost EVENT_NAME memory/sql/User_level_lock @@ -1942,74 +1939,74 @@ USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +CURRENT_NUMBER_OF_BYTES_USED 7024 +HIGH_NUMBER_OF_BYTES_USED 7024 USER user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 @@ -2039,60 +2036,60 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 408 +SUM_NUMBER_OF_BYTES_ALLOC 600 SUM_NUMBER_OF_BYTES_FREE 24 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 408 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 600 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 21147 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 21147 +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 9 -COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 3608576 -SUM_NUMBER_OF_BYTES_FREE 3088384 +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 73728 +SUM_NUMBER_OF_BYTES_FREE 49152 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 520192 -HIGH_NUMBER_OF_BYTES_USED 2056192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 408 +SUM_NUMBER_OF_BYTES_ALLOC 600 SUM_NUMBER_OF_BYTES_FREE 24 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 6 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 408 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 600 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 21147 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 21147 +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 @@ -2110,9 +2107,8 @@ user4 2 2 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 6 6 +connection con4; set GLOBAL query_cache_size=4000*1024; -Warnings: -Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. select get_lock("marker_4", 10); get_lock("marker_4", 10) 1 @@ -2122,6 +2118,7 @@ release_lock("marker_4") 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 @@ -2132,365 +2129,366 @@ 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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 14006 +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 14006 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 SUM_NUMBER_OF_BYTES_FREE 16 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 14006 +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 14006 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 SUM_NUMBER_OF_BYTES_FREE 40 LOW_COUNT_USED 0 CURRENT_COUNT_USED 5 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 640 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 960 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 35153 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 35153 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 5 -SUM_NUMBER_OF_BYTES_ALLOC 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 SUM_NUMBER_OF_BYTES_FREE 40 LOW_COUNT_USED 0 CURRENT_COUNT_USED 5 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 640 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 960 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 35153 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 35153 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -2508,6 +2506,9 @@ 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(); @@ -2517,335 +2518,335 @@ username user2 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 128 +SUM_NUMBER_OF_BYTES_ALLOC 192 SUM_NUMBER_OF_BYTES_FREE 0 LOW_COUNT_USED 1 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 1 -LOW_NUMBER_OF_BYTES_USED 128 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 128 +LOW_NUMBER_OF_BYTES_USED 192 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 192 username user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -CURRENT_NUMBER_OF_BYTES_USED 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 296 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 424 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 7 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 296 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 424 LOW_COUNT_USED 0 CURRENT_COUNT_USED 3 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 384 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 576 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 21147 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -2863,6 +2864,8 @@ 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(); @@ -2874,311 +2877,311 @@ username user3 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 424 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 616 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 21009 +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 138 +LOW_NUMBER_OF_BYTES_USED 96 CURRENT_NUMBER_OF_BYTES_USED 14144 -HIGH_NUMBER_OF_BYTES_USED 35153 +HIGH_NUMBER_OF_BYTES_USED 35216 execute dump_memory_global; EVENT_NAME memory/sql/Query_cache -COUNT_ALLOC 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 8 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 424 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 616 LOW_COUNT_USED 0 CURRENT_COUNT_USED 2 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 256 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 384 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 21009 +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 138 +LOW_NUMBER_OF_BYTES_USED 96 CURRENT_NUMBER_OF_BYTES_USED 14144 -HIGH_NUMBER_OF_BYTES_USED 35153 +HIGH_NUMBER_OF_BYTES_USED 35216 execute dump_accounts; USER HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS root localhost 1 1 @@ -3196,6 +3199,8 @@ 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(); @@ -3209,287 +3214,287 @@ username user4 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 -SUM_NUMBER_OF_BYTES_ALLOC 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 SUM_NUMBER_OF_BYTES_FREE 8 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 136 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 200 username user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 144 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 208 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 4 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 272 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 -HIGH_NUMBER_OF_BYTES_USED 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 552 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 808 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 12 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 28012 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 552 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 808 LOW_COUNT_USED 0 CURRENT_COUNT_USED 1 HIGH_COUNT_USED 10 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 128 -HIGH_NUMBER_OF_BYTES_USED 680 +CURRENT_NUMBER_OF_BYTES_USED 192 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 12 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 28012 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 7141 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -3507,6 +3512,8 @@ 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(); @@ -3524,261 +3531,261 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 400 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 272 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 14006 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 400 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 272 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -3796,6 +3803,7 @@ 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 ==================" @@ -3814,261 +3822,261 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 400 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 272 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 14006 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 400 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 272 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -4208,157 +4216,157 @@ USER user1 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 2 -SUM_NUMBER_OF_BYTES_ALLOC 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user1 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user2 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 136 -SUM_NUMBER_OF_BYTES_FREE 136 +SUM_NUMBER_OF_BYTES_ALLOC 200 +SUM_NUMBER_OF_BYTES_FREE 200 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 136 +HIGH_NUMBER_OF_BYTES_USED 200 USER user3 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 3 COUNT_FREE 3 -SUM_NUMBER_OF_BYTES_ALLOC 7003 -SUM_NUMBER_OF_BYTES_FREE 7003 +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 7003 +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 272 -SUM_NUMBER_OF_BYTES_FREE 272 +SUM_NUMBER_OF_BYTES_ALLOC 400 +SUM_NUMBER_OF_BYTES_FREE 400 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 272 +HIGH_NUMBER_OF_BYTES_USED 400 USER user4 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 6 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 14006 -SUM_NUMBER_OF_BYTES_FREE 14006 +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 14006 +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 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -4595,60 +4603,60 @@ HOST localhost EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -4897,48 +4905,48 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7712768 -SUM_NUMBER_OF_BYTES_FREE 3608576 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 73728 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 -SUM_NUMBER_OF_BYTES_ALLOC 680 -SUM_NUMBER_OF_BYTES_FREE 680 +SUM_NUMBER_OF_BYTES_ALLOC 1000 +SUM_NUMBER_OF_BYTES_FREE 1000 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 680 +HIGH_NUMBER_OF_BYTES_USED 1000 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 35153 -SUM_NUMBER_OF_BYTES_FREE 35015 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 35153 +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 @@ -5187,26 +5195,26 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 4104192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4104192 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 24576 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -5221,14 +5229,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -5373,26 +5381,26 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 4104192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4104192 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 24576 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -5407,14 +5415,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -5459,26 +5467,26 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 4104192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4104192 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 24576 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -5493,14 +5501,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -5541,26 +5549,26 @@ HOST localhost EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 1 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 3 +COUNT_ALLOC 2 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 4104192 +SUM_NUMBER_OF_BYTES_ALLOC 24576 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4104192 -CURRENT_NUMBER_OF_BYTES_USED 4104192 -HIGH_NUMBER_OF_BYTES_USED 4104192 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 24576 +CURRENT_NUMBER_OF_BYTES_USED 24576 +HIGH_NUMBER_OF_BYTES_USED 24576 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -5575,14 +5583,14 @@ 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 138 +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 138 -CURRENT_NUMBER_OF_BYTES_USED 138 -HIGH_NUMBER_OF_BYTES_USED 138 +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 @@ -5592,5 +5600,3 @@ root 1 1 execute dump_hosts; HOST CURRENT_CONNECTIONS TOTAL_CONNECTIONS localhost 1 1 -Warnings: -Warning 1287 '@@query_cache_size' is deprecated and will be removed in a future release. |