Join the community today
Register Now

MariaDB innodb_io_capacity

Discussion in 'Centmin Mod Insights' started by RoldanLT, Jun 3, 2015.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    12:59 AM
    1.11
    10.2
    So how can I measure my "number of I/O operations per second that my system can handle"?
    With this command:
    dd if=/dev/zero of=test bs=64k count=16k conv=fdatasync
    I got an average of 400+ MB/s
     
  2. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    2:59 AM
    Nginx 1.13.x
    MariaDB 5.5
  3. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    12:59 AM
    1.11
    10.2
    I know I run that script before installing anything on the server, just forgot to post on the thread :D.
     
    Last edited: Jun 3, 2015
    • Like Like x 1
  4. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    12:59 AM
    1.11
    10.2
    But I got slow results now that the server is use for Live sites already.
    Do you still have access on your SYS E3-SSD3 server Eva?
    How much
    Do you get on it?
    Mostly it's the same SSD used on my OVH server.
     
  5. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    2:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    that's normal live in use != as not in use numbers as live has disk activity which reduces disk performance
     
  6. RoldanLT

    RoldanLT Well-Known Member

    3,899
    949
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,298
    Local Time:
    12:59 AM
    1.11
    10.2
    Can you recommend a desirable value for innodb_io_capacity, on 3x300GB SSD with no Raid? :)
     
  7. eva2000

    eva2000 Administrator Staff Member

    30,152
    6,782
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,133
    Local Time:
    2:59 AM
    Nginx 1.13.x
    MariaDB 5.5
    best is to test and see :)