Welcome to Centmin Mod Community
Become a Member

MariaDB my.cnf why is it differ much after install and your template?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by rdan, Jan 25, 2019.

  1. rdan

    rdan Well-Known Member

    4,992
    1,191
    113
    May 25, 2014
    Ratings:
    +1,813
    Local Time:
    9:24 PM
    Mainline
    10.2
  2. eva2000

    eva2000 Administrator Staff Member

    45,462
    10,318
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,003
    Local Time:
    11:24 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Centmin Mod 123.09beta01 and higher will install the base template, then dynamically update it to auto optimize it for server environment it detects etc. So different servers may end up with different /etc/my.cnf settings
     
  3. rdan

    rdan Well-Known Member

    4,992
    1,191
    113
    May 25, 2014
    Ratings:
    +1,813
    Local Time:
    9:24 PM
    Mainline
    10.2
    I messed up my OVH my.cnf, as I uploaded wrong/old file.

    So I'm trying to revert it without re-installing the whole server.

    Does an OVH Dedicated Server differ on a VPS with same RAM and total CPU in terms of my.cnf auto optimize?

    Thanks!
     
  4. rdan

    rdan Well-Known Member

    4,992
    1,191
    113
    May 25, 2014
    Ratings:
    +1,813
    Local Time:
    9:24 PM
    Mainline
    10.2
    As I can see, base template vs new install, this value was missing:
    Any reason for this?
    Thanks!
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,462
    10,318
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,003
    Local Time:
    11:24 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    It may as Centmin Mod auto optimisation routine also measures disk I/O performance and adjusts settings appropriately for your disk speeds.

    You may have some backed up /etc/my.cnf when centmin mod initially installed your server - so I'd check those files to make sure if one doesn't have the rest of your my.cnf settings first though you maybe missing the changes auto applied on updates.
    Code (Text):
    ls -lahrt /etc/ | grep my.
    -rw-r--r--.  1 root  root  202 Feb  4 02:30 my.cnf.rpmnew
    -rw-r--r--.  1 root  root  570 Mar 11 16:11 my.cnf-original
    -rw-r--r--.  1 root  root 4.0K Mar 11 16:11 my.cnf-newold
    drwxr-xr-x.  2 root  root 4.0K Mar 11 16:13 my.cnf.d
    -rw-r--r--.  1 root  root 5.1K Mar 11 16:13 my.cnf-setiobackup
    -rw-r--r--.  1 root  root 5.1K Mar 12 16:24 my.cnf
    

    • my.cnf-original is one before centmin mod install
    • my.cnf-newold is one after mariadb initial version or upgraded version was installed before centmin mod applied settings
    • my.cnf-setiobackup is one before tools/setio.sh runs to optimise mysql disk related variable settings
    • my.cnf existing live /etc/my.cnf
     
  6. eva2000

    eva2000 Administrator Staff Member

    45,462
    10,318
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,003
    Local Time:
    11:24 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    MariaDB 10.3 will have totally different defaults for those settings compared to MariaDB 10.0/10.1/10.2
     
  7. rdan

    rdan Well-Known Member

    4,992
    1,191
    113
    May 25, 2014
    Ratings:
    +1,813
    Local Time:
    9:24 PM
    Mainline
    10.2
    Ah it was removed on 10.3.1.
     
  8. eva2000

    eva2000 Administrator Staff Member

    45,462
    10,318
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,003
    Local Time:
    11:24 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    yes some settings in MariaDB 10.3 are either deprecated or set to default so not required in /etc/my.cnf