mysql8.0.18 innodb_buffer_pool_size 配置文件

官方文档说明：
        Buffer pool size must always be equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances. If you alter the buffer pool size to a value that is not equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances, buffer pool size is automatically adjusted to a value that is equal to or a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances.
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html#sysvar_innodb_buffer_pool_size


大概意思就是，所设置的innodb_buffer_pool_size大小必须是innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances的倍数，如果不是的话，将会自动调整

Maskfanatics 发表于 2022-10-12 09:15
官方文档说明：
        Buffer pool size must always be equal to or a multiple of innodb_buffer_pool_ ...

是的，而且记得它是向上调整

my.cnf里用第二种方法设置就好，带M\G单位的那种，没必要搞那么精确（麻烦）