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 -----------------------------------
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 -----------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
thanks @ModeltogTossen i updated script once again to add a bit more logic to fio tests for systems with <100 iops reported previously
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 ?
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
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 --------------------------------------------------------------------
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 ??
@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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
@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
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------
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 --------------------------------------------------------------------