Join the community today
Register Now

Linode Linode 8 GB - 4 CPU Benchmarks

Discussion in 'Virtual Private Server (VPS) hosting' started by Jimmy, Jul 3, 2020.

  1. Jimmy

    Jimmy Well-Known Member

    1,704
    365
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +923
    Local Time:
    3:22 AM
    1.17.x
    MariaDB 10.3.x
    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'...
    

     
  2. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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 !
     
  3. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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.
     
  4. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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.
     
  5. Jimmy

    Jimmy Well-Known Member

    1,704
    365
    83
    Oct 24, 2015
    East Coast USA
    Ratings:
    +923
    Local Time:
    3:22 AM
    1.17.x
    MariaDB 10.3.x
    Do you have any test data you can post?
     
  6. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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
     
  7. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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.

     
    Last edited: Jul 7, 2020
  8. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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/
     
  9. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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.

     
  10. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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.
     
  11. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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)

     
  12. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    +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 ;)

     
  13. Salmon Skin

    Salmon Skin New Member

    14
    1
    3
    Oct 15, 2019
    Ratings:
    +6
    Local Time:
    9:22 AM
    1.17.4
    10.4
    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. ;)

     
  14. eva2000

    eva2000 Administrator Staff Member

    44,691
    10,193
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,794
    Local Time:
    5:22 PM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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 :)