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