Learn about Centmin Mod LEMP Stack today
Become a Member

Beta Branch Help test innodbio.sh for MySQL Tuning

Discussion in 'Beta release code' started by eva2000, Feb 5, 2016.

  1. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    2:43 AM
    Nginx:1.11
    MariaDB-10
    Apart from this auto-setting, are there other 'tuning' actions we can do to optimise MariadB operation? I will use centminmod for a IPB forum soon, it has a database of about 800MByte and my VPS has 4GB RAM (could upgrade that to 8G if needed). I noticed that now 2G RAM is used for tmpfs (is this set by centminmod?) while only about 10% of it is in use. Would a large innodb buffer make Dbase operations faster for example ? Is this something we have to 'tune' ourself, or are you also tuning mysql settings according hardware setup like the setting you are testing in this topic ?
     
  2. eva2000

    eva2000 Administrator Staff Member

    43,012
    9,758
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,061
    Local Time:
    11:43 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    depends on OS, if it's CentOS 7 it's centos 7 default configured

    As to other settings, rest is up to you as there is PLENTY of mysql optimisations that can be done dependent on your mysql usage traffic patterns and mysql web app usage requirements. All are left to end user to to do. FYI, my paying clients have me to mysql specific server optimisation that can span anywhere between 4-30 days of work ! So there's alot you can do. Best to start own topic in Nginx, PHP-FPM & MariaDB MySQL | Centmin Mod Community but Centmin Mod is provided as is, so any recommendations are from other members and not me.

    I am just interesting some of the basic tuned base options for MariaDB with Centmin Mod stack dynamically tuned based on server settings environment alone and don't take into account specific hardware and other factors.