mysqltuner.pl wants me to set "innodb_buffer_pool_size (>= 20.7G)", which is probably because of the #database
size. I assigned 20 GB #RAM
to the VM and have 20 GB #SWAP
too. So setting it that high is not possible, as this would bring the total max #memory
usage way beyond 40 GB.
1. Why is the total max usage higher than this setting? What is the multiplicand parameter?
2. Any idea how I can set this to use 16 GB for #MySQL
all the time, allow double in peak and (swapping then) and not more?
I think I will change the setup at some point which will free more RAM for #mariadb
, but now I need to cope with it like it is. I see loading time it really bad with low settings for "innodb_buffer_pool_size", like 0.4 seconds over all, more RAM reduces it by 70%... but then I get omm (out of memory) problem.