Get the App
SLTechnology News&Howtos  ›  Database  › 

[MySQL] Monitoring item-- innodb_buffer_pool hit rate calculation

Shulou Source: shulou.com Published: 2022-06-01 05:16:37 09月30日 Update

Innodb buffer Hit ratios calculation:

innodb_buffer_read_hits=(1-Innodb_buffer_pool_reads/Innodb_buffer_pool_read_requests) * 100%

If innodb_buffer_pool hit rate is used as a monitoring item, it is recommended to set 90% as the trigger value. If it is lower than 90%, consider increasing innodb_buffer_pool_size.

The following is taken from 5.6 Official Manual:

Tags: Hit rate surveillance official advice manual Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker Xiaomi Microsoft vpn NVidia