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 Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    11:32 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

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    1:32 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  3. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    11:32 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
  4. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    11:32 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

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    1:32 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    that's normal live in use != as not in use numbers as live has disk activity which reduces disk performance
     
  6. rdan

    rdan Well-Known Member

    5,449
    1,410
    113
    May 25, 2014
    Ratings:
    +2,204
    Local Time:
    11:32 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

    55,155
    12,249
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,825
    Local Time:
    1:32 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    best is to test and see :)