Items tagged with: mariadb
This Thursday at 20.00 CEST: Codeberg Contributor Meeting about
#Databases at Codeberg.
Feel free to join us to learn more about our voluntary contributors, our systems, and potentially how you can get involved.
Since a few days sometimes my #mariadb load spikes to 140, anyone else see this, it just takes 1 minute and normalizes again. till now I was to slow to capture the mytop view, just the end of such thing in this capture.
When it is over the load normalizes at 0.8 again.
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.