Discover Centmin Mod today
Register Now

Beta Branch update tools/setio.sh in 123.09beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Dec 21, 2019.

  1. eva2000

    eva2000 Administrator Staff Member

    43,121
    9,788
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,114
    Local Time:
    12:41 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
  2. pamamolf

    pamamolf Premium Member Premium Member

    3,697
    357
    83
    May 31, 2014
    Ratings:
    +688
    Local Time:
    4:41 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Should we run this manually?
    Code:
    /usr/local/src/centminmod/tools/setio.sh set
    Restart MariaDB after that?
     
    Last edited: Dec 21, 2019
  3. eva2000

    eva2000 Administrator Staff Member

    43,121
    9,788
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,114
    Local Time:
    12:41 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    Yeah if you want to run with setio.sh's updated formula
     
  4. pamamolf

    pamamolf Premium Member Premium Member

    3,697
    357
    83
    May 31, 2014
    Ratings:
    +688
    Local Time:
    4:41 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    Is the new formula producing higher values or lower in general cases?

    I got confused from the old and new calculation formula....

    In my case i am getting much lower values:

    Code:
    Variable_name   Value
    innodb_io_capacity      2900
    innodb_io_capacity_max  5800
    new value:

    Code:
    Variable_name   Value
    innodb_io_capacity      2000
    innodb_io_capacity_max  3333
    
     
  5. rdan

    rdan Well-Known Member

    4,856
    1,160
    113
    May 25, 2014
    Ratings:
    +1,740
    Local Time:
    10:41 AM
    Mainline
    10.2
    For innodb_io_capacity/max, I think for you to have an accurate result...
    Stop all other services like Nginx/PHP/Redis/Memcached except MariaDB then run that script so no other activity on the Disk.
     
  6. pamamolf

    pamamolf Premium Member Premium Member

    3,697
    357
    83
    May 31, 2014
    Ratings:
    +688
    Local Time:
    4:41 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    No traffic at all on the test server....Ok thanks !
     
  7. eva2000

    eva2000 Administrator Staff Member

    43,121
    9,788
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,114
    Local Time:
    12:41 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    It's meant to produce lower values on new formula as intended :) Too high values cause excessive InnoDB page flushing.
     
  8. pamamolf

    pamamolf Premium Member Premium Member

    3,697
    357
    83
    May 31, 2014
    Ratings:
    +688
    Local Time:
    4:41 AM
    Nginx-1.17.x
    MariaDB 10.3.x
    I thought that the higher number there the higher performance we will get....
     
  9. eva2000

    eva2000 Administrator Staff Member

    43,121
    9,788
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,114
    Local Time:
    12:41 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    too high = not too good, too low = not too good :)

    probably could lower it some more
     
    • Informative Informative x 1