mysql 缓存命中率计算_Innodb存储引擎的缓存命中率计算

数据库的慢查询是我们在生产环境中必须经常检测的，如果慢查询语句过多，说明我们应该增加buffer_pool的大小了。常常检查的指标就是查看缓存命中率是否过低。

mysql> show status like 'innodb_buffer_pool%';

+---------------------------------------+--------------------------------------------------+

| Variable_name | Value |

+---------------------------------------+--------------------------------------------------+

| Innodb_buffer_pool_dump_status | Dumping of buffer pool not started |

| Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 190107 7:19:16 |

| Innodb_buffer_pool_resize_status | |

| Innodb_buffer_pool_pages_data | 31732 |

| Innodb_buffer_pool_bytes_data | 519897088 |

| Innodb_buffer_pool_pages_dirty | 0 |

| Innodb_buffer_pool_bytes_dirty | 0 |

| Innodb_buffer_pool_pages_flushed | 1298499 |

| Innodb_buffer_pool_pages_free | 1024 |

|