innodb_buffer_pool_size
- 默认值:128MB
- 如果大于1G，建议拆分instance
- 配置官方说明
innodb_buffer_pool_instances=16
innodb_buffer_pool_size=2GB
调整为3GB
SET GLOBAL innodb_buffer_pool_size=3221225472;
因为 innodb_buffer_pool_chunk_size 默认128MB
innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances =2GB
3GB不是2GB整数倍，所以自动扩展pool_size为4GB
SELECT @@innodb_buffer_pool_size/1024/1024/1024;
+------------------------------------------+
| @@innodb_buffer_pool_size/1024/1024/1024 |
+------------------------------------------+
| 4.000000000000 |
+------------------------------------------+
innodb_buffer_pool_chunk_size
- 默认值：128MB
- 可以动态调整，注意，会引起 innodb_buffer_pool_size 变化
innodb_buffer_pool_instances
chunk_size 减少1MB 133169152
innodb_buffer_pool_size 也会调整
innodb_buffer_pool_instances=16
innodb_buffer_pool_size=2GB
innodb_buffer_pool_chunk_size =133169152
mysql> SELECT @@innodb_buffer_pool_size/1024/1024/1024;
+------------------------------------------+
| @@innodb_buffer_pool_size/1024/1024/1024 |
+------------------------------------------+
| 3.968750000000 |
+------------------------------------------+
