Dear MariaDB expects, I tried mysqltuner the first time on my ISPConfig 3.2.7, Ubuntu 20.04 OS. I improved my MariaDB according to mysqltuner suggestions. The last one configuration it wants me to improve is: I started from tmp_table_size = 16M max_heap_table_size = 16M up to tmp_table_size = 128M max_heap_table_size = 128M and it still ask me to increase memory What should I do then?
Mysqltuner suggest things. They are not always optimal or better values. You would need to run benchmarks to compare the new values to old, if there is any benefit. Or benefit worth the increased use of memory or other resources.
