- 论坛徽章:
- 0
|
本帖最后由 cenalulu 于 2013-01-14 10:51 编辑
Innodb_buffer_pool_reads
The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk.
Innodb_pages_read
The number of pages read.
这2个变量是不同的,Innodb_pages_read 的值似乎一直大于Innodb_buffer_pool_reads,文档中对于Innodb_pages_read似乎介绍过于简单,这个状态变量代表什么? 如果也是一种逻辑到物理的读取,那么似乎innodb_buffer_pool_read_requests 应该等于Innodb_pages_read,
取线上的几台服务器的状态变量的值,发现:
Innodb_buffer_pool_read_requests > (much >) Innodb_pages_read > Innodb_buffer_pool_reads
疑问:innodb_buffer_pool_reads在文档中说的很清楚,我们可以通过它与innodb_buffer_pool_read_requests 计算innodb引擎的失配率,那么innodb_pages_read 代表的是什么?通过它我们能知道Innodb的什么状态信息?
|
|