I know two ways of calculating InnoDB Buffer Hit ratio.
One is by looking at output of “SHOW ENGINE INNODB STATUS\G;” command.
Other way is by using the following formula:
Innodb Buffer Pool Hit Ratio = Innodb_buffer_pool_read_requests / (Innodb_buffer_pool_read_requests + Innodb_buffer_pool_reads) * 100
But I cannot put it is monitoring screens of Grafana. Can anybody help me how get these values populated into Grafana monitoring screens.
Please let me know if you need further information from my side.
Thanks and Regards,