innodb_buffer_pool_size
- 默認(rèn)值:128MB
- 如果大于1G，建議拆分instance
- 配置官方說明
innodb_buffer_pool_instances=16
innodb_buffer_pool_size=2GB
調(diào)整為3GB
SET GLOBAL innodb_buffer_pool_size=3221225472;
因?yàn)?innodb_buffer_pool_chunk_size 默認(rèn)128MB
innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances =2GB
3GB不是2GB整數(shù)倍赞哗，所以自動(dòng)擴(kuò)展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
- 默認(rèn)值：128MB
- 可以動(dòng)態(tài)調(diào)整，注意宾茂，會(huì)引起 innodb_buffer_pool_size 變化
innodb_buffer_pool_instances
chunk_size 減少1MB 133169152
innodb_buffer_pool_size 也會(huì)調(diào)整
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 |
+------------------------------------------+
