/ Register

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.

Tags:
Previous Thread Next Thread
Loading...
  1. 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. Jun 3, 2015 #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. Jun 3, 2015 #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. 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. Jun 3, 2015 #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. Jun 3, 2015 #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. Jun 3, 2015 #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 :)
     
Previous Thread Next Thread
Loading...

.