Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB Which my.cnf template to choose?

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Oxide, Jun 18, 2016.

  1. Oxide

    Oxide Active Member

    502
    29
    28
    Mar 19, 2015
    Ratings:
    +54
    Local Time:
    10:38 AM
  2. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    10:38 AM
    Nginx 1.13.x
    MariaDB 5.5
    You should monitor stats and adjust according to your web applications usage requirments. Check out my mysqlmymonlite.sh addon for gathering existing memory and server stats at mysqlmymonlite.sh Addon | Centmin Mod Community

    But yes start with 32GB template - though these are auto chosen at initial Centmin Mod LEMP stack install time based on detected server resources available.
     
  3. Revenge

    Revenge Active Member

    287
    64
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +227
    Local Time:
    1:38 AM
    1.9.x
    10.1.x
    @Oxide i also run a IPS forum. I have optimized mine to run with IPS and i think i found the best values for it.
    Can you post here the output of mysqltuner and i will try to help you?
     
    • Like Like x 1
  4. Oxide

    Oxide Active Member

    502
    29
    28
    Mar 19, 2015
    Ratings:
    +54
    Local Time:
    10:38 AM
    Yes, trying to find out where it is.

    And this is a freshly installed server that currently has maintenance mode on, would that matter? lol
     
  5. Oxide

    Oxide Active Member

    502
    29
    28
    Mar 19, 2015
    Ratings:
    +54
    Local Time:
    10:38 AM
    Do you have plants for sitebackup.sh? I just tested out dbbackup.sh it's excellent :)
     
    • Like Like x 1
  6. eva2000

    eva2000 Administrator Staff Member

    29,035
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,784
    Local Time:
    10:38 AM
    Nginx 1.13.x
    MariaDB 5.5
    yes working on that in my spare time to extend dbbackup.sh for files too :)
     
  7. Revenge

    Revenge Active Member

    287
    64
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +227
    Local Time:
    1:38 AM
    1.9.x
    10.1.x
    I don't think so. You can use my values adapted for your Database and the requests you expecting to receive. If you post here mysqltuner output, it will be more easy.

    MariaDB 10.1.14 response time of my site:
    [​IMG]
    It will not be easy to improve it further :D
     
    • Agree Agree x 1