Join the community today
Register Now

Beta Branch update tools/setio.sh use local ffio settings files

Discussion in 'Centmin Mod Github Commits' started by eva2000, Mar 12, 2016.

  1. eva2000

    eva2000 Administrator Staff Member

    45,662
    10,361
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,080
    Local Time:
    7:21 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    nice and fast NVMe SSD disks I see :D
     
  2. rdan

    rdan Well-Known Member

    5,008
    1,209
    113
    May 25, 2014
    Ratings:
    +1,835
    Local Time:
    5:21 AM
    Mainline
    10.2
    setpurgethreads doesn't applied for 10.3, Why?
     
  3. eva2000

    eva2000 Administrator Staff Member

    45,662
    10,361
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,080
    Local Time:
    7:21 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    ah it only was written for MariaDB 10.0 and 10.1 at the time so guess need an update :)

    MariaDB 10.3 on 123.09beta01 currently
    Code (Text):
    tools/setio.sh set
    Full Reads: 50257
    Full Writes: 38102
    
    set innodb_flush_neighbors = 0
    
    innodb_io_capacity = 2700
    
    +------------------------+-------+
    /etc/my.cnf adjustment
    +------------------------+-------+
    existing value: 
    Variable_name   Value
    innodb_io_capacity      2300
    innodb_io_capacity_max  4600
    new value: 
    Variable_name   Value
    innodb_io_capacity      2700
    innodb_io_capacity_max  5400
    
    +------------------------+-------+
    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
    
     
  4. rdan

    rdan Well-Known Member

    5,008
    1,209
    113
    May 25, 2014
    Ratings:
    +1,835
    Local Time:
    5:21 AM
    Mainline
    10.2
    innodb_thread_concurrency is also optimize but commented out by default?
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,662
    10,361
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,080
    Local Time:
    7:21 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    yup that is intentional in the code but i should make it enabled
     
  6. eva2000

    eva2000 Administrator Staff Member

    45,662
    10,361
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,080
    Local Time:
    7:21 AM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    FYI, setio.sh script enables proper value dynamically anyway until mysql restarts
    Code (Text):
    grep innodb_thread_concurrency /etc/my.cnf
    #innodb_thread_concurrency = 8
    

    check actual value after setio.sh run
    Code (Text):
    mysqladmin var | grep innodb_thread_concurrency | tr -s ' '
    | innodb_thread_concurrency | 8 |