Items tagged with: mysql
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.
I am not a programmer and I am not sure what it means that the compatibility was dropped with release 8.x, I was just looking at it because someone here asked if he can switch from MySQL to MariaDB and it turned out it is not as easy anymore starting from 8.x, the person in that case was still on 5.x, so maybe at that point the move would still be possible easily.
Also interesting that Ubuntu offers MySQL, or that Digital Ocean baked their own thing there and there was no choice if you need MySQL or MariaDB, especially if the two are not compatible anymore.
Maybe if you open the issue on Github mention the installation help that you used and raise the question if MariaDB should be the preferred DB or if still both are equal in the regard of support. Just to make devs aware of the problem.
Here is a lists that shows there is no compatible version.