I am not a dba but I have successfully tuned a couple of mysql/mariadb servers in the past with the help of Mysqltuner
MySQL-Manage Memory Usage Efficiently
11–12 of 12 posts
Re: MySQL-Manage Memory Usage Efficiently
#12Re: 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 absol…
Re: Calculates various parameters for the InnoDB buffer pool based on a simple input
Thanks for mentioning it, I will go through it.