首先了解三个参数三个参数:
innodb_buffer_pool_size(缓冲池大小)
innodb_buffer_pool_chunk_size(定义InnoDB缓冲池大小调整操作的块大小)
innodb_buffer_pool_instances(InnoDB 缓冲池划分为的区域数)
关于两个参数的关系,在MySQL8.0的官方文档中:
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