DB1 MySQL - hit-ratio 1. MyIsam key buffer hit ratio = 1 - ( key_reads / key_read_requests ) using a SQL statement in mysql 5.1: SELECT 1- round ((P2.variable_value / P1.variable_value),4) , P2.variable_value, P1.variable_value FROM information_schema.GLOBAL_STATUS P1,information_schema.GLOBAL_STATUS P2 WHERE P1. variable_name = 'key_read_requests' AND P2. variable_name = 'key_reads'; perc_full_table_scans perc_full_.. 2019. 12. 6. 이전 1 다음
