Stone Wiki

InnoDB Cache Hit Rate

Zeigt über den gesamten MySQL die InnoDB Cache Hit Rate an:

SELECT round ((P1.variable_value / (P1.variable_value + P2.variable_value))*100,2) Hitratio
FROM information_schema.GLOBAL_STATUS P1,
information_schema.GLOBAL_STATUS P2
WHERE P1. variable_name = 'innodb_buffer_pool_read_requests'
AND P2. variable_name = 'innodb_buffer_pool_reads';