Join the community today
Become a Member

Beta Branch update my.cnf templates [mysql] group defaults in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Sep 20, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    30,966
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    4:50 AM
    Nginx 1.13.x
    MariaDB 5.5
  2. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    8:50 PM
    1.9.10
    10.1.11
    Where to go
    config/mysql/my-mdb10-32gb.cnf
    config/mysql/my-mdb10-64gb.cnf
    config/mysql/my-mdb10-64gb-8c.cnf

    files?
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,966
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    4:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    what do you mean ? these are templates used when centmin.sh initially installs MariaDB for 1st time and it picks one based on your server resources available like memory available and copies it to /etc/my.cnf. But don't manually copy over especially for 123.09beta01 as MariaDB 10.1 defaults on that branch while 123.08stable uses MariaDB 10.0. The my.cnf are for MariaDB 10.0 only. When MariaDB 10.1 is used for 123.09beta01 additional MariaDB 10.1 specific settings are auto appended to the MariaDB 10.0 my.cnf templates for 10.1.
     
  4. negative

    negative Member

    217
    22
    18
    Apr 11, 2015
    Ratings:
    +50
    Local Time:
    8:50 PM
    1.9.10
    10.1.11
    I mekan that my server have 32gb memory for now and i m going to upgrade it to 64gb so i want use 64gb config anymore for better performance.

    My server has 2x intel e2620v4 cpu so for better performance, need to optimize mysql for new memory.

    I think and hope you should put a shell script file that upgrade memory to centmin for new nginx php mariadb configurations due ram upgrade.

    What is my way for now? Thanks
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,966
    6,919
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,422
    Local Time:
    4:50 AM
    Nginx 1.13.x
    MariaDB 5.5
    take your existing /etc/my.cnf and copy to your local pc and compare it with a 64gb my.cnf template that Centmin Mod providers and make adjustments for differences including [mariadb-10.1] auto appended group settings

    FYI, using 64gb template won't give more performance if mysql isn't needing, requiring or using more memory.