What is the use of innodb cache hit ratio?

This article mainly introduces "what is the use of innodb cache hit rate". In daily operations, I believe that many people have doubts about the use of innodb cache hit rate. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the question of "what is the use of innodb cache hit rate?" Next, please follow the editor to study!

1. Query in the MYSQL client: show global status like 'innodb%read%'

2. Wait for a period of time (5 or 10 minutes)

3. Query again on the MYSQL client: show global status like 'innodb%read%'

4. Use the following formula to calculate the memory hit ratio:

Innodb_buffer_pool_read_requests difference between two queries

/ (innodb_buffer_pool_read_requests difference between two queries

+ innodb_buffer_pool_read_ahead difference of two queries

+ innodb_buffer_pool_reads difference of two queries)

Innodb_buffer_pool_read_ahead

The number of pages read into the InnoDB buffer pool by the read-ahead background thread.

Innodb_buffer_pool_read_requests

The number of logical read requests.

Innodb_buffer_pool_reads

The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk.

At this point, the study on "what is the use of innodb cache hit rate" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!