Want to subscribe to topics you're interested in?
Become a Member

MariaDB innodb_io_capacity

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

  1. rdan

    rdan Premium Member Premium Member

    4,414
    1,058
    113
    May 25, 2014
    Ratings:
    +1,541
    Local Time:
    1:36 PM
    Mainline
    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

    37,214
    8,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,514
    Local Time:
    3:36 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
  3. rdan

    rdan Premium Member Premium Member

    4,414
    1,058
    113
    May 25, 2014
    Ratings:
    +1,541
    Local Time:
    1:36 PM
    Mainline
    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. rdan

    rdan Premium Member Premium Member

    4,414
    1,058
    113
    May 25, 2014
    Ratings:
    +1,541
    Local Time:
    1:36 PM
    Mainline
    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

    37,214
    8,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,514
    Local Time:
    3:36 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    that's normal live in use != as not in use numbers as live has disk activity which reduces disk performance
     
  6. rdan

    rdan Premium Member Premium Member

    4,414
    1,058
    113
    May 25, 2014
    Ratings:
    +1,541
    Local Time:
    1:36 PM
    Mainline
    10.2
    Can you recommend a desirable value for innodb_io_capacity, on 3x300GB SSD with no Raid? :)
     
  7. eva2000

    eva2000 Administrator Staff Member

    37,214
    8,128
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +12,514
    Local Time:
    3:36 PM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    best is to test and see :)
     
..