[sgarland]

Re: online buffer pool resizing, it’s important to note that you can only resize in multiples of innodb_buffer_pool_chunk_size, and the resulting size must be a multiple of innodb_buffer_pool_chunk_size * innodb_buffer_pool_instances.

Because of this and other complications / desired optimizations, I wrote a script [0] to calculate the necessary parameters, given either a desired percentage of system RAM, or an absolute size.

[0]: https://gist.github.com/stephanGarland/cd6a5c667e8406cf9cfb6...

[sjtly16]

Re: Calculates various parameters for the InnoDB buffer pool based on a simple input

Thanks for mentioning it, I will go through it.