主页 / server / 问题 / 575685
Accepted
Josh
Asked: 2014-02-15 09:44:03 +0800 CST

MySQL InnoDB buffer_pool_size 不增加？

  • 772

日志文件中没有错误，但这似乎与我无关。也许我误解了一些东西：

mysql> show variables like '%buffer_pool%';
+-------------------------+-----------+
| Variable_name           | Value     |
+-------------------------+-----------+
| innodb_buffer_pool_size | 268435456 |
+-------------------------+-----------+
1 row in set (0.00 sec)

mysql> show innodb status\G
[...]
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 307469458; in additional pool allocated 1046016
Dictionary memory allocated 1258016
Buffer pool size   16384
Free buffers       10303
Database pages     5702
Modified db pages  30
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 2818, created 2884, written 659615
0.00 reads/s, 0.03 creates/s, 3.48 writes/s
Buffer pool hit rate 1000 / 1000

状态是否Buffer pool size与配置设置不同？我期待它们是相同的，或者非常接近......

mysql

1 个回答

  1. Best Answer

    我不是 MySQL 专家，但乍一看，变量innodb_buffer_pool_size以字节为单位，而下面的值以页为单位。默认 InnoDB 页面大小为 16KB，因此以字节为单位，您将获得相同的值：

    16384 * 16 * 1024 = 268435456
    • 1

相关问题