/ Register

Welcome to Centmin Mod Community
Become a Member

MariaDB Which my.cnf template to choose?

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

Previous Thread Next Thread
Loading...
  1. Jun 18, 2016 #1
    Oxide

    Oxide Active Member

    534
    29
    28
    Mar 19, 2015
    Ratings:
    +59
    Local Time:
    2:41 PM
  2. Jun 18, 2016 #2
    eva2000

    eva2000 Administrator Staff Member

    55,237
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    2:41 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Jun 18, 2016 #3
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    5:41 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?
     
  4. Jun 18, 2016 #4
    Oxide

    Oxide Active Member

    534
    29
    28
    Mar 19, 2015
    Ratings:
    +59
    Local Time:
    2:41 PM
    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. Jun 18, 2016 #5
    Oxide

    Oxide Active Member

    534
    29
    28
    Mar 19, 2015
    Ratings:
    +59
    Local Time:
    2:41 PM
    Do you have plants for sitebackup.sh? I just tested out dbbackup.sh it's excellent :)
     
  6. Jun 18, 2016 #6
    eva2000

    eva2000 Administrator Staff Member

    55,237
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    2:41 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yes working on that in my spare time to extend dbbackup.sh for files too :)
     
  7. Jun 18, 2016 #7
    Revenge

    Revenge Active Member

    469
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +354
    Local Time:
    5:41 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
     
Previous Thread Next Thread
Loading...

.