CentOS 7, Linode 8GB: 4 CPU, 160GB Storage, 8GB RAM Region: Fremont, CA Code: # ./sysbench.sh cpu ------------------------------------------- System Information ------------------------------------------- 3.10.0-1127.13.1.el7.x86_64 CentOS Linux release 7.8.2003 (Core) Centmin Mod 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: AuthenticAMD CPU family: 23 Model: 1 Model name: AMD EPYC 7501 32-Core Processor Stepping: 2 CPU MHz: 1999.999 BogoMIPS: 3999.99 Hypervisor vendor: KVM Virtualization type: full L1d cache: 64K L1i cache: 64K L2 cache: 512K L3 cache: 16384K NUMA node0 CPU(s): 0-3 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm art rep_good nopl extd_apicid eagerfpu pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw perfctr_core retpoline_amd ssbd ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt sha_ni xsaveopt xsavec xgetbv1 virt_ssbd arat CPU Flags fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm art rep_good nopl extd_apicid eagerfpu pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw perfctr_core retpoline_amd ssbd ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt sha_ni xsaveopt xsavec xgetbv1 virt_ssbd arat CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE 0 0 0 0 0:0:0:0 yes 1 0 1 1 1:1:1:1 yes 2 0 2 2 2:2:2:2 yes 3 0 3 3 3:3:3:3 yes total used free shared buff/cache available Mem: 7820 1936 2529 24 3355 5557 Low: 7820 5291 2529 High: 0 0 0 Swap: 511 0 511 Filesystem Size Used Avail Use% Mounted on devtmpfs 3.9G 0 3.9G 0% /dev tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs 3.9G 8.6M 3.9G 1% /run tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup /dev/sda 158G 6.8G 143G 5% / /dev/loop0 5.8G 25M 5.5G 1% /tmp tmpfs 783M 0 783M 0% /run/user/0 sysbench cpu --cpu-max-prime=20000 --threads=1 run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 prime: 20000 events/s: 491.23 time: 10.0019s min: 2.02 avg: 2.03 max: 3.50 95th: 2.07 | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | | 1.0.20 | 1 | 491.23 | 10.0019s | 2.02 | 2.03 | 3.50 | 2.07 | sysbench,threads,events/s,time,min,avg,max,95th 1.0.20,1,491.23,10.0019s,2.02,2.03,3.50,2.07 sysbench cpu --cpu-max-prime=20000 --threads=4 run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 prime: 20000 events/s: 1948.41 time: 10.0015s min: 2.02 avg: 2.05 max: 11.18 95th: 2.11 | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | | 1.0.20 | 4 | 1948.41 | 10.0015s | 2.02 | 2.05 | 11.18 | 2.11 | sysbench,threads,events/s,time,min,avg,max,95th 1.0.20,4,1948.41,10.0015s,2.02,2.05,11.18,2.11 Code: # ./sysbench.sh mem ------------------------------------------- System Information ------------------------------------------- 3.10.0-1127.13.1.el7.x86_64 CentOS Linux release 7.8.2003 (Core) Centmin Mod 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: AuthenticAMD CPU family: 23 Model: 1 Model name: AMD EPYC 7501 32-Core Processor Stepping: 2 CPU MHz: 1999.999 BogoMIPS: 3999.99 Hypervisor vendor: KVM Virtualization type: full L1d cache: 64K L1i cache: 64K L2 cache: 512K L3 cache: 16384K NUMA node0 CPU(s): 0-3 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm art rep_good nopl extd_apicid eagerfpu pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw perfctr_core retpoline_amd ssbd ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt sha_ni xsaveopt xsavec xgetbv1 virt_ssbd arat CPU Flags fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm art rep_good nopl extd_apicid eagerfpu pni pclmulqdq ssse3 fma cx16 sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm cmp_legacy cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw perfctr_core retpoline_amd ssbd ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt sha_ni xsaveopt xsavec xgetbv1 virt_ssbd arat CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE 0 0 0 0 0:0:0:0 yes 1 0 1 1 1:1:1:1 yes 2 0 2 2 2:2:2:2 yes 3 0 3 3 3:3:3:3 yes total used free shared buff/cache available Mem: 7820 1935 2529 24 3355 5557 Low: 7820 5291 2529 High: 0 0 0 Swap: 511 0 511 Filesystem Size Used Avail Use% Mounted on devtmpfs 3.9G 0 3.9G 0% /dev tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs 3.9G 8.6M 3.9G 1% /run tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup /dev/sda 158G 6.8G 143G 5% / /dev/loop0 5.8G 25M 5.5G 1% /tmp tmpfs 783M 0 783M 0% /run/user/0 sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 block-size: 1KiB total-size: 1024MiB operation: read scope: global total-ops: 1048576 (4146192.54 per second) transferred (4049.02 MiB/sec) time: 0.2514s min: 0.00 avg: 0.00 max: 0.05 95th: 0.00 | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | memory | 1.0.20 | 1 | 1KiB | 1024MiB | read | 1048576 | 4049.02 | 0.2514s | 0.00 | 0.00 | 0.05 | 0.00 | sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th memory,1.0.20,1,1KiB,1024MiB,read,1048576,4049.02,0.2514s,0.00,0.00,0.05,0.00 sysbench memory --threads=4 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 block-size: 1KiB total-size: 1024MiB operation: read scope: global total-ops: 1048576 (10405741.31 per second) transferred (10161.86 MiB/sec) time: 0.0992s min: 0.00 avg: 0.00 max: 0.05 95th: 0.00 | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | memory | 1.0.20 | 4 | 1KiB | 1024MiB | read | 1048576 | 10161.86 | 0.0992s | 0.00 | 0.00 | 0.05 | 0.00 | sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th memory,1.0.20,4,1KiB,1024MiB,read,1048576,10161.86,0.0992s,0.00,0.00,0.05,0.00 Code: # ./sysbench.sh file sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-1-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 Block-size 4KiB Using synchronous I/O mode Doing sequential read test reads/s: 9367.34 writes/s: 0.00 fsyncs/s: 0.00 read-MiB/s: 36.59 written-MiB/s: 0.00 time: 10.0001s min: 0.06 avg: 0.11 max: 18.50 95th: 0.17 | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 1 | 4KiB | I/O | read | 9367.34 | 0.00 | 0.00 | 36.59 | 0.00 | 10.0001s | 0.06 | 0.11 | 18.50 | 0.17 | sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,1,4KiB,I/O,read,9367.34,0.00,0.00,36.59,0.00,10.0001s,0.06,0.11,18.50,0.17 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-1-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 Block-size 4KiB Using synchronous I/O mode Doing sequential write (creation) test reads/s: 0.00 writes/s: 6844.91 fsyncs/s: 8772.48 read-MiB/s: 0.00 written-MiB/s: 26.74 time: 10.0059s min: 0.02 avg: 0.06 max: 18.65 95th: 0.13 | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 6844.91 | 8772.48 | 0.00 | 26.74 | 10.0059s | 0.02 | 0.06 | 18.65 | 0.13 | sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,1,4KiB,I/O,write,0.00,6844.91,8772.48,0.00,26.74,10.0059s,0.02,0.06,18.65,0.13 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-1-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 Block-size 4KiB Read/Write ratio for combined random IO test: 1.50 Using synchronous I/O mode Doing random read test reads/s: 5121.25 writes/s: 0.00 fsyncs/s: 0.00 read-MiB/s: 20.00 written-MiB/s: 0.00 time: 10.0002s min: 0.10 avg: 0.19 max: 5.17 95th: 0.22 | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 1 | 4KiB | I/O | read | 5121.25 | 0.00 | 0.00 | 20.00 | 0.00 | 10.0002s | 0.10 | 0.19 | 5.17 | 0.22 | sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,1,4KiB,I/O,read,5121.25,0.00,0.00,20.00,0.00,10.0002s,0.10,0.19,5.17,0.22 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-1-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 Block-size 4KiB Read/Write ratio for combined random IO test: 1.50 Using synchronous I/O mode Doing random write test reads/s: 0.00 writes/s: 6664.09 fsyncs/s: 8530.03 read-MiB/s: 0.00 written-MiB/s: 26.03 time: 10.0072s min: 0.03 avg: 0.07 max: 16.54 95th: 0.13 | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 6664.09 | 8530.03 | 0.00 | 26.03 | 10.0072s | 0.03 | 0.07 | 16.54 | 0.13 | sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,1,4KiB,I/O,write,0.00,6664.09,8530.03,0.00,26.03,10.0072s,0.03,0.07,16.54,0.13 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-4-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 Block-size 4KiB Using synchronous I/O mode Doing sequential read test reads/s: 30147.90 writes/s: 0.00 fsyncs/s: 0.00 read-MiB/s: 117.77 written-MiB/s: 0.00 time: 10.0002s min: 0.05 avg: 0.13 max: 18.73 95th: 0.20 | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 4 | 4KiB | I/O | read | 30147.90 | 0.00 | 0.00 | 117.77 | 0.00 | 10.0002s | 0.05 | 0.13 | 18.73 | 0.20 | sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,4,4KiB,I/O,read,30147.90,0.00,0.00,117.77,0.00,10.0002s,0.05,0.13,18.73,0.20 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-4-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 Block-size 4KiB Using synchronous I/O mode Doing sequential write (creation) test reads/s: 0.00 writes/s: 9099.08 fsyncs/s: 11685.95 read-MiB/s: 0.00 written-MiB/s: 35.54 time: 10.0097s min: 0.03 avg: 0.19 max: 31.32 95th: 0.11 | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 4 | 4KiB | I/O | write | 0.00 | 9099.08 | 11685.95 | 0.00 | 35.54 | 10.0097s | 0.03 | 0.19 | 31.32 | 0.11 | sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,4,4KiB,I/O,write,0.00,9099.08,11685.95,0.00,35.54,10.0097s,0.03,0.19,31.32,0.11 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-4-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 Block-size 4KiB Read/Write ratio for combined random IO test: 1.50 Using synchronous I/O mode Doing random read test reads/s: 16733.55 writes/s: 0.00 fsyncs/s: 0.00 read-MiB/s: 65.37 written-MiB/s: 0.00 time: 10.0003s min: 0.07 avg: 0.24 max: 8.30 95th: 0.60 | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 4 | 4KiB | I/O | read | 16733.55 | 0.00 | 0.00 | 65.37 | 0.00 | 10.0003s | 0.07 | 0.24 | 8.30 | 0.60 | sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,4,4KiB,I/O,read,16733.55,0.00,0.00,65.37,0.00,10.0003s,0.07,0.24,8.30,0.60 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup sysbench fileio prepare sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare sysbench fileio --threads=4 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-4-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 Block-size 4KiB Read/Write ratio for combined random IO test: 1.50 Using synchronous I/O mode Doing random write test reads/s: 0.00 writes/s: 15410.62 fsyncs/s: 19776.34 read-MiB/s: 0.00 written-MiB/s: 60.20 time: 10.0112s min: 0.03 avg: 0.11 max: 32.27 95th: 0.17 | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 4 | 4KiB | I/O | write | 0.00 | 15410.62 | 19776.34 | 0.00 | 60.20 | 10.0112s | 0.03 | 0.11 | 32.27 | 0.17 | sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th fileio,1.0.20,4,4KiB,I/O,write,0.00,15410.62,19776.34,0.00,60.20,10.0112s,0.03,0.11,32.27,0.17 sysbench fileio cleanup sysbench fileio --file-total-size=2048M cleanup | fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | |fileio | 1.0.20 | 1 | 4KiB | I/O | read | 9367.34 | 0.00 | 0.00 | 36.59 | 0.00 | 10.0001s | 0.06 | 0.11 | 18.50 | 0.17 | |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 6844.91 | 8772.48 | 0.00 | 26.74 | 10.0059s | 0.02 | 0.06 | 18.65 | 0.13 | |fileio | 1.0.20 | 4 | 4KiB | I/O | read | 30147.90 | 0.00 | 0.00 | 117.77 | 0.00 | 10.0002s | 0.05 | 0.13 | 18.73 | 0.20 | |fileio | 1.0.20 | 4 | 4KiB | I/O | write | 0.00 | 9099.08 | 11685.95 | 0.00 | 35.54 | 10.0097s | 0.03 | 0.19 | 31.32 | 0.11 | | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | |fileio | 1.0.20 | 1 | 4KiB | I/O | read | 5121.25 | 0.00 | 0.00 | 20.00 | 0.00 | 10.0002s | 0.10 | 0.19 | 5.17 | 0.22 | |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 6664.09 | 8530.03 | 0.00 | 26.03 | 10.0072s | 0.03 | 0.07 | 16.54 | 0.13 | |fileio | 1.0.20 | 4 | 4KiB | I/O | read | 16733.55 | 0.00 | 0.00 | 65.37 | 0.00 | 10.0003s | 0.07 | 0.24 | 8.30 | 0.60 | |fileio | 1.0.20 | 4 | 4KiB | I/O | write | 0.00 | 15410.62 | 19776.34 | 0.00 | 60.20 | 10.0112s | 0.03 | 0.11 | 32.27 | 0.17 | Code: # ./sysbench.sh file-fsync sysbench fileio fsync prepare sysbench fileio --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --threads=1 --percentile=99 prepare sysbench fileio --threads=1 --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --percentile=99 run raw log saved: /home/sysbench/sysbench-fileio-fsync-threads-1-raw.log sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 1 Block-size 4KiB Read/Write ratio for combined random IO test: 1.50 Using synchronous I/O mode Doing random write test reads/s: 0.00 writes/s: 6953.30 fsyncs/s: 6953.30 read-MiB/s: 0.00 written-MiB/s: 27.16 time: 30.0001s min: 0.09 avg: 0.14 max: 20.17 99th: 0.35 | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 99th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 6953.30 | 6953.30 | 0.00 | 27.16 | 30.0001s | 0.09 | 0.14 | 20.17 | 0.35 | sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,99th fileio,1.0.20,1,4KiB,I/O,write,0.00,6953.30,6953.30,0.00,27.16,30.0001s,0.09,0.14,20.17,0.35 sysbench fileio cleanup sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup Code: # ./sysbench.sh mysqloltpnew setup sbt database & user mysqladmin create database: sbt Grants for sbtest@localhost GRANT USAGE ON *.* TO `sbtest`@`localhost` IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E' GRANT ALL PRIVILEGES ON `sbt`.* TO `sbtest`@`localhost` MySQL Buffers aria_pagecache_buffer_size 805306368 aria_sort_buffer_size 201326592 bulk_insert_buffer_size 8388608 innodb_buffer_pool_chunk_size 134217728 innodb_buffer_pool_dump_at_shutdown ON innodb_buffer_pool_dump_now OFF innodb_buffer_pool_dump_pct 25 innodb_buffer_pool_filename ib_buffer_pool innodb_buffer_pool_instances 1 innodb_buffer_pool_load_abort OFF innodb_buffer_pool_load_at_startup ON innodb_buffer_pool_load_now OFF innodb_buffer_pool_size 536870912 innodb_change_buffer_max_size 25 innodb_change_buffering all innodb_log_buffer_size 8388608 innodb_sort_buffer_size 2097152 join_buffer_size 262144 join_buffer_space_limit 2097152 key_buffer_size 268435456 mrr_buffer_size 262144 myisam_sort_buffer_size 268435456 net_buffer_length 16384 optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on preload_buffer_size 32768 read_buffer_size 262144 read_rnd_buffer_size 524288 sort_buffer_size 262144 sql_buffer_result OFF MySQL Limits aria_pagecache_division_limit 100 delayed_insert_limit 100 eq_range_index_dive_limit 0 expensive_subquery_limit 100 ft_query_expansion_limit 20 innodb_ft_result_cache_limit 2000000000 join_buffer_space_limit 2097152 key_cache_division_limit 100 log_slow_rate_limit 1 min_examined_row_limit 0 open_files_limit 65921 optimizer_selectivity_sampling_limit 100 query_cache_limit 1048576 read_binlog_speed_limit 0 relay_log_space_limit 0 sql_select_limit 18446744073709551615 thread_pool_stall_limit 500 updatable_views_with_limit YES MySQL Maxes aria_max_sort_file_size 9223372036853727232 extra_max_connections 1 ft_max_word_len 84 group_concat_max_len 1048576 innodb_adaptive_max_sleep_delay 150000 innodb_compression_pad_pct_max 50 innodb_ft_max_token_size 84 innodb_io_capacity_max 4166 innodb_max_dirty_pages_pct 75.000000 innodb_max_dirty_pages_pct_lwm 0.000000 innodb_max_purge_lag 0 innodb_max_purge_lag_delay 0 innodb_max_undo_log_size 10485760 innodb_online_alter_log_max_size 134217728 max_allowed_packet 67108864 max_binlog_cache_size 18446744073709547520 max_binlog_size 1073741824 max_binlog_stmt_cache_size 18446744073709547520 max_connect_errors 100000 max_connections 350 max_delayed_threads 20 max_digest_length 1024 max_error_count 64 max_heap_table_size 268435456 max_insert_delayed_threads 20 max_join_size 18446744073709551615 max_length_for_sort_data 1024 max_long_data_size 67108864 max_prepared_stmt_count 16382 max_recursive_iterations 4294967295 max_relay_log_size 1073741824 max_seeks_for_key 4294967295 max_session_mem_used 9223372036854775807 max_sort_length 1024 max_sp_recursion_depth 0 max_statement_time 0.000000 max_tmp_tables 32 max_user_connections 0 max_write_lock_count 4294967295 myisam_max_sort_file_size 2147483648 slave_max_allowed_packet 1073741824 slave_parallel_max_queued 131072 thread_pool_max_threads 65536 wsrep_max_ws_rows 0 wsrep_max_ws_size 2147483647 MySQL Concurrency concurrent_insert ALWAYS innodb_commit_concurrency 0 innodb_concurrency_tickets 5000 innodb_thread_concurrency 12 thread_concurrency 10 MySQL Read/Write delay_key_write ON idle_write_transaction_timeout 0 innodb_disallow_writes OFF innodb_doublewrite ON innodb_log_write_ahead_size 8192 innodb_use_atomic_writes ON max_write_lock_count 4294967295 net_write_timeout 60 wsrep_causal_reads OFF wsrep_dirty_reads OFF MySQL Threads aria_repair_threads 1 binlog_optimize_thread_scheduling ON debug_no_thread_alarm OFF innodb_encryption_threads 0 innodb_purge_threads 2 innodb_read_io_threads 2 innodb_thread_concurrency 12 innodb_thread_sleep_delay 0 innodb_write_io_threads 2 max_delayed_threads 20 max_insert_delayed_threads 20 myisam_repair_threads 1 performance_schema_max_thread_classes 50 performance_schema_max_thread_instances -1 slave_domain_parallel_threads 0 slave_parallel_threads 0 thread_cache_size 256 thread_concurrency 10 thread_handling one-thread-per-connection thread_pool_idle_timeout 60 thread_pool_max_threads 65536 thread_pool_oversubscribe 3 thread_pool_prio_kickup_timer 1000 thread_pool_priority auto thread_pool_size 4 thread_pool_stall_limit 500 thread_stack 299008 wsrep_slave_threads 1 MySQL Binlog binlog_annotate_row_events ON binlog_cache_size 32768 binlog_checksum CRC32 binlog_commit_wait_count 0 binlog_commit_wait_usec 100000 binlog_direct_non_transactional_updates OFF binlog_file_cache_size 16384 binlog_format MIXED binlog_optimize_thread_scheduling ON binlog_row_image FULL binlog_stmt_cache_size 32768 encrypt_binlog OFF gtid_binlog_pos gtid_binlog_state innodb_locks_unsafe_for_binlog OFF log_bin OFF log_bin_basename log_bin_compress OFF log_bin_compress_min_len 256 log_bin_index log_bin_trust_function_creators OFF max_binlog_cache_size 18446744073709547520 max_binlog_size 1073741824 max_binlog_stmt_cache_size 18446744073709547520 read_binlog_speed_limit 0 sql_log_bin ON sync_binlog 0 wsrep_forced_binlog_format NONE MySQL InnoDB ignore_builtin_innodb OFF innodb_adaptive_flushing ON innodb_adaptive_flushing_lwm 10.000000 innodb_adaptive_hash_index ON innodb_adaptive_hash_index_parts 8 innodb_adaptive_max_sleep_delay 150000 innodb_autoextend_increment 64 innodb_autoinc_lock_mode 1 innodb_background_scrub_data_check_interval 3600 innodb_background_scrub_data_compressed OFF innodb_background_scrub_data_interval 604800 innodb_background_scrub_data_uncompressed OFF innodb_buf_dump_status_frequency 0 innodb_buffer_pool_chunk_size 134217728 innodb_buffer_pool_dump_at_shutdown ON innodb_buffer_pool_dump_now OFF innodb_buffer_pool_dump_pct 25 innodb_buffer_pool_filename ib_buffer_pool innodb_buffer_pool_instances 1 innodb_buffer_pool_load_abort OFF innodb_buffer_pool_load_at_startup ON innodb_buffer_pool_load_now OFF innodb_buffer_pool_size 536870912 innodb_change_buffer_max_size 25 innodb_change_buffering all innodb_checksum_algorithm crc32 innodb_checksums ON innodb_cmp_per_index_enabled OFF innodb_commit_concurrency 0 innodb_compression_algorithm zlib innodb_compression_default OFF innodb_compression_failure_threshold_pct 5 innodb_compression_level 6 innodb_compression_pad_pct_max 50 innodb_concurrency_tickets 5000 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir innodb_deadlock_detect ON innodb_default_encryption_key_id 1 innodb_default_row_format dynamic innodb_defragment ON innodb_defragment_fill_factor 0.900000 innodb_defragment_fill_factor_n_recs 20 innodb_defragment_frequency 40 innodb_defragment_n_pages 7 innodb_defragment_stats_accuracy 0 innodb_disable_sort_file_cache OFF innodb_disallow_writes OFF innodb_doublewrite ON innodb_encrypt_log OFF innodb_encrypt_tables OFF innodb_encrypt_temporary_tables OFF innodb_encryption_rotate_key_age 1 innodb_encryption_rotation_iops 100 innodb_encryption_threads 0 innodb_fast_shutdown 1 innodb_fatal_semaphore_wait_threshold 600 innodb_file_format innodb_file_per_table ON innodb_fill_factor 100 innodb_flush_log_at_timeout 1 innodb_flush_log_at_trx_commit 2 innodb_flush_method O_DIRECT innodb_flush_neighbors 0 innodb_flush_sync ON innodb_flushing_avg_loops 30 innodb_force_load_corrupted OFF innodb_force_primary_key OFF innodb_force_recovery 0 innodb_ft_aux_table innodb_ft_cache_size 8000000 innodb_ft_enable_diag_print OFF innodb_ft_enable_stopword ON innodb_ft_max_token_size 84 innodb_ft_min_token_size 3 innodb_ft_num_word_optimize 2000 innodb_ft_result_cache_limit 2000000000 innodb_ft_server_stopword_table innodb_ft_sort_pll_degree 2 innodb_ft_total_cache_size 640000000 innodb_ft_user_stopword_table innodb_idle_flush_pct 100 innodb_immediate_scrub_data_uncompressed OFF innodb_instant_alter_column_allowed add_last innodb_io_capacity 2500 innodb_io_capacity_max 4166 innodb_large_prefix innodb_lock_schedule_algorithm fcfs innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_checksums ON innodb_log_compressed_pages ON innodb_log_file_size 268435456 innodb_log_files_in_group 2 innodb_log_group_home_dir ./ innodb_log_optimize_ddl ON innodb_log_write_ahead_size 8192 innodb_lru_scan_depth 1024 innodb_max_dirty_pages_pct 75.000000 innodb_max_dirty_pages_pct_lwm 0.000000 innodb_max_purge_lag 0 innodb_max_purge_lag_delay 0 innodb_max_undo_log_size 10485760 innodb_monitor_disable innodb_monitor_enable innodb_monitor_reset innodb_monitor_reset_all innodb_old_blocks_pct 37 innodb_old_blocks_time 1000 innodb_online_alter_log_max_size 134217728 innodb_open_files 4000 innodb_optimize_fulltext_only OFF innodb_page_cleaners 1 innodb_page_size 16384 innodb_prefix_index_cluster_optimization OFF innodb_print_all_deadlocks OFF innodb_purge_batch_size 300 innodb_purge_rseg_truncate_frequency 128 innodb_purge_threads 2 innodb_random_read_ahead OFF innodb_read_ahead_threshold 56 innodb_read_io_threads 2 innodb_read_only OFF innodb_replication_delay 0 innodb_rollback_on_timeout OFF innodb_rollback_segments 128 innodb_scrub_log OFF innodb_scrub_log_speed 256 innodb_sort_buffer_size 2097152 innodb_spin_wait_delay 4 innodb_stats_auto_recalc ON innodb_stats_include_delete_marked OFF innodb_stats_method nulls_equal innodb_stats_modified_counter 0 innodb_stats_on_metadata OFF innodb_stats_persistent ON innodb_stats_persistent_sample_pages 20 innodb_stats_sample_pages 8 innodb_stats_traditional ON innodb_stats_transient_sample_pages 8 innodb_status_output OFF innodb_status_output_locks OFF innodb_strict_mode ON innodb_sync_array_size 1 innodb_sync_spin_loops 30 innodb_table_locks ON innodb_temp_data_file_path ibtmp1:12M:autoextend innodb_thread_concurrency 12 innodb_thread_sleep_delay 0 innodb_tmpdir innodb_undo_directory ./ innodb_undo_log_truncate OFF innodb_undo_logs 128 innodb_undo_tablespaces 0 innodb_use_atomic_writes ON innodb_use_native_aio ON innodb_version 10.3.23 innodb_write_io_threads 2 sysbench prepare database: sbt sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Initializing worker threads... Creating table 'sbtest2'... Creating table 'sbtest4'... Creating table 'sbtest1'... Creating table 'sbtest3'... Inserting 150000 records into 'sbtest3' Inserting 150000 records into 'sbtest1' Inserting 150000 records into 'sbtest2' Inserting 150000 records into 'sbtest4' Creating a secondary index on 'sbtest3'... Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest1'... Creating a secondary index on 'sbtest4'... Creating table 'sbtest7'... Inserting 150000 records into 'sbtest7' Creating table 'sbtest6'... Inserting 150000 records into 'sbtest6' Creating table 'sbtest8'... Inserting 150000 records into 'sbtest8' Creating table 'sbtest5'... Inserting 150000 records into 'sbtest5' Creating a secondary index on 'sbtest6'... Creating a secondary index on 'sbtest8'... Creating a secondary index on 'sbtest5'... Creating a secondary index on 'sbtest7'... +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+ | Table Name | Number of Rows | Storage Engine | Data Size | Index Size | Total | ROW_FORMAT | TABLE_COLLATION | +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+ | sbt.sbtest2 | 148032 Rows | InnoDB | 32.56MB | 2.52MB | 35.08MB | Dynamic | utf8_general_ci | | sbt.sbtest4 | 148032 Rows | InnoDB | 32.56MB | 2.52MB | 35.08MB | Dynamic | utf8_general_ci | | sbt.sbtest8 | 150000 Rows | InnoDB | 0.02MB | 2.52MB | 2.53MB | Dynamic | utf8_general_ci | | sbt.sbtest1 | 149967 Rows | InnoDB | 1.52MB | 2.52MB | 4.03MB | Dynamic | utf8_general_ci | | sbt.sbtest7 | 150000 Rows | InnoDB | 0.02MB | 2.52MB | 2.53MB | Dynamic | utf8_general_ci | | sbt.sbtest3 | 150000 Rows | InnoDB | 0.08MB | 2.52MB | 2.59MB | Dynamic | utf8_general_ci | | sbt.sbtest5 | 150000 Rows | InnoDB | 0.02MB | 2.52MB | 2.53MB | Dynamic | utf8_general_ci | | sbt.sbtest6 | 150000 Rows | InnoDB | 0.02MB | 2.52MB | 2.53MB | Dynamic | utf8_general_ci | +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+ sysbench mysql OLTP new benchmark: sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 4 Report intermediate results every 1 second(s) Initializing random number generator from seed (1). Initializing worker threads... Threads started! [ 1s ] thds: 4 tps: 982.33 qps: 19671.46 (r/w/o: 13773.52/3929.30/1968.64) lat (ms,95%): 5.67 err/s: 0.00 reconn/s: 0.00 [ 2s ] thds: 4 tps: 1017.81 qps: 20378.15 (r/w/o: 14269.31/4073.23/2035.62) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00 [ 3s ] thds: 4 tps: 1064.95 qps: 21296.90 (r/w/o: 14905.23/4261.78/2129.89) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 4s ] thds: 4 tps: 1058.33 qps: 21168.67 (r/w/o: 14819.67/4232.33/2116.67) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 5s ] thds: 4 tps: 1073.00 qps: 21440.08 (r/w/o: 15005.06/4289.02/2146.01) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 6s ] thds: 4 tps: 1089.96 qps: 21805.20 (r/w/o: 15262.44/4362.84/2179.92) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00 [ 7s ] thds: 4 tps: 1067.83 qps: 21363.53 (r/w/o: 14959.57/4268.31/2135.65) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 8s ] thds: 4 tps: 1062.00 qps: 21260.93 (r/w/o: 14884.95/4251.99/2123.99) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00 [ 9s ] thds: 4 tps: 1094.18 qps: 21869.55 (r/w/o: 15304.48/4376.71/2188.35) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00 [ 10s ] thds: 4 tps: 1080.03 qps: 21583.50 (r/w/o: 15107.35/4316.10/2160.05) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 11s ] thds: 4 tps: 1074.98 qps: 21516.52 (r/w/o: 15064.66/4301.90/2149.95) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00 [ 12s ] thds: 4 tps: 1065.85 qps: 21323.02 (r/w/o: 14927.92/4263.40/2131.70) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00 [ 13s ] thds: 4 tps: 1084.13 qps: 21666.70 (r/w/o: 15164.89/4334.54/2167.27) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00 [ 14s ] thds: 4 tps: 1086.71 qps: 21764.29 (r/w/o: 15236.00/4353.86/2174.43) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00 [ 15s ] thds: 4 tps: 1110.29 qps: 22176.87 (r/w/o: 15521.11/4435.17/2220.59) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00 [ 16s ] thds: 4 tps: 1076.05 qps: 21517.06 (r/w/o: 15061.74/4303.21/2152.11) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 17s ] thds: 4 tps: 1086.96 qps: 21747.25 (r/w/o: 15225.47/4347.85/2173.92) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 18s ] thds: 4 tps: 1081.97 qps: 21631.35 (r/w/o: 15138.54/4328.87/2163.93) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00 [ 19s ] thds: 4 tps: 1068.94 qps: 21385.71 (r/w/o: 14973.10/4274.74/2137.87) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00 [ 20s ] thds: 4 tps: 1081.70 qps: 21641.01 (r/w/o: 15147.80/4329.80/2163.40) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00 [ 21s ] thds: 4 tps: 1094.40 qps: 21891.99 (r/w/o: 15327.60/4375.60/2188.80) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00 [ 22s ] thds: 4 tps: 1074.02 qps: 21446.32 (r/w/o: 15003.22/4295.06/2148.03) lat (ms,95%): 5.28 err/s: 0.00 reconn/s: 0.00 [ 23s ] thds: 4 tps: 1060.67 qps: 21250.39 (r/w/o: 14886.37/4242.68/2121.34) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 24s ] thds: 4 tps: 1085.33 qps: 21683.61 (r/w/o: 15171.62/4341.32/2170.66) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 25s ] thds: 4 tps: 1091.99 qps: 21855.89 (r/w/o: 15301.92/4369.98/2183.99) lat (ms,95%): 4.41 err/s: 0.00 reconn/s: 0.00 [ 26s ] thds: 4 tps: 1074.99 qps: 21489.81 (r/w/o: 15041.87/4297.96/2149.98) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00 [ 27s ] thds: 4 tps: 1076.49 qps: 21543.88 (r/w/o: 15080.92/4309.98/2152.99) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00 [ 28s ] thds: 4 tps: 1073.42 qps: 21460.46 (r/w/o: 15023.92/4289.69/2146.85) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00 [ 29s ] thds: 4 tps: 1064.14 qps: 21277.83 (r/w/o: 14891.98/4257.57/2128.28) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00 [ 30s ] thds: 4 tps: 1106.62 qps: 22137.42 (r/w/o: 15494.70/4429.48/2213.24) lat (ms,95%): 4.33 err/s: 0.00 reconn/s: 0.00 SQL statistics: queries performed: read: 451024 write: 128864 other: 64432 total: 644320 transactions: 32216 (1073.53 per sec.) queries: 644320 (21470.70 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 30.0078s total number of events: 32216 Latency (ms): min: 2.81 avg: 3.72 max: 15.71 95th percentile: 4.91 sum: 119919.95 Threads fairness: events (avg/stddev): 8054.0000/82.86 execution time (avg/stddev): 29.9800/0.00 sysbench mysql OLTP new summary: sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) threads: 4 read: 451024 write: 128864 other: 64432 total: 644320 transactions/s: 1073.53 queries/s: 21470.70 time: 30.0078s min: 2.81 avg: 3.72 max: 15.71 95th: 4.91 | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | oltp_read_write.lua | 1.0.20 | 4 | 451024 | 128864 | 64432 | 644320 | 1073.53 | 21470.70 | 30.0078s | 2.81 | 3.72 | 15.71 | 4.91 | sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th oltp_read_write.lua,1.0.20,4,451024,128864,64432,644320,1073.53,21470.70,30.0078s,2.81,3.72,15.71,4.91 sysbench mysql cleanup database: sbt sysbench oltp_read_write.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-storage-engine=InnoDB --time=30 --threads=4 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Dropping table 'sbtest1'... Dropping table 'sbtest2'... Dropping table 'sbtest3'... Dropping table 'sbtest4'... Dropping table 'sbtest5'... Dropping table 'sbtest6'... Dropping table 'sbtest7'... Dropping table 'sbtest8'...
very nice ! From memory that is at least 12x times faster multi threaded cpu performance and 20x times MySQL OLTP benchmark performance over your slow ssdnodes 6 cpu core VPS !
yup, linode got good support and ate generally more reliable than the competition, as far as real life SLAs are observed. however, this node and the 7601 epyc are poor. most of the people here rely on single core performance. memory , crypto, disk... meh, doesn't help say WordPress or ecommerce. I tested all of their nodes including dedicated 8cpu , and I'm not liking the results. Vultr consistently lands faster observed, measurable, realistic performance. im running production on linode but considering moving to Vultr over value for money.
Yes the 1st generation AMD EPYC are slower cpu clock speed wise compared to Intel. Hope Linode eventually moves to higher clock speed AMD EPYC Rome 2nd generation. Depends on web apps if single or multi-core usage is required. If you have alot of highly concurrent traffic, multiple cores would be more beneficial and Linode dedicated cpu line has a better per cpu core $$$ price once past 4+ cpu cores. Vultr standard 4 and 8 cpu core VPS is US$40 and US$160 per month and Vultr high cpu frequency 4 and 8 cpu core VPS are priced at US$96 and US$192/month. While Linode dedicated 4 and 8 cpu VPS are at US$60 and US$120/month.
I have logged detailed benchmarks for my own use case, disclosing them would serve no purpose i'm afraid. I did make some quick Geekbench tests on the nodes I tried. those I can easily share- Vultr 'High Frequency Compute' 3core $48/mo QEMU Standard PC (i440FX + PIIX, 1996) - Geekbench Browser Vultr 'Standard' 4core $40/mo QEMU Standard PC (i440FX + PIIX, 1996) - Geekbench Browser Linode 'Shared Plan' 4core $40/mo (AMD EPYC 7601) QEMU Standard PC (Q35 + ICH9, 2009) - Geekbench Browser Linode 'Dedicated Plan' 4core $60/mo (AMD EPYC 7601) QEMU Standard PC (Q35 + ICH9, 2009) - Geekbench Browser
Yup. Exactly what I think too. I'll also say that Vultr "high frequency compute" nodes (above 2 threads) are priced in a way that just does not justify getting any of them at all. I still observed CPU steal on them, so i'm not even sure they claim those are 'dedicated'. I love the single-thread performance. but not if multi-thread suffers (3 cpu threads only!!). Too expensive for what they offer. at least in my opinion.
Vultr high frequency cpu VPS aren't dedicated cpus they're shared. Only Vultr dedicated cpu line ones are dedicated at US$60/month for 2 cpus and US$120/month for 4 cpus and US$180/month for 6 cpus and US$240/month for 8 cpus https://www.vultr.com/products/dedicated-cloud/
Ah, that explains it! And holy hell, those prices are horrible. I calculated that even with constant 25% cpu steal, the performance is almost on par with half-priced shared nodes! Linode hit the sweet spot with their $60 nodes in my opinion. So sad that their performance is not on par with the competition, even on dedicated. can be clearly inferred from the simple Geekbench scores above.
Geekbench wouldn't be indicative for all LEMP stack performance as it isn't all about cpu only DigitalOcean - Linode - Vultr - Benchmarks - Upcloud - 13-Way VPS Server Benchmark Comparison Tests - Upcloud vs DigitalOcean vs Linode vs Vultr vs Hetzner and as I touched on before, Linode differentiates itself in other features to other providers i.e. disk storage layer resilience and ability to clone and migrate VPS between VPS host nodes at a touch of button within dashboard and also speed of VPS data migration between VPS host ndoes is at least 2-20x times faster than other VPS providers who have that feature. For example when a Linode VPS disk has issues, Linode dashboard can alert you and have a button to just transfer your entire Linode VPS to a different VPS host node and it can transfer that data at up to 100-200MB/s which is also speed of their backups. DigitalOcean speed is ~1/10th of that. And IIRC, Vultr doesn't have such VPS clone/data migration between VPS host nodes. Though you can probably script a full VPS data migration process yourself that does 1 to 1 VPS server transfer externally - I'm writing/testing such for Centmin Mod to Centmin Mod data transfer/backups. But convenience of Linode to be able to clone VPS is handy i.e. setup staging test VPS servers with an exact 1:1 copy of your entire Linode VPS server with all web app/configs being identical.
fully agree! production use, Linode is far superior in serviceability. I love their platform. their services are rock solid. I tested Vultr for one week!! and had an Hardware issue with my server, full downtime of about 2h, support had to step in and hard-restart the server manually. Linode also offers faster level-2 support or engineering. I'm really happy with what they provide as a whole, as a platform. Butttt I wish they update their servers with current hardware that benefits from recent crypto performance gains. I wish they'd let us pick between (current gen) single thread focused, High frequency cpu threads (3.70GHz+) and lowfreq high multicore performance, like 2.20GHz even . AMD EPYC2 7000 etc as for storage, you're right. they're much faster in migrations than the competition. still want to see faster Block storage, as performance not on par. NVMe controllers with option for high redundancy or high performance via RAID (or just allocate faster disk IOPS and sustained write speed , random read/write)
+1 production use much better support +1 yup, there are linode twitter posts which mention they are testing AMD EPYC 2 Rome right now so it's on their roadmap - just waiting game and well Linode VPS host node migrations make it easier to transfer your Linode VPS to a new AMD EPYC 2 Rome host node when the time comes oh yes, one poor feature is Linode block storage - it's too slow due to triple redundancy like OVH's triple redudndancy or any providers offering triple redundancy. Linode further made it slower via artificially capped performance on Linode block storage (below quote). So use Linode native SSD storage and not block storage
Wow! great news! hope to win the linode lottery and get to spin one up! Also, with all of the hosting tests you've published, and valuable information such as the above - Why don't you publish all of this info and tips in the main website / setup guide, along with affiliate links to the mentioned hosting services? It's not bias to recommend stuff too, if backed by test results. which you've already done. thoroughly.
Forums drive activity/interest and well easier to write up right now. Eventually centminmod.com main site will be updated when I have time - will be when 123.09beta01 goes stable as I have to update all site documentation too Though benchmarks are listed at Benchmarks - CentminMod.com LEMP Nginx web stack for CentOS