mysqltuner problem

Discussion in 'Server Operation' started by concept21, Mar 25, 2022.

Tags:
  1. concept21

    concept21 Active Member HowtoForge Supporter

    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? :(
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    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.
     
    ahrasis likes this.

Share This Page