variable_name = 'innodb_buffer_pool_reads' Ĭapture innodb_buffer_pool_read_requests, innodb_buffer_pool_reads, Sleep 10 minutes, Run Query with Differences in innodb_buffer_pool_read_requests and innodb_buffer_pool_reads information_schema.GLOBAL_STATUS P1, variable_name = 'innodb_buffer_pool_read_requests'ĪND P2. SELECT SLEEP(600) INTO round ((P2.variable_value / P1.variable_value),4),įROM information_schema.GLOBAL_STATUS P1, ![]() ![]() There are two things you can do to get the Last 10 Minutes METHOD #1įlush all Status Values, Sleep 10 min, Run Query FLUSH STATUS ![]() ![]() That's the Hit Rate since Uptime (Last MySQL Startup)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |