innodb_buffer_pool_instances : InnoDB 缓冲池划分为的区域数
默认值为:1
innodb_buffer_pool_instances 是在缓冲池初始化时自动计算得到的
最小值:1
最大值: 64
当innodb_buffer_pool_size < 1G 时,innodb_buffer_pool_instances = 1
当innodb_buffer_pool_size>= 1G 时,innodb_buffer_pool_instances = 8
参数 innodb_buffer_pool_size / innodb_buffer_pool_chunk_size
为避免潜在的性能问题,块数 (innodb_buffer_pool_size / innodb_buffer_pool_chunk_size) 不应超过 1000。
Note
To avoid potential performance issues, the number of chunks (innodb_buffer_pool_size
innodb_buffer_pool_chunk_size) should not exceed 1000.