Get the App
SLTechnology News&Howtos  ›  Database  › 

Calculate the hit rate and utilization rate of mysql buffer

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

MyISAM Key buffer hit rate:

(Key_reads * 100) / Key_read_requests)

Utilization of MyISAM Key buffer:

(Key_blocks_unused * key_cache_block_size) * 100 / key_buffer_size)

The hit rate of InnoDB Buffer Pool

(Innodb_buffer_pool_read_requests-Innodb_buffer_pool_reads) / Innodb_buffer_pool_read_requests * 100% [@ more@]

Tags: Hit rate Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Tech Info Shulou Technology Xiaomi Shulou Information MariaDB