Learn about Centmin Mod LEMP Stack today
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,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    9:44 AM
    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

    50,891
    11,793
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,248
    Local Time:
    11:44 AM
    Nginx 1.25.x
    MariaDB 10.x
  3. rdan

    rdan Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    9:44 AM
    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,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    9:44 AM
    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

    50,891
    11,793
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,248
    Local Time:
    11:44 AM
    Nginx 1.25.x
    MariaDB 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 Well-Known Member

    5,426
    1,389
    113
    May 25, 2014
    Ratings:
    +2,172
    Local Time:
    9:44 AM
    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

    50,891
    11,793
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,248
    Local Time:
    11:44 AM
    Nginx 1.25.x
    MariaDB 10.x
    best is to test and see :)