What is the meaning of innodb_cache_usage_rate

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

What is the checkpoint innodb_cache_usage_rate exactly measuring with mysql probe?

Environment

Release:
Component: UIMMSQ

Resolution

The probe uses 'SHOW GLOBAL STATUS' to query MySQL properties and calculates innodb_cache_usage_rate as follows:

Innodb_buffer_pool_pages_free / Innodb_buffer_pool_pages_total

Additional Information

More information regarding the counters used can be found at the following address:

https://dev.mysql.com/doc/refman/5.6/en/server-status-variables.html