200
innodb 命中率评估
innodb 内存评估原则
mysql> show global status like 'innodb%read%';
+---------------------------------------+------------+
| Variable_name | Value |
+---------------------------------------+------------+
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 246 | 利用后台线程从 innodb buffer 中预读的次数
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 4715675354 | 从 innodb buffer 中产生的数据读次数
| Innodb_buffer_pool_reads | 1378 | 从物理磁盘中读数据到 innodb buffer 次数
| Innodb_data_pending_reads | 0 |
| Innodb_data_read | 28790784 | 读书字节数
| Innodb_data_reads | 1400 | 读取请求数（一次可能读入多页）
| Innodb_pages_read | 1623 |
| Innodb_rows_read | 4655914819 |
+---------------------------------------+------------+
10 rows in set (0.01 sec)
innodb_buffer_pool_read_requests
命中率 =-------------------------------------------------------------------------------------------------
(innodb_bufer_pool_read_requests + innodb_buffer_pool_read_ahead + innodb_buffer_pool_reads )
4715675354
命中率 = ---------------------------- = 99.99% 约接近 1 越好 (证明内存足够)
4715675354 + 246 + 1378
最后更新：2017-04-03 14:53:53