News for hackers. Stuff that matters.

A comment on MySQL-Manage Memory Usage Efficiently.

Re:MySQL-Manage Memory Usage Efficiently by sgarland on Thursday April 11, 2024 @05:22PM (#40006961)
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...

[ Parent | on HN ]
Re:MySQL-Manage Memory Usage Efficiently by sjtly16 on Friday April 19, 2024 @03:01AM (#40084110)
Re: Calculates various parameters for the InnoDB buffer pool based on a simple input

Thanks for mentioning it, I will go through it.

[ Parent | on HN ]