diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/memory_aggregate.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/memory_aggregate.result | 1362 |
1 files changed, 684 insertions, 678 deletions
diff --git a/mysql-test/suite/perfschema/r/memory_aggregate.result b/mysql-test/suite/perfschema/r/memory_aggregate.result index bb1718ed13c..69eb033e74b 100644 --- a/mysql-test/suite/perfschema/r/memory_aggregate.result +++ b/mysql-test/suite/perfschema/r/memory_aggregate.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,6 +250,7 @@ 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 @@ -279,14 +269,14 @@ 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 @@ -312,14 +302,14 @@ 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 @@ -337,14 +327,14 @@ 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 @@ -362,26 +352,26 @@ 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 1040384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 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 1040384 -HIGH_NUMBER_OF_BYTES_USED 1040384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 @@ -396,14 +386,14 @@ HIGH_NUMBER_OF_BYTES_USED 272 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 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,7 +405,9 @@ 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 @@ -434,14 +426,14 @@ 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 @@ -489,14 +481,14 @@ 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 @@ -540,14 +532,14 @@ 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 @@ -589,26 +581,26 @@ 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 1040384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 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 1040384 -HIGH_NUMBER_OF_BYTES_USED 1040384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 2 COUNT_FREE 1 @@ -623,14 +615,14 @@ HIGH_NUMBER_OF_BYTES_USED 272 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 4 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 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,6 +648,7 @@ 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 @@ -675,14 +667,14 @@ 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 @@ -699,14 +691,14 @@ 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 @@ -730,14 +722,14 @@ 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 @@ -756,14 +748,14 @@ 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 @@ -781,14 +773,14 @@ 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 @@ -805,14 +797,14 @@ 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 @@ -835,21 +827,21 @@ 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 3104768 -SUM_NUMBER_OF_BYTES_FREE 1040384 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2064384 -HIGH_NUMBER_OF_BYTES_USED 2064384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 @@ -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; @@ -905,14 +897,14 @@ 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 @@ -929,14 +921,14 @@ 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 @@ -960,14 +952,14 @@ 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 @@ -986,14 +978,14 @@ 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 @@ -1011,14 +1003,14 @@ 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 @@ -1035,14 +1027,14 @@ 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 @@ -1065,21 +1057,21 @@ 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 3104768 -SUM_NUMBER_OF_BYTES_FREE 1040384 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2064384 -HIGH_NUMBER_OF_BYTES_USED 2064384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 @@ -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,7 +1107,9 @@ 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 @@ -1134,14 +1128,14 @@ 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 @@ -1158,14 +1152,14 @@ 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 @@ -1211,14 +1205,14 @@ 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 @@ -1237,14 +1231,14 @@ 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 @@ -1288,14 +1282,14 @@ 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 @@ -1312,14 +1306,14 @@ 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 @@ -1366,21 +1360,21 @@ 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 3104768 -SUM_NUMBER_OF_BYTES_FREE 1040384 +COUNT_ALLOC 4 +COUNT_FREE 2 +SUM_NUMBER_OF_BYTES_ALLOC 65536 +SUM_NUMBER_OF_BYTES_FREE 32768 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 2064384 -HIGH_NUMBER_OF_BYTES_USED 2064384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 4 COUNT_FREE 2 @@ -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,6 +1424,7 @@ 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 @@ -1449,14 +1443,14 @@ 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 @@ -1473,14 +1467,14 @@ 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 @@ -1497,14 +1491,14 @@ 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; @@ -1526,14 +1520,14 @@ 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 @@ -1552,14 +1546,14 @@ 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 @@ -1578,14 +1572,14 @@ 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 @@ -1603,14 +1597,14 @@ 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 @@ -1627,14 +1621,14 @@ 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 @@ -1651,14 +1645,14 @@ 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 @@ -1676,26 +1670,26 @@ 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 3633152 -SUM_NUMBER_OF_BYTES_FREE 3104768 +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 65536 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 528384 -HIGH_NUMBER_OF_BYTES_USED 2064384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 @@ -1710,14 +1704,14 @@ HIGH_NUMBER_OF_BYTES_USED 816 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 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,7 +1727,10 @@ 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 @@ -1752,14 +1749,14 @@ 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 @@ -1776,14 +1773,14 @@ 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 @@ -1800,14 +1797,14 @@ 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 @@ -1851,14 +1848,14 @@ 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 @@ -1877,14 +1874,14 @@ 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 @@ -1903,14 +1900,14 @@ 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 @@ -1954,14 +1951,14 @@ 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 @@ -1978,14 +1975,14 @@ 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 @@ -2002,14 +1999,14 @@ 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 @@ -2051,26 +2048,26 @@ 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 3633152 -SUM_NUMBER_OF_BYTES_FREE 3104768 +COUNT_ALLOC 6 +COUNT_FREE 4 +SUM_NUMBER_OF_BYTES_ALLOC 98304 +SUM_NUMBER_OF_BYTES_FREE 65536 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 528384 -HIGH_NUMBER_OF_BYTES_USED 2064384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 6 COUNT_FREE 3 @@ -2085,14 +2082,14 @@ HIGH_NUMBER_OF_BYTES_USED 816 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 10 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 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,6 +2129,7 @@ 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 @@ -2150,14 +2148,14 @@ 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 @@ -2174,14 +2172,14 @@ 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 @@ -2198,14 +2196,14 @@ 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 @@ -2222,14 +2220,14 @@ 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 @@ -2249,14 +2247,14 @@ 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 @@ -2275,14 +2273,14 @@ 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 @@ -2301,14 +2299,14 @@ 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 @@ -2327,14 +2325,14 @@ 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 @@ -2352,14 +2350,14 @@ 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 @@ -2376,14 +2374,14 @@ 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 @@ -2400,14 +2398,14 @@ 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 @@ -2424,14 +2422,14 @@ 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 @@ -2449,26 +2447,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 5 @@ -2483,14 +2481,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 0 -SUM_NUMBER_OF_BYTES_ALLOC 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(); @@ -2529,14 +2530,14 @@ 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 @@ -2553,14 +2554,14 @@ 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 @@ -2577,14 +2578,14 @@ 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 @@ -2604,14 +2605,14 @@ 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 @@ -2630,14 +2631,14 @@ 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 @@ -2656,14 +2657,14 @@ 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 @@ -2682,14 +2683,14 @@ 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 @@ -2707,14 +2708,14 @@ 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 @@ -2731,14 +2732,14 @@ 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 @@ -2755,14 +2756,14 @@ 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 @@ -2779,14 +2780,14 @@ 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 @@ -2804,26 +2805,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 7 @@ -2838,14 +2839,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 6 -SUM_NUMBER_OF_BYTES_ALLOC 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(); @@ -2886,14 +2889,14 @@ 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 @@ -2910,14 +2913,14 @@ 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 @@ -2937,14 +2940,14 @@ 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 @@ -2963,14 +2966,14 @@ 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 @@ -2989,14 +2992,14 @@ 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 @@ -3015,14 +3018,14 @@ 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 @@ -3040,14 +3043,14 @@ 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 @@ -3064,14 +3067,14 @@ 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 @@ -3088,14 +3091,14 @@ 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 @@ -3112,14 +3115,14 @@ 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 @@ -3137,26 +3140,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 8 @@ -3171,14 +3174,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 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(); @@ -3221,14 +3226,14 @@ 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 @@ -3248,14 +3253,14 @@ 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 @@ -3274,14 +3279,14 @@ 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 @@ -3300,14 +3305,14 @@ 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 @@ -3326,14 +3331,14 @@ 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 @@ -3351,14 +3356,14 @@ 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 @@ -3375,14 +3380,14 @@ 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 @@ -3399,14 +3404,14 @@ 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 @@ -3423,14 +3428,14 @@ 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 @@ -3448,26 +3453,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 9 @@ -3482,14 +3487,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 12 -SUM_NUMBER_OF_BYTES_ALLOC 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(); @@ -3537,14 +3544,14 @@ 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 @@ -3563,14 +3570,14 @@ 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 @@ -3589,14 +3596,14 @@ 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 @@ -3615,14 +3622,14 @@ 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 @@ -3640,14 +3647,14 @@ 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 @@ -3664,14 +3671,14 @@ 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 @@ -3688,14 +3695,14 @@ 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 @@ -3712,14 +3719,14 @@ 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 @@ -3737,26 +3744,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 @@ -3771,14 +3778,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 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 ==================" @@ -3827,14 +3835,14 @@ 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 @@ -3853,14 +3861,14 @@ 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 @@ -3879,14 +3887,14 @@ 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 @@ -3905,14 +3913,14 @@ 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 @@ -3930,14 +3938,14 @@ 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 @@ -3954,14 +3962,14 @@ 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 @@ -3978,14 +3986,14 @@ 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 @@ -4002,14 +4010,14 @@ 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 @@ -4027,26 +4035,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 @@ -4061,14 +4069,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 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 @@ -4220,14 +4228,14 @@ 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 @@ -4244,14 +4252,14 @@ 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 @@ -4268,14 +4276,14 @@ 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 @@ -4292,14 +4300,14 @@ 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 @@ -4317,26 +4325,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 @@ -4351,14 +4359,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 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 @@ -4607,26 +4615,26 @@ 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 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 @@ -4641,14 +4649,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 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,26 +4905,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 12 -COUNT_FREE 9 -SUM_NUMBER_OF_BYTES_ALLOC 7745536 -SUM_NUMBER_OF_BYTES_FREE 3633152 +COUNT_ALLOC 8 +COUNT_FREE 6 +SUM_NUMBER_OF_BYTES_ALLOC 131072 +SUM_NUMBER_OF_BYTES_FREE 98304 LOW_COUNT_USED 0 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 LOW_NUMBER_OF_BYTES_USED 0 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 10 COUNT_FREE 10 @@ -4931,14 +4939,14 @@ HIGH_NUMBER_OF_BYTES_USED 1360 EVENT_NAME memory/sql/user_var_entry::value COUNT_ALLOC 16 COUNT_FREE 15 -SUM_NUMBER_OF_BYTES_ALLOC 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 4112384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4112384 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -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 4112384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4112384 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -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 4112384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4112384 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -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 4112384 +SUM_NUMBER_OF_BYTES_ALLOC 32768 SUM_NUMBER_OF_BYTES_FREE 0 -LOW_COUNT_USED 3 -CURRENT_COUNT_USED 3 -HIGH_COUNT_USED 3 -LOW_NUMBER_OF_BYTES_USED 4112384 -CURRENT_NUMBER_OF_BYTES_USED 4112384 -HIGH_NUMBER_OF_BYTES_USED 4112384 +LOW_COUNT_USED 2 +CURRENT_COUNT_USED 2 +HIGH_COUNT_USED 2 +LOW_NUMBER_OF_BYTES_USED 32768 +CURRENT_NUMBER_OF_BYTES_USED 32768 +HIGH_NUMBER_OF_BYTES_USED 32768 EVENT_NAME memory/sql/User_level_lock COUNT_ALLOC 0 COUNT_FREE 0 @@ -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. |