DZone Database Zone
Chunk Change: InnoDB Buffer Pool Resizing
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, it could lead to undesired situations.
Let's see first how innodb_buffer_pool_size, innodb_buffer_pool_instances, and innodb_buffer_pool_chunk_size interact:
No comments:
Post a Comment