/ Register

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.

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

.