Get the most out of your Centmin Mod LEMP stack
Become a Member

Beta Branch update my.cnf templates & tools/setio.sh in 123.09beta01

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

  1. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    4:37 PM
    Nginx 1.13.x
    MariaDB 5.5
    update my.cnf templates & tools/setio.sh in 123.09beta01

    Updated to support Centmin Mod auto tuning of MariaDB MySQL variables for innodb_flush_neighbors in MariaDB 10.0/10.1 and innodb_flush_neighbor_pages in MariaDB 5.5. When tools/setio.sh which is run on initial MariaDB install detects that measured disk I/O reads is greater than 500 IOPs, set the the variable appropriately to = 0 for greater than or equal to 500 IOPs or leave or set it to = 1 when disk I/O writes is less than 500 IOPs. The threshold is 500 IOPs as still some non-SSD raid configurations can reach that performance level. There's no need to restart MySQL with this auto set changes as the variable is a dynamic variable in MariaDB MySQL. All MariaDB 10 labelled (my-mdb10-*) my.cnf templates default to = 1 value for the variable and is then auto changed at initial MariaDB MySQL install time when tools/setio.sh is ran.

    example

    Code (Text):
    ./setio.sh set
    Full Reads: 34711
    Full Writes: 7585
    
    set innodb_flush_neighbors = 0
    
    innodb_io_capacity = 900
    
    +------------------------+-------+
    /etc/my.cnf adjustment
    +------------------------+-------+
    existing value:
    Variable_name   Value
    innodb_io_capacity      100
    innodb_io_capacity_max  132
    new value:
    Variable_name   Value
    innodb_io_capacity      900
    innodb_io_capacity_max  1800
    
    +------------------------+-------+
    innodb io threads adjustment
    +------------------------+-------+
    existing value:
    +------------------------+-------+
    innodb_read_io_threads = 4
    innodb_write_io_threads = 2
    +------------------------+-------+
    new value:
    +------------------------+-------+
    innodb_read_io_threads = 4
    innodb_write_io_threads = 4
    +------------------------+-------+
    
    Restart MySQL server for io thread changes
    


    Continue reading...

    123.09beta01 branch
     
    Last edited: Sep 21, 2016
    • Like Like x 3
  2. eva2000

    eva2000 Administrator Staff Member

    30,168
    6,784
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,136
    Local Time:
    4:37 PM
    Nginx 1.13.x
    MariaDB 5.5