I have set innodb_buffer_pool_size=100G and instances to 8, but I am getting following output
mysql> show engine innodb status \G ---BUFFER POOL 6 Buffer pool size 835482
I have been reading online that
bufferpool= innodb_buffer_pool_chunk_size* innodb_buffer_pool_instances.
This is confusing, should we set the default chunk size to higher values and increasing the number of instances do not cause contention anymore.
Can anyone advise on correct parameters for 100GB bufferpool size?