Welcome to Centmin Mod Community
Become a Member

Beta Branch Help test innodbio.sh for MySQL Tuning

Discussion in 'Beta release code' started by eva2000, Feb 5, 2016.

  1. Ahmad

    Ahmad Active Member

    209
    80
    28
    Apr 13, 2015
    Ratings:
    +150
    Local Time:
    4:39 AM
    1.9.9
    10.1.10
    Reliable Dedicated server Int. Xeon E3 1240v5//16GB//SSD
    Code:
    root@server ~]# curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    -----------------------------------
    ioping calculated
    -----------------------------------
    19 change to 100
    innodb_io_capacity = 100
    19 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    innodb_io_capacity = 144
    38 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    38 change to 100
    innodb_io_capacity = 100
    30 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    
    -----------------------------------
    fio calculated
    -----------------------------------
    
    Full Reads: 30796
    Full Writes: 19598
    innodb_io_capacity = 391
    innodb_io_capacity = 279
    innodb_io_capacity = 217
    innodb_io_capacity = 178
    
    Full Reads: 30453
    Full Writes: 19366
    innodb_io_capacity = 387
    innodb_io_capacity = 276
    innodb_io_capacity = 215
    innodb_io_capacity = 176
    
    -----------------------------------
    innodb_read_io_threads = 4
    innodb_write_io_threads = 4
    -----------------------------------
    RamNode 2GB Premium
    Code:
    [root@server ~]# curl -sL [URL]https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh[/URL] | bash
    
    -----------------------------------
    ioping calculated
    -----------------------------------
    innodb_io_capacity = 444
    innodb_io_capacity = 384
    -----------------------------------
    innodb_io_capacity = 825
    innodb_io_capacity = 700
    -----------------------------------
    innodb_io_capacity = 644
    innodb_io_capacity = 643
    -----------------------------------
    
    -----------------------------------
    fio calculated
    -----------------------------------
    
    Full Reads: 54251
    Full Writes: 40354
    innodb_io_capacity = 807
    innodb_io_capacity = 576
    innodb_io_capacity = 448
    innodb_io_capacity = 366
    
    Full Reads: 35310
    Full Writes: 42010
    innodb_io_capacity = 840
    innodb_io_capacity = 600
    innodb_io_capacity = 466
    innodb_io_capacity = 381
    
    -----------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    -----------------------------------

     
  2. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    4:39 AM
    Nginx:1.11
    MariaDB-10
    VPS 4GB 2xXeon SSD, server is idle and not optimized just default cenminmod install and test forum (IPB).

    I have 14 error-messages first all like:
    Code:
    ioping: invalid option -- 'B'
    Usage: ioping [-LCDRq] [-c count] [-w deadline] [-p period] [-i interval]
                   [-s size] [-S wsize] [-o offset] device|file|directory
            ioping -h | -v
    
          -c <count>      stop after <count> requests
          -w <deadline>   stop after <deadline>
          -p <period>     print raw statistics for every <period> requests
          -i <interval>   interval between requests (1s)
          -s <size>       request size (4k)
          -S <wsize>      working set size (1m)
          -o <offset>     in file offset
          -L              use sequential operations (includes -s 256k)
          -C              use cached I/O
          -D              use direct I/O
          -R              seek rate test (same as -q -i 0 -w 3 -S 64m)
          -q              suppress human-readable output
          -h              display this message and exit
          -v              display version and exit
    
    
    Normal output is:
    Code:
    -----------------------------------
    ioping calculated
    -----------------------------------
    0 change to 100
    innodb_io_capacity = 100
    0 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    0 change to 100
    innodb_io_capacity = 100
    0 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    0 change to 100
    innodb_io_capacity = 100
    0 change to 100
    innodb_io_capacity = 100
    -----------------------------------
    
    -----------------------------------
    fio calculated
    -----------------------------------
    
    Full Reads: 3655
    Full Writes: 2578
    innodb_io_capacity = 51
    innodb_io_capacity = 36
    innodb_io_capacity = 28
    innodb_io_capacity = 23
    innodb_io_capacity = 85
    
    Full Reads: 3653
    Full Writes: 2579
    innodb_io_capacity = 51
    innodb_io_capacity = 36
    innodb_io_capacity = 28
    innodb_io_capacity = 23
    innodb_io_capacity = 85
    
    -----------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    -----------------------------------
    
     
    Last edited: Feb 5, 2016
  3. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    thanks @SeaTea looks like you have an older version of ioping

    Code:
    ioping -h
    Usage: ioping [-LABCDWRq] [-c count] [-w deadline] [-pP period] [-i interval]
                   [-s size] [-S wsize] [-o offset] directory|file|device
            ioping -h | -v
    
          -c <count>      stop after <count> requests
          -w <deadline>   stop after <deadline>
          -p <period>     print raw statistics for every <period> requests
          -P <period>     print raw statistics for every <period> in time
          -i <interval>   interval between requests (1s)
          -s <size>       request size (4k)
          -S <wsize>      working set size (1m)
          -o <offset>     working set offset (0)
          -L              use sequential operations (includes -s 256k)
          -A              use asynchronous I/O
          -C              use cached I/O
          -D              use direct I/O
          -W              use write I/O *DANGEROUS*
          -R              seek rate test (same as -q -i 0 -w 3 -S 64m)
          -B              print final statistics in raw format
          -q              suppress human-readable output
          -h              display this message and exit
          -v              display version and exit
    updated the script to report the ioping and fio versions and disk layout so have better idea for what the environment is

    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    Code:
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    CPU: 4 x Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz
    2.6.32-042stab112.15
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem        Type      Size  Used Avail Use% Mounted on
    /dev/ploop28343p1 ext4       25G   22G  2.2G  91% /
    none              devtmpfs  512M  4.0K  512M   1% /dev
    none              tmpfs     512M     0  512M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 629
    innodb_io_capacity = 829
    --------------------------------------------------------------------
    innodb_io_capacity = 792
    innodb_io_capacity = 767
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 3957
    Full Writes: 119637
    innodb_io_capacity = 2392
    innodb_io_capacity = 1709
    innodb_io_capacity = 1329
    innodb_io_capacity = 1087
    
    Full Reads: 3413
    Full Writes: 119637
    innodb_io_capacity = 2392
    innodb_io_capacity = 1709
    innodb_io_capacity = 1329
    innodb_io_capacity = 1087
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  4. ModeltogTossen

    ModeltogTossen I wish I could??

    313
    97
    28
    Dec 20, 2015
    Denmark
    Ratings:
    +143
    Local Time:
    4:39 AM
    1.9.12
    10.0.23
    Ok - Did one more test for you:

    Code:
    [root@sarah ~]# curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    2
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 45
    Model name:            Intel(R) Xeon(R) CPU E5-1650 0 @ 3.20GHz
    Stepping:              7
    CPU MHz:               3192.307
    BogoMIPS:              6384.61
    Hypervisor vendor:     VMware
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              12288K
    NUMA node0 CPU(s):     0,1
    3.10.0-327.4.4.el7.x86_64
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem                            Type        Size  Used Avail Use% Mounted on
    /dev/sda1                             ext4        284G  8.9G  260G   4% /
    devtmpfs                              devtmpfs    3.9G     0  3.9G   0% /dev
    tmpfs                                 tmpfs       3.9G     0  3.9G   0% /dev/shm
    tmpfs                                 tmpfs       3.9G   49M  3.8G   2% /run
    tmpfs                                 tmpfs       3.9G     0  3.9G   0% /sys/fs/cgroup
    /dev/sdb1                             ext4        296G   23G  259G   8% /backupstore
    tmpfs                                 tmpfs       783M     0  783M   0% /run/user/0
    root@xxx fuse.sshfs  1.8T  2.3G  1.7T   1% /backupstore/borgremote
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 333
    innodb_io_capacity = 621
    --------------------------------------------------------------------
    innodb_io_capacity = 845
    innodb_io_capacity = 803
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 594
    Full Writes: 178
    innodb_io_capacity = 3
    innodb_io_capacity = 2
    innodb_io_capacity = 1
    innodb_io_capacity = 1
    innodb_io_capacity = 100
    
    Full Reads: 818
    Full Writes: 202
    innodb_io_capacity = 4
    innodb_io_capacity = 2
    innodb_io_capacity = 2
    innodb_io_capacity = 1
    innodb_io_capacity = 6
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    
     
  5. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    thanks @ModeltogTossen i updated script once again to add a bit more logic to fio tests for systems with <100 iops reported previously
     
  6. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    4:39 AM
    Nginx:1.11
    MariaDB-10
    Yes, I have version 0.6
    Is this installed by your script ? It is not updated by yum to a newer version, should I re-run one of the options of the centmin script to update to the latest version ?
     
  7. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    what's output of
    Code:
    which ioping
    ls -lah /usr/local/bin/ioping
    ls -lah /usr/bin/ioping
    /usr/local/bin/ioping -v
    /usr/bin/ioping -v
     
  8. Ahmad

    Ahmad Active Member

    209
    80
    28
    Apr 13, 2015
    Ratings:
    +150
    Local Time:
    4:39 AM
    1.9.9
    10.1.10
    Code:
    [root@server ~]# curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                4
    On-line CPU(s) list:   0-3
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             4
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 58
    Model name:            Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz
    Stepping:              9
    CPU MHz:               3300.022
    BogoMIPS:              6600.04
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0-3
    3.10.0-327.3.1.el7.x86_64
    CentOS Linux release 7.2.1511 (Core) 
    --------------------------------------------------------------------
    Dateisystem    Typ      Größe Benutzt Verf. Verw% Eingehängt auf
    /dev/vda1      ext4       41G     21G   18G   55% /
    devtmpfs       devtmpfs  911M       0  911M    0% /dev
    tmpfs          tmpfs     920M       0  920M    0% /dev/shm
    tmpfs          tmpfs     920M     99M  822M   11% /run
    tmpfs          tmpfs     920M       0  920M    0% /sys/fs/cgroup
    tmpfs          tmpfs     184M       0  184M    0% /run/user/0
    tmpfs          tmpfs     184M       0  184M    0% /run/user/994
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 609
    innodb_io_capacity = 592
    --------------------------------------------------------------------
    innodb_io_capacity = 762
    innodb_io_capacity = 747
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 39196
    Full Writes: 35929
    innodb_io_capacity = 1197
    innodb_io_capacity = 898
    innodb_io_capacity = 718
    innodb_io_capacity = 513
    
    
    Full Reads: 34859
    Full Writes: 33032
    innodb_io_capacity = 1101
    innodb_io_capacity = 825
    innodb_io_capacity = 660
    innodb_io_capacity = 471
    
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    Code:
    [root@server ~]# curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                8
    On-line CPU(s) list:   0-7
    Thread(s) per core:    2
    Core(s) per socket:    4
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 94
    Model name:            Intel(R) Xeon(R) CPU E3-1240 v5 @ 3.50GHz
    Stepping:              3
    CPU MHz:               969.199
    BogoMIPS:              7008.05
    Virtualization:        VT-x
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              8192K
    NUMA node0 CPU(s):     0-7
    3.10.0-327.4.4.el7.x86_64
    CentOS Linux release 7.2.1511 (Core) 
    --------------------------------------------------------------------
    Dateisystem                    Typ      Größe Benutzt Verf. Verw% Eingehängt auf
    /dev/mapper/centos_server-root xfs        50G    6,3G   44G   13% /
    devtmpfs                       devtmpfs  7,8G       0  7,8G    0% /dev
    tmpfs                          tmpfs     7,8G       0  7,8G    0% /dev/shm
    tmpfs                          tmpfs     7,8G    249M  7,5G    4% /run
    tmpfs                          tmpfs     7,8G       0  7,8G    0% /sys/fs/cgroup
    /dev/mapper/centos_server-home xfs        54G    482M   53G    1% /home
    /dev/sda1                      xfs       497M    185M  312M   38% /boot
    tmpfs                          tmpfs     1,6G       0  1,6G    0% /run/user/0
    /dev/sdb2                      ext3       52G    731M   49G    2% /var/lib/mysql
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    27 change to 100
    innodb_io_capacity = 100
    27 change to 100
    innodb_io_capacity = 100
    --------------------------------------------------------------------
    35 change to 100
    innodb_io_capacity = 100
    44 change to 100
    innodb_io_capacity = 100
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 30567
    Full Writes: 19275
    innodb_io_capacity = 642
    innodb_io_capacity = 481
    innodb_io_capacity = 385
    innodb_io_capacity = 275
    
    innodb_io_capacity = 1927
    
    Full Reads: 30796
    Full Writes: 19645
    innodb_io_capacity = 654
    innodb_io_capacity = 491
    innodb_io_capacity = 392
    innodb_io_capacity = 280
    
    innodb_io_capacity = 1964
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 4
    innodb_write_io_threads = 4
    --------------------------------------------------------------------
    Code:
    [root@server ~]# curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 63
    Model name:            Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
    Stepping:              2
    CPU MHz:               2399.998
    BogoMIPS:              4799.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0,1
    3.10.0-327.4.4.el7.x86_64
    CentOS Linux release 7.2.1511 (Core) 
    --------------------------------------------------------------------
    Dateisystem    Typ      Größe Benutzt Verf. Verw% Eingehängt auf
    /dev/vda1      ext4       39G     12G   26G   32% /
    devtmpfs       devtmpfs  912M       0  912M    0% /dev
    tmpfs          tmpfs     920M       0  920M    0% /dev/shm
    tmpfs          tmpfs     920M     98M  823M   11% /run
    tmpfs          tmpfs     920M       0  920M    0% /sys/fs/cgroup
    tmpfs          tmpfs     184M       0  184M    0% /run/user/0
    tmpfs          tmpfs     184M       0  184M    0% /run/user/993
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 663
    innodb_io_capacity = 707
    --------------------------------------------------------------------
    innodb_io_capacity = 695
    innodb_io_capacity = 769
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 70620
    Full Writes: 64000
    innodb_io_capacity = 2133
    innodb_io_capacity = 1600
    innodb_io_capacity = 1280
    innodb_io_capacity = 914
    
    
    Full Reads: 76560
    Full Writes: 66601
    innodb_io_capacity = 2220
    innodb_io_capacity = 1665
    innodb_io_capacity = 1332
    innodb_io_capacity = 951
    
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    
     
  9. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    4:39 AM
    Nginx:1.11
    MariaDB-10
    There are 2 versions of ioping :
    Code:
    [root@dev ~]# ioping -v
    ioping 0.6
    [root@dev ~]# which ioping
    /usr/local/bin/ioping
    [root@dev ~]# ls -lah /usr/local/bin/ioping
    -rwxr-xr-x 1 root root 37K Feb  5 09:24 /usr/local/bin/ioping
    [root@dev ~]# ls -lah /usr/bin/ioping
    -rwxr-xr-x 1 root root 25K Jul 16  2015 /usr/bin/ioping
    [root@dev ~]# /usr/local/bin/ioping -v
    ioping 0.6
    [root@dev ~]# /usr/bin/ioping -v
    ioping 0.9
    
    The one dated today I just re-installed via iopingcentmin.sh 0.9.8
    When I look at this script, inside is :
    Code:
    #!/bin/bash
    #######################################################
    # Copyright (C) 2011
    # Program: iopingcentmin.sh
    # Shell script wrapper for ioping code.google.com/p/ioping/
    # disk I/O latency measuring tool
    # Updated: September 6th, 2011 AEST
    DESC='shell wrapper script'
    AUTHOR='by George Liu (eva2000)'
    NAME='iopingcentmin'
    SCRIPT="$NAME.sh"
    SCRIPTURL='code.google.com/p/ioping/'
    VER='0.9.8'
    URL='http://vbtechsupport.com/1239/'
    #######################################################
    
    IOPINGVER='0.6'
    REQUESTSIZE='4 32 64 256'
    
    # Set paths
    MAKE="$(which make 2>/dev/null)"
    SEEKER="$(which seeker 2>/dev/null)"
    
    #######################################################
    
    So it seems to install version 0.6 ??
     
  10. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    @SeaTea yeah centmin.sh menu 13 was outdated with my old ioping script which installed 0.60

    just updated 123.09beta01 centmin.sh menu 13 to use EPEL yum version of ioping at update centmin.sh menu option 13 · centminmod/centminmod@5c202d4 · GitHub

    Also updated the script to use /usr/bin/ioping specifically so should work now
    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    Code:
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    CPU: 4 x Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz
    2.6.32-042stab112.15
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem        Type      Size  Used Avail Use% Mounted on
    /dev/ploop28343p1 ext4       25G   18G  5.7G  76% /
    none              devtmpfs  512M  4.0K  512M   1% /dev
    none              tmpfs     512M     0  512M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 939
    innodb_io_capacity = 1201
    --------------------------------------------------------------------
    innodb_io_capacity = 855
    innodb_io_capacity = 818
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 3786
    Full Writes: 117928
    innodb_io_capacity = 3930
    innodb_io_capacity = 2948
    innodb_io_capacity = 2358
    innodb_io_capacity = 1684
    
    innodb_io_capacity = 3930
    
    Full Reads: 3716
    Full Writes: 116267
    innodb_io_capacity = 3875
    innodb_io_capacity = 2906
    innodb_io_capacity = 2325
    innodb_io_capacity = 1660
    
    innodb_io_capacity = 3875
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  11. dorobo

    dorobo Active Member

    420
    104
    43
    Jun 6, 2014
    Ratings:
    +162
    Local Time:
    10:39 AM
    latest
    latest
    Code:
    # curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    CPU: 2 x Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
    2.6.32-42-pve
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/simfs     simfs      15G   12G  3.7G  76% /
    devtmpfs       devtmpfs  512M     0  512M   0% /dev
    tmpfs          tmpfs     512M     0  512M   0% /dev/shm
    tmpfs          tmpfs     512M  160K  512M   1% /run
    tmpfs          tmpfs     512M     0  512M   0% /sys/fs/cgroup
    tmpfs          tmpfs     103M     0  103M   0% /run/user/994
    tmpfs          tmpfs     103M     0  103M   0% /run/user/0
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 1415
    90 change to 100
    innodb_io_capacity = 100
    --------------------------------------------------------------------
    innodb_io_capacity = 1060
    innodb_io_capacity = 597
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 24380
    Full Writes: 56109
    innodb_io_capacity = 1870
    innodb_io_capacity = 1402
    innodb_io_capacity = 1122
    innodb_io_capacity = 801
    
    
    Full Reads: 13149
    Full Writes: 57690
    innodb_io_capacity = 1923
    innodb_io_capacity = 1442
    innodb_io_capacity = 1153
    innodb_io_capacity = 824
    
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    
     
  12. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    @dorobo thanks

    getting there, finding a dynamic formula will need lots of testing to ensure i do not set the value too high or too low across systems :)
     
  13. SeaTea

    SeaTea Member

    49
    13
    8
    Feb 20, 2015
    the Netherlands
    Ratings:
    +28
    Local Time:
    4:39 AM
    Nginx:1.11
    MariaDB-10
    Thanks ! Works ok now:

    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    --------------------------------------------------------------------
    System Info
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 44
    Model name:            Westmere E56xx/L56xx/X56xx (Nehalem-C)
    Stepping:              1
    CPU MHz:               2199.998
    BogoMIPS:              4399.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0,1
    3.10.0-327.4.4.el7.x86_64
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem                  Type      Size  Used Avail Use% Mounted on
    /dev/mapper/centos_sim-root xfs        50G   12G   39G  23% /
    devtmpfs                    devtmpfs  1.9G     0  1.9G   0% /dev
    tmpfs                       tmpfs     1.9G     0  1.9G   0% /dev/shm
    tmpfs                       tmpfs     1.9G   73M  1.8G   4% /run
    tmpfs                       tmpfs     1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/mapper/centos_sim-home xfs        96G  3.7G   92G   4% /home
    /dev/loop0                  ext4      3.7G   20M  3.5G   1% /tmp
    /dev/vda1                   xfs       497M  265M  233M  54% /boot
    tmpfs                       tmpfs     380M     0  380M   0% /run/user/0
    tmpfs                       tmpfs     380M     0  380M   0% /run/user/497
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 122
    innodb_io_capacity = 242
    --------------------------------------------------------------------
    innodb_io_capacity = 335
    innodb_io_capacity = 169
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 3653
    Full Writes: 2578
    innodb_io_capacity = 85
    innodb_io_capacity = 64
    innodb_io_capacity = 51
    innodb_io_capacity = 36
    
    innodb_io_capacity = 515
    
    Full Reads: 3653
    Full Writes: 2578
    innodb_io_capacity = 85
    innodb_io_capacity = 64
    innodb_io_capacity = 51
    innodb_io_capacity = 36
    
    innodb_io_capacity = 515
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    
     
  14. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Cheers fio does look like the better calculator for iops for innodb setting. Added a version number to system info heading so you know when i update the script

    will always be at same url so same running method
    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 4 x Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz
    2.6.32-042stab112.15
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem        Type      Size  Used Avail Use% Mounted on
    /dev/ploop28343p1 ext4       25G   18G  5.7G  76% /
    none              devtmpfs  512M  4.0K  512M   1% /dev
    none              tmpfs     512M     0  512M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 1235
    innodb_io_capacity = 1015
    --------------------------------------------------------------------
    innodb_io_capacity = 1438
    innodb_io_capacity = 1513
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 3257
    Full Writes: 116267
    innodb_io_capacity = 3875
    innodb_io_capacity = 2906
    innodb_io_capacity = 2325
    innodb_io_capacity = 1660
    
    innodb_io_capacity = 4650
    
    Full Reads: 3736
    Full Writes: 114652
    innodb_io_capacity = 3821
    innodb_io_capacity = 2866
    innodb_io_capacity = 2293
    innodb_io_capacity = 1637
    
    innodb_io_capacity = 4586
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  15. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    on 2GB DigitalOcean KVM VPS
    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 62
    Model name:            Intel(R) Xeon(R) CPU E5-2630L v2 @ 2.40GHz
    Stepping:              4
    CPU MHz:               2399.998
    BogoMIPS:              4799.99
    Virtualization:        VT-x
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              15360K
    NUMA node0 CPU(s):     0,1
    3.10.0-229.11.1.el7.x86_64
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/vda1      ext4       40G   25G   13G  66% /
    devtmpfs       devtmpfs  993M     0  993M   0% /dev
    tmpfs          tmpfs    1001M     0 1001M   0% /dev/shm
    tmpfs          tmpfs    1001M   25M  977M   3% /run
    tmpfs          tmpfs    1001M     0 1001M   0% /sys/fs/cgroup
    tmpfs          tmpfs     201M     0  201M   0% /run/user/994
    tmpfs          tmpfs     201M     0  201M   0% /run/user/0
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 601
    innodb_io_capacity = 604
    --------------------------------------------------------------------
    innodb_io_capacity = 1163
    innodb_io_capacity = 1159
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 75155
    Full Writes: 10317
    innodb_io_capacity = 343
    innodb_io_capacity = 257
    innodb_io_capacity = 206
    innodb_io_capacity = 147
    
    innodb_io_capacity = 1031
    
    Full Reads: 78019
    Full Writes: 10395
    innodb_io_capacity = 346
    innodb_io_capacity = 259
    innodb_io_capacity = 207
    innodb_io_capacity = 148
    
    innodb_io_capacity = 1039
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  16. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    On SoYouStart E3-1245v2 3x120GB SSD
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                8
    On-line CPU(s) list:   0-7
    Thread(s) per core:    2
    Core(s) per socket:    4
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 58
    Model name:            Intel(R) Xeon(R) CPU E3-1245 V2 @ 3.40GHz
    Stepping:              9
    CPU MHz:               3798.968
    BogoMIPS:              6784.60
    Virtualization:        VT-x
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              8192K
    NUMA node0 CPU(s):     0-7
    3.10.0-327.3.1.el7.x86_64
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/md1       xfs        20G  9.2G   11G  47% /
    devtmpfs       devtmpfs   16G     0   16G   0% /dev
    tmpfs          tmpfs      16G     0   16G   0% /dev/shm
    tmpfs          tmpfs      16G  493M   16G   4% /run
    tmpfs          tmpfs      16G     0   16G   0% /sys/fs/cgroup
    /dev/md2       xfs        86G 1001M   85G   2% /home
    tmpfs          tmpfs     3.2G     0  3.2G   0% /run/user/0
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 222
    innodb_io_capacity = 464
    --------------------------------------------------------------------
    innodb_io_capacity = 576
    474 change to 200
    innodb_io_capacity = 200
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 34859
    Full Writes: 7494
    innodb_io_capacity = 249
    innodb_io_capacity = 187
    innodb_io_capacity = 149
    innodb_io_capacity = 107
    
    innodb_io_capacity = 936
    
    Full Reads: 35158
    Full Writes: 7536
    innodb_io_capacity = 251
    innodb_io_capacity = 188
    innodb_io_capacity = 150
    innodb_io_capacity = 107
    
    innodb_io_capacity = 942
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 4
    innodb_write_io_threads = 4
    --------------------------------------------------------------------
     
  17. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    4GB Linode KVM VPS
    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                4
    On-line CPU(s) list:   0-3
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             4
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 63
    Stepping:              2
    CPU MHz:               2499.996
    BogoMIPS:              5001.32
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              30720K
    NUMA node0 CPU(s):     0-3
    4.1.5-x86_64-linode61
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem     Type   Size  Used Avail Use% Mounted on
    /dev/sda       ext4    70G   25G   44G  37% /
    tmpfs          tmpfs  2.0G  128K  2.0G   1% /dev/shm
    tmpfs          tmpfs  2.0G  7.3M  2.0G   1% /tmp
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 596
    innodb_io_capacity = 550
    --------------------------------------------------------------------
    innodb_io_capacity = 1009
    innodb_io_capacity = 1082
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 49136
    Full Writes: 47716
    innodb_io_capacity = 1590
    innodb_io_capacity = 1192
    innodb_io_capacity = 954
    innodb_io_capacity = 681
    
    innodb_io_capacity = 3181
    
    Full Reads: 54668
    Full Writes: 58964
    innodb_io_capacity = 1965
    innodb_io_capacity = 1474
    innodb_io_capacity = 1179
    innodb_io_capacity = 842
    
    innodb_io_capacity = 3930
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  18. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    768MB Vultr older 3.6Ghz KVM VPS
    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 60
    Stepping:              1
    CPU MHz:               3600.016
    BogoMIPS:              7200.03
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0
    2.6.32-573.1.1.el6.x86_64
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem     Type   Size  Used Avail Use% Mounted on
    /dev/vda1      ext4    15G   12G  2.9G  80% /
    tmpfs          tmpfs  372M     0  372M   0% /dev/shm
    tmpfs          tmpfs  372M   44K  372M   1% /tmp
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 731
    innodb_io_capacity = 713
    --------------------------------------------------------------------
    innodb_io_capacity = 1181
    innodb_io_capacity = 1221
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 27334
    Full Writes: 20134
    innodb_io_capacity = 671
    innodb_io_capacity = 503
    innodb_io_capacity = 402
    innodb_io_capacity = 287
    
    innodb_io_capacity = 2013
    
    Full Reads: 23997
    Full Writes: 21497
    innodb_io_capacity = 716
    innodb_io_capacity = 537
    innodb_io_capacity = 429
    innodb_io_capacity = 307
    
    innodb_io_capacity = 2149
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  19. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    newer but slower clocked 768MB Vultr 2.4Ghz KVM VPS

    here ioping shows difference between old and new Vultr instance above

    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 60
    Model name:            Virtual CPU e7da7129d3ee
    Stepping:              1
    CPU MHz:               2399.996
    BogoMIPS:              4799.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0
    3.10.0-229.14.1.el7.x86_64
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/vda1      ext3       20G   12G  6.9G  64% /
    devtmpfs       devtmpfs  489M     0  489M   0% /dev
    tmpfs          tmpfs     497M     0  497M   0% /dev/shm
    tmpfs          tmpfs     497M   51M  447M  11% /run
    tmpfs          tmpfs     497M     0  497M   0% /sys/fs/cgroup
    /dev/loop0     ext4      3.7G   16M  3.5G   1% /tmp
    tmpfs          tmpfs     100M     0  100M   0% /run/user/994
    tmpfs          tmpfs     100M     0  100M   0% /run/user/0
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    98 change to 100
    innodb_io_capacity = 100
    innodb_io_capacity = 188
    --------------------------------------------------------------------
    210 change to 150
    innodb_io_capacity = 150
    innodb_io_capacity = 573
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 26859
    Full Writes: 23206
    innodb_io_capacity = 773
    innodb_io_capacity = 580
    innodb_io_capacity = 464
    innodb_io_capacity = 331
    
    innodb_io_capacity = 2320
    
    Full Reads: 27675
    Full Writes: 23339
    innodb_io_capacity = 777
    innodb_io_capacity = 583
    innodb_io_capacity = 466
    innodb_io_capacity = 333
    
    innodb_io_capacity = 2333
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
  20. eva2000

    eva2000 Administrator Staff Member

    45,432
    10,307
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,986
    Local Time:
    12:39 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    from my cenminmod.com cluster of VPS servers

    Code:
    curl -sL https://gist.github.com/centminmod/01b5ec3ebd394fa9284f/raw/innodbio.sh | bash
    1GB Cloudshard OpenVZ
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 2 x Intel(R) Xeon(R) CPU E3-1271 v3 @ 3.60GHz
    2.6.32-042stab106.4
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/simfs     simfs      20G   12G  8.3G  59% /
    none           devtmpfs  512M  4.0K  512M   1% /dev
    none           tmpfs     512M     0  512M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 963
    innodb_io_capacity = 1047
    --------------------------------------------------------------------
    innodb_io_capacity = 1497
    innodb_io_capacity = 1410
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 14381
    Full Writes: 117928
    innodb_io_capacity = 3930
    innodb_io_capacity = 2948
    innodb_io_capacity = 2358
    innodb_io_capacity = 1684
    
    innodb_io_capacity = 4717
    
    Full Reads: 10104
    Full Writes: 117928
    innodb_io_capacity = 3930
    innodb_io_capacity = 2948
    innodb_io_capacity = 2358
    innodb_io_capacity = 1684
    
    innodb_io_capacity = 4717
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    2GB Wable OpenVZ
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 2 x Intel(R) Xeon(R) CPU E5-2643 v3 @ 3.40GHz
    2.6.32-042stab108.5
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/simfs     simfs      20G   12G  8.2G  60% /
    none           devtmpfs  1.0G  4.0K  1.0G   1% /dev
    none           tmpfs     1.0G     0  1.0G   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 1831
    innodb_io_capacity = 1888
    --------------------------------------------------------------------
    innodb_io_capacity = 3885
    innodb_io_capacity = 2951
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 8205
    Full Writes: 90714
    innodb_io_capacity = 3023
    innodb_io_capacity = 2267
    innodb_io_capacity = 1814
    innodb_io_capacity = 1295
    
    innodb_io_capacity = 4535
    
    Full Reads: 3859
    Full Writes: 99457
    innodb_io_capacity = 3315
    innodb_io_capacity = 2486
    innodb_io_capacity = 1989
    innodb_io_capacity = 1420
    
    innodb_io_capacity = 4972
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    512MB Ramnode CKVM
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 13
    Stepping:              3
    CPU MHz:               2600.000
    BogoMIPS:              5200.00
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    NUMA node0 CPU(s):     0,1
    2.6.32-573.12.1.el6.x86_64
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem           Type   Size  Used Avail Use% Mounted on
    /dev/vda1            ext4    49G   18G   29G  39% /
    tmpfs                tmpfs  246M     0  246M   0% /dev/shm
    /home/usertmp_donotdelete
                         ext4   3.7G  7.7M  3.5G   1% /tmp
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 683
    innodb_io_capacity = 673
    --------------------------------------------------------------------
    innodb_io_capacity = 1452
    innodb_io_capacity = 1560
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 57727
    Full Writes: 55402
    innodb_io_capacity = 1846
    innodb_io_capacity = 1385
    innodb_io_capacity = 1108
    innodb_io_capacity = 791
    
    innodb_io_capacity = 3693
    
    Full Reads: 48558
    Full Writes: 53603
    innodb_io_capacity = 1786
    innodb_io_capacity = 1340
    innodb_io_capacity = 1072
    innodb_io_capacity = 765
    
    innodb_io_capacity = 3573
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    2GB Linode KVM Singapore
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 62
    Model name:            Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz
    Stepping:              4
    CPU MHz:               2800.000
    BogoMIPS:              5602.33
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              25600K
    NUMA node0 CPU(s):     0
    4.1.5-x86_64-linode61
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/root      ext4       20G   14G  5.1G  74% /
    devtmpfs       devtmpfs  494M     0  494M   0% /dev
    tmpfs          tmpfs     496M     0  496M   0% /dev/shm
    tmpfs          tmpfs     496M   58M  438M  12% /run
    tmpfs          tmpfs     496M     0  496M   0% /sys/fs/cgroup
    /dev/loop0     ext4      3.7G   17M  3.5G   1% /tmp
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 624
    innodb_io_capacity = 623
    --------------------------------------------------------------------
    innodb_io_capacity = 121
    462 change to 200
    innodb_io_capacity = 200
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 56109
    Full Writes: 46282
    innodb_io_capacity = 1542
    innodb_io_capacity = 1157
    innodb_io_capacity = 925
    innodb_io_capacity = 661
    
    innodb_io_capacity = 3085
    
    Full Reads: 56109
    Full Writes: 43807
    innodb_io_capacity = 1460
    innodb_io_capacity = 1095
    innodb_io_capacity = 876
    innodb_io_capacity = 625
    
    innodb_io_capacity = 2920
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    2GB Dediserve Xen Sydney VPS
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                4
    On-line CPU(s) list:   0-3
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             4
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 62
    Stepping:              4
    CPU MHz:               2200.000
    BogoMIPS:              4400.00
    Hypervisor vendor:     Xen
    Virtualization type:   para
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              256K
    L3 cache:              25600K
    NUMA node0 CPU(s):     0-3
    2.6.32-504.12.2.el6.x86_64
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem           Type   Size  Used Avail Use% Mounted on
    /dev/xvda1           ext4    49G   17G   30G  36% /
    tmpfs                tmpfs  935M     0  935M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 713
    innodb_io_capacity = 876
    --------------------------------------------------------------------
    innodb_io_capacity = 1365
    innodb_io_capacity = 1373
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 27334
    Full Writes: 43219
    innodb_io_capacity = 1440
    innodb_io_capacity = 1080
    innodb_io_capacity = 864
    innodb_io_capacity = 617
    
    innodb_io_capacity = 2881
    
    Full Reads: 34111
    Full Writes: 26373
    innodb_io_capacity = 879
    innodb_io_capacity = 659
    innodb_io_capacity = 527
    innodb_io_capacity = 376
    
    innodb_io_capacity = 2637
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    512MB Buyvm.net OpenVZ NJ
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 2 x Intel(R) Xeon(R) CPU E5-2630L 0 @ 2.00GHz
    2.6.32-openvz-042stab104.1-amd64
    CentOS release 6.7 (Final)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/simfs     simfs      50G   13G   38G  25% /
    none           devtmpfs  256M  4.0K  256M   1% /dev
    none           tmpfs     256M     0  256M   0% /dev/shm
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.8 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 415
    innodb_io_capacity = 318
    --------------------------------------------------------------------
    innodb_io_capacity = 526
    482 change to 200
    innodb_io_capacity = 200
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.0.13 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 2608
    Full Writes: 29066
    innodb_io_capacity = 968
    innodb_io_capacity = 726
    innodb_io_capacity = 581
    innodb_io_capacity = 415
    
    innodb_io_capacity = 2906
    
    Full Reads: 2719
    Full Writes: 30917
    innodb_io_capacity = 1030
    innodb_io_capacity = 772
    innodb_io_capacity = 618
    innodb_io_capacity = 441
    
    innodb_io_capacity = 3091
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    1GB SecureDragon OpenVZ Los Angeles
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 4 x Intel(R) Xeon(R) CPU L5640 @ 2.27GHz
    2.6.32-042stab105.14
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/simfs     simfs      25G   14G   12G  54% /
    tmpfs          tmpfs      24G     0   24G   0% /sys/fs/cgroup
    devtmpfs       devtmpfs   24G     0   24G   0% /dev
    tmpfs          tmpfs      24G     0   24G   0% /dev/shm
    tmpfs          tmpfs      24G  588K   24G   1% /run
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 847
    innodb_io_capacity = 1335
    --------------------------------------------------------------------
    innodb_io_capacity = 2534
    innodb_io_capacity = 2620
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 21005
    Full Writes: 64000
    innodb_io_capacity = 2133
    innodb_io_capacity = 1600
    innodb_io_capacity = 1280
    innodb_io_capacity = 914
    
    innodb_io_capacity = 3200
    
    Full Reads: 24526
    Full Writes: 67147
    innodb_io_capacity = 2238
    innodb_io_capacity = 1678
    innodb_io_capacity = 1342
    innodb_io_capacity = 959
    
    innodb_io_capacity = 3357
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
    1GB TheSkySpace Xen VPS Los Angeles
    Code:
    --------------------------------------------------------------------
    System Info (0.1)
    --------------------------------------------------------------------
    CPU: 4 x Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz
    2.6.32-042stab112.15
    CentOS Linux release 7.2.1511 (Core)
    --------------------------------------------------------------------
    Filesystem        Type      Size  Used Avail Use% Mounted on
    /dev/ploop20169p1 ext4       25G   14G  9.3G  61% /
    devtmpfs          devtmpfs  512M     0  512M   0% /dev
    tmpfs             tmpfs     512M     0  512M   0% /dev/shm
    tmpfs             tmpfs     512M  276K  512M   1% /run
    tmpfs             tmpfs     512M     0  512M   0% /sys/fs/cgroup
    --------------------------------------------------------------------
    
    
    --------------------------------------------------------------------
    ioping 0.9 calculated (IOPs)
    --------------------------------------------------------------------
    innodb_io_capacity = 1136
    innodb_io_capacity = 1275
    --------------------------------------------------------------------
    innodb_io_capacity = 1438
    innodb_io_capacity = 1351
    --------------------------------------------------------------------
    
    --------------------------------------------------------------------
    fio-2.2.8 calculated (IOPs)
    --------------------------------------------------------------------
    
    Full Reads: 3211
    Full Writes: 112219
    innodb_io_capacity = 3740
    innodb_io_capacity = 2805
    innodb_io_capacity = 2244
    innodb_io_capacity = 1603
    
    innodb_io_capacity = 4488
    
    Full Reads: 3195
    Full Writes: 112219
    innodb_io_capacity = 3740
    innodb_io_capacity = 2805
    innodb_io_capacity = 2244
    innodb_io_capacity = 1603
    
    innodb_io_capacity = 4488
    
    --------------------------------------------------------------------
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    --------------------------------------------------------------------
     
    Last edited: Feb 5, 2016