Welcome to Centmin Mod Community
Become a Member

Beta Branch move setio.sh routine for initial installs

Discussion in 'Centmin Mod Github Commits' started by eva2000, Feb 7, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    55,247
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    8:53 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    move setio.sh routine for initial installs

    Initial centmin mod installs involve stopping mariadb mysql server and the setio.sh routine was placed after the service stop so couldn't run without mysql server running. So moved the setio.sh routine to before service stop.

    Continue reading...


    123.09beta01 branch
     
  2. eva2000

    eva2000 Administrator Staff Member

    55,247
    12,253
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,833
    Local Time:
    8:53 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    fresh 123.09beta01 install checking setio.sh and confirming it works on initial MariaDB 10.0 install routine
    Code:
    systemctl stop mysql.service
    systemctl start mysql.service
    Full Reads: 13342
    Full Writes: 11115
    innodb_io_capacity = 1100
    
    +------------------------+-------+
    /etc/my.cnf adjustment
    +------------------------+-------+
    existing value:
    Variable_name   Value
    innodb_io_capacity      200
    innodb_io_capacity_max  2000
    new value:
    Variable_name   Value
    innodb_io_capacity      1100
    innodb_io_capacity_max  2200
    
    +------------------------+-------+
    innodb io threads adjustment
    +------------------------+-------+
    existing value:
    +------------------------+-------+
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    +------------------------+-------+
    new value:
    +------------------------+-------+
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    +------------------------+-------+
    
    Restart MySQL server for io thread changes
    
    *************************************************
    * MariaDB installed
    *************************************************