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