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