Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. [&]

The post Chunk Change: InnoDB Buffer Pool Resizing appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/19/chunk-change-innodb-buffer-pool-resizing/