Innodb状态不匹配的Innodb缓冲池大小变量和缓冲池大小 [英] Innodb buffer pool size variable and buffer pool size in innodb status mismatch

问题描述

我最近尝试将innodb缓冲池的大小增加到8GB，但是在我的innodb状态下，该池的大小看起来像它先前配置的值(在我的情况下为500MB).

I tried increasing the innodb buffer pool size to 8GB recently but in my innodb status the pool size looks like the previous value it was configured to (500MB in my case).

----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 9576946034; in additional pool allocated 19271936
**Buffer pool size   524288**
Free buffers       2
Database pages     508873
Modified db pages  5
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 443350, created 76998, written 683297
0.00 reads/s, 0.00 creates/s, 0.37 writes/s
Buffer pool hit rate 1000 / 1000

但这是innodb状态显示的内容，

But this is what innodb status shows,

mysql> show variables like 'innodb_%';
+---------------------------------+------------------------+
| Variable_name                   | Value                  |
+---------------------------------+------------------------+
| innodb_additional_mem_pool_size | 52428800               | 
| innodb_autoextend_increment     | 8                      | 
| innodb_buffer_pool_awe_mem_mb   | 0                      | 
| innodb_buffer_pool_size         | 8589934592             | 

有人可以让我知道造成这种差异的原因吗?

Could anybody please let me know what causes this difference?

推荐答案

您看错了数字.

已分配的总内存9576946034

Total memory allocated 9576946034

与您的innodb_buffer_pool_size设置:

InnoDB为缓冲区和控制结构保留了额外的内存，因此分配的总空间比指定的大小大约大10％.

InnoDB reserves additional memory for buffers and control structures, so that the total allocated space is approximately 10% greater than the specified size.

Buffer pool size是页面的数量.

这篇关于Innodb状态不匹配的Innodb缓冲池大小变量和缓冲池大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！