mysql> SHOW GLOBAL STATUS LIKE 'innodb%read%';
+---------------------------------------+---------+
| Variable_name | Value |
+---------------------------------------+---------+
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 612 |
| Innodb_buffer_pool_reads | 179 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_read | 5115904 |
| Innodb_data_reads | 189 |
| Innodb_pages_read | 178 |
| Innodb_rows_read | 0 |
+---------------------------------------+---------+
10 rows in set (0.00 sec) #多核CPU
innodb_read_io_threads
innodb_write_io_threads #内存
缓冲池命中率=
Innodb_buffer_pool_read_requests/(
Innodb_buffer_pool_read_requests+Innodb_buffer_pool_read_ahead+Innodb_buffer_pool_reads)
平均每次读取字节数
Innodb_data_read/Innodb_data_reads Innodb_data_reads:表示从物理磁盘读取页的次数
Innodb_buffer_pool_read_ahead：预读的次数
Innodb_buffer_pool_read_ahead_evicted：预读的页，但是没有被读取就从缓冲池中被替换的页的数量，一般用来判断预读的频率
Innodb_buffer_pool_read_requests：从缓冲池中读取页的次数
Innodb_data_read：一共读取的字节数
Innodb_data_reads：发起读取请求的次数，每次读取可能需要读取多个页