Welcome to Centmin Mod Community
Become a Member

Upcloud AMD EPYC cpus come to Upcloud VPS provider

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

  1. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Got an email of good news that Upcloud hourly billing VPS provider has a new datacenter, New York open for business with new AMD EPYC cpus mixed in to that datacenter as well as other datacenters :D

    Check them out at Upcloud.com - get US$25 credit yourself when you sign up ;)


     
  2. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Nice Upcloud New York datacenter
    Code (Text):
    lscpu
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             AuthenticAMD
    CPU family:            23
    Model:                 49
    Model name:            AMD EPYC 7542 32-Core Processor
    Stepping:              0
    CPU MHz:               2894.560
    BogoMIPS:              5789.12
    Hypervisor vendor:     KVM
    Virtualization type:   full
    NUMA node0 CPU(s):     0,1
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    

    Upcloud San Jose datacenter
    Code (Text):
    lscpu
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 85
    Model name:            Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz
    Stepping:              4
    CPU MHz:               2992.968
    BogoMIPS:              5985.93
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0,1
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    

    Did a quick Centmin Mod 123.09beta01 LEMP stack install test on CentOS 7 64bit with default PHP 7.3 installer via command
    Code (Text):
    yum -y update; curl -O https://centminmod.com/betainstaller73.sh && chmod 0700 betainstaller73.sh && bash betainstaller73.sh


    Upcloud AMD EPYC 7542 with 2 cpu KVM VPS installed in 959.4105 seconds
    Code (Text):
    ---------------------------------------------------------------------------
    Total Curl Installer YUM or DNF Time: 84.4146 seconds
    Total YUM Time: 9.519482040 seconds
    Total YUM or DNF + Source Download Time: 37.7431
    Total Nginx First Time Install Time: 206.3438
    Total PHP First Time Install Time: 333.9281
    Download From Github Time: 1.5237
    Total Time Other eg. source compiles: 295.4572
    Total Centmin Mod Install Time: 873.4722
    ---------------------------------------------------------------------------
    Total Install Time (curl yum + cm install + zip download): 959.4105 seconds
    ---------------------------------------------------------------------------
    2 AMD EPYC 7542 32-Core Processor
    2 2894.560
    ---------------------------------------------------------------------------
    

    Upcloud Intel Xeon Gold 6136 Scable with 2 cpu KVM VPS installed in 1633.2845 seconds
    Code (Text):
    ---------------------------------------------------------------------------
    Total Curl Installer YUM or DNF Time: 193.7184 seconds
    Total YUM Time: 14.899177665 seconds
    Total YUM or DNF + Source Download Time: 52.1745
    Total Nginx First Time Install Time: 314.5624
    Total PHP First Time Install Time: 520.7203
    Download From Github Time: 2.2655
    Total Time Other eg. source compiles: 549.8434
    Total Centmin Mod Install Time: 1437.3006
    ---------------------------------------------------------------------------
    Total Install Time (curl yum + cm install + zip download): 1633.2845 seconds
    ---------------------------------------------------------------------------
    2 Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz
    2 2992.968
    ---------------------------------------------------------------------------
    
     
    Last edited: Oct 21, 2020
  3. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    for @tininho yes proper znver2 cpu march is configured if you re-enable native march support in persistent config file /etc/centminmod/custom_config.inc (it's disable on linode, vultr, digitalocean, upcloud with MARCH_TARGETNATIVE='n' by default) due to the many different cpu models you can land on which can cause illegal instructions errors if you move from one VPS to another via clone full VPS migration between 2 different cpu models. In which case you would need to recompile nginx and php-fpm via centmin.sh menu option 4, 5 and re-run centmin.sh menu option 10 if you set MARCH_TARGETNATIVE='y' on such web host providers after migrating to different cpu model VPS nodes.
    with persistent config file /etc/centminmod/custom_config.inc enabled for GCC 9 instead of default GCC 8 and do a nginx recompile to install GCC 9 and re-enable MARCH_TARGETNATIVE='y'
    Code (Text):
    DEVTOOLSETEIGHT='n'
    DEVTOOLSETNINE='y'
    MARCH_TARGETNATIVE='y'
    

    on AMD EPYC 7542 VPS march target is znver2
    Code (Text):
    /opt/rh/devtoolset-9/root/usr/bin/gcc -c -Q -march=native --help=target 2>&1 | grep '\-march'
      -march=                               znver2
    

    on Intel Xeon Gold 6136 VPS and march target is skylake-avx512
    Code (Text):
    /opt/rh/devtoolset-9/root/usr/bin/gcc -c -Q -march=native --help=target 2>&1 | grep '\-march'
      -march=                               skylake-avx512
    

    Comparing GCC 9 march native target supported cpu flags differences only from Intel skylake-avx12 vs znver2 (right)
    Code (Text):
    sdiff -s skylake.txt znver2.txt
      -march=                               skylake-avx512        |   -march=                               znver2
      -mavx512bw                            [enabled]             |   -mavx512bw                            [disabled]
      -mavx512cd                            [enabled]             |   -mavx512cd                            [disabled]
      -mavx512dq                            [enabled]             |   -mavx512dq                            [disabled]
      -mavx512f                             [enabled]             |   -mavx512f                             [disabled]
      -mavx512vl                            [enabled]             |   -mavx512vl                            [disabled]
      -mhle                                 [enabled]             |   -mhle                                 [disabled]
      -mpku                                 [enabled]             |   -mpku                                 [disabled]
      -mprefer-vector-width=                256                   |   -mprefer-vector-width=                none
      -mrtm                                 [enabled]             |   -mrtm                                 [disabled]
      -msha                                 [disabled]            |   -msha                                 [enabled]
      -msse4a                               [disabled]            |   -msse4a                               [enabled]
      -mtune=                               skylake-avx512        |   -mtune=                               znver2
      -mxsaves                              [enabled]             |   -mxsaves                              [disabled]
    

    universal diff
    Code (Text):
    diff -u skylake.txt znver2.txt
    --- skylake.txt 2020-07-24 04:24:31.573428126 +0000
    +++ znver2.txt  2020-07-24 04:25:30.448101505 +0000
    @@ -22,7 +22,7 @@
       -malign-loops=                        0
       -malign-stringops                     [enabled]
       -mandroid                             [disabled]
    -  -march=                               skylake-avx512
    +  -march=                               znver2
       -masm=                                att
       -mavx                                 [enabled]
       -mavx2                                [enabled]
    @@ -31,16 +31,16 @@
       -mavx5124fmaps                        [disabled]
       -mavx5124vnniw                        [disabled]
       -mavx512bitalg                        [disabled]
    -  -mavx512bw                            [enabled]
    -  -mavx512cd                            [enabled]
    -  -mavx512dq                            [enabled]
    +  -mavx512bw                            [disabled]
    +  -mavx512cd                            [disabled]
    +  -mavx512dq                            [disabled]
       -mavx512er                            [disabled]
    -  -mavx512f                             [enabled]
    +  -mavx512f                             [disabled]
       -mavx512ifma                          [disabled]
       -mavx512pf                            [disabled]
       -mavx512vbmi                          [disabled]
       -mavx512vbmi2                         [disabled]
    -  -mavx512vl                            [enabled]
    +  -mavx512vl                            [disabled]
       -mavx512vnni                          [disabled]
       -mavx512vpopcntdq                     [disabled]
       -mbionic                              [disabled]
    @@ -79,7 +79,7 @@
       -mgfni                                [disabled]
       -mglibc                               [enabled]
       -mhard-float                          [enabled]
    -  -mhle                                 [enabled]
    +  -mhle                                 [disabled]
       -miamcu                               [disabled]
       -mieee-fp                             [enabled]
       -mincoming-stack-boundary=            0
    @@ -121,10 +121,10 @@
       -mpclmul                              [enabled]
       -mpcommit                             [disabled]
       -mpconfig                             [disabled]
    -  -mpku                                 [enabled]
    +  -mpku                                 [disabled]
       -mpopcnt                              [enabled]
       -mprefer-avx128       
    -  -mprefer-vector-width=                256
    +  -mprefer-vector-width=                none
       -mpreferred-stack-boundary=           0
       -mprefetchwt1                         [disabled]
       -mprfchw                              [enabled]
    @@ -140,10 +140,10 @@
       -mred-zone                            [enabled]
       -mregparm=                            6
       -mrtd                                 [disabled]
    -  -mrtm                                 [enabled]
    +  -mrtm                                 [disabled]
       -msahf                                [enabled]
       -msgx                                 [disabled]
    -  -msha                                 [disabled]
    +  -msha                                 [enabled]
       -mshstk                               [disabled]
       -mskip-rax-setup                      [disabled]
       -msoft-float                          [disabled]
    @@ -154,7 +154,7 @@
       -msse4                                [enabled]
       -msse4.1                              [enabled]
       -msse4.2                              [enabled]
    -  -msse4a                               [disabled]
    +  -msse4a                               [enabled]
       -msse5               
       -msseregparm                          [disabled]
       -mssse3                               [enabled]
    @@ -170,7 +170,7 @@
       -mtls-dialect=                        gnu
       -mtls-direct-seg-refs                 [enabled]
       -mtune-ctrl=         
    -  -mtune=                               skylake-avx512
    +  -mtune=                               znver2
       -muclibc                              [disabled]
       -mvaes                                [disabled]
       -mveclibabi=                          [default]
    @@ -184,7 +184,7 @@
       -mxsave                               [enabled]
       -mxsavec                              [enabled]
       -mxsaveopt                            [enabled]
    -  -mxsaves                              [enabled]
    +  -mxsaves                              [disabled]
       Known assembler dialects (for use with the -masm= option):
         att intel
    

    sysbench quick tests from centminmod/centminmod-sysbench
    Code (Text):
    mkdir -p /root/tools/sysbench
    cd /root/tools/sysbench
    wget -O /root/tools/sysbench/sysbench.sh https://github.com/centminmod/centminmod-sysbench/raw/master/sysbench.sh
    chmod +x sysbench.sh
    ./sysbench.sh install
    

    sysbench tests
    Code (Text):
    ./sysbench.sh cpu
    ./sysbench.sh mem
    ./sysbench.sh file
    ./sysbench.sh file-fsync
    ./sysbench.sh mysqloltpnew
    


    sysbench-cpu-01.png

    AMD EPYC 7542 VPS sysbench cpu
    Code (Text):
    ./sysbench.sh cpu
    -------------------------------------------
    System Information
    -------------------------------------------
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             AuthenticAMD
    CPU family:            23
    Model:                 49
    Model name:            AMD EPYC 7542 32-Core Processor
    Stepping:              0
    CPU MHz:               2894.560
    BogoMIPS:              5789.12
    Hypervisor vendor:     KVM
    Virtualization type:   full
    NUMA node0 CPU(s):     0,1
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    CPU NODE SOCKET CORE ONLINE
    0   0    0      0    yes
    1   0    1      1    yes
                  total        used        free      shared  buff/cache   available
    Mem:           3789         448        1836          19        1504        3054
    Low:           3789        1953        1836
    High:             0           0           0
    Swap:          1023           1        1022
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  6.0G   75G   8% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    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: 638.91
    time: 10.0007s
    min: 1.56
    avg: 1.56
    max: 1.73
    95th: 1.58
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.20 | 1 | 638.91 | 10.0007s | 1.56 | 1.56 | 1.73 | 1.58 |
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.20,1,638.91,10.0007s,1.56,1.56,1.73,1.58
    sysbench cpu --cpu-max-prime=20000 --threads=2 run
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    prime: 20000
    events/s: 1275.30
    time: 10.0016s
    min: 1.56
    avg: 1.57
    max: 6.05
    95th: 1.58
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.20 | 2 | 1275.30 | 10.0016s | 1.56 | 1.57 | 6.05 | 1.58 |
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.20,2,1275.30,10.0016s,1.56,1.57,6.05,1.58 

    Intel Xeon Gold 6136 sysbench cpu
    Code (Text):
    ./sysbench.sh cpu
    -------------------------------------------
    System Information
    -------------------------------------------
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 85
    Model name:            Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz
    Stepping:              4
    CPU MHz:               2992.968
    BogoMIPS:              5985.93
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0,1
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    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
                  total        used        free      shared  buff/cache   available
    Mem:           3789         421        1940          19        1427        3093
    Low:           3789        1848        1940
    High:             0           0           0
    Swap:          1023           0        1023
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  5.6G   75G   7% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    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: 456.32
    time: 10.0005s
    min: 2.11
    avg: 2.19
    max: 2.82
    95th: 2.43
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.20 | 1 | 456.32 | 10.0005s | 2.11 | 2.19 | 2.82 | 2.43 |
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.20,1,456.32,10.0005s,2.11,2.19,2.82,2.43
    sysbench cpu --cpu-max-prime=20000 --threads=2 run
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    prime: 20000
    events/s: 900.03
    time: 10.0017s
    min: 2.11
    avg: 2.22
    max: 14.62
    95th: 2.48
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.20 | 2 | 900.03 | 10.0017s | 2.11 | 2.22 | 14.62 | 2.48 |
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.20,2,900.03,10.0017s,2.11,2.22,14.62,2.48 


    sysbench-mem-01.png

    AMD EPYC 7542 VPS sysbench mem
    Code (Text):
    ./sysbench.sh mem
    -------------------------------------------
    System Information
    -------------------------------------------
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             AuthenticAMD
    CPU family:            23
    Model:                 49
    Model name:            AMD EPYC 7542 32-Core Processor
    Stepping:              0
    CPU MHz:               2894.560
    BogoMIPS:              5789.12
    Hypervisor vendor:     KVM
    Virtualization type:   full
    NUMA node0 CPU(s):     0,1
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    CPU NODE SOCKET CORE ONLINE
    0   0    0      0    yes
    1   0    1      1    yes
                  total        used        free      shared  buff/cache   available
    Mem:           3789         448        1836          19        1504        3054
    Low:           3789        1953        1836
    High:             0           0           0
    Swap:          1023           1        1022
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  6.0G   75G   8% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    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 (6084785.39 per second)
    transferred (5942.17 MiB/sec)
    time: 0.1716s
    min: 0.00
    avg: 0.00
    max: 0.02
    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 | 5942.17 | 0.1716s | 0.00 | 0.00 | 0.02 | 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,5942.17,0.1716s,0.00,0.00,0.02,0.00
    sysbench memory --threads=2 --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: 2
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (9199414.27 per second)
    transferred (8983.80 MiB/sec)
    time: 0.1132s
    min: 0.00
    avg: 0.00
    max: 0.02
    95th: 0.00
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.20 | 2 | 1KiB | 1024MiB | read | 1048576 | 8983.80 | 0.1132s | 0.00 | 0.00 | 0.02 | 0.00 |
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.20,2,1KiB,1024MiB,read,1048576,8983.80,0.1132s,0.00,0.00,0.02,0.00 

    Intel Xeon Gold 6136 sysbench mem
    Code (Text):
    ./sysbench.sh mem
    -------------------------------------------
    System Information
    -------------------------------------------
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 85
    Model name:            Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz
    Stepping:              4
    CPU MHz:               2992.968
    BogoMIPS:              5985.93
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0,1
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    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
                  total        used        free      shared  buff/cache   available
    Mem:           3789         421        1939          19        1428        3092
    Low:           3789        1849        1939
    High:             0           0           0
    Swap:          1023           0        1023
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  5.6G   75G   7% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    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 (5742547.03 per second)
    transferred (5607.96 MiB/sec)
    time: 0.1812s
    min: 0.00
    avg: 0.00
    max: 0.07
    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 | 5607.96 | 0.1812s | 0.00 | 0.00 | 0.07 | 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,5607.96,0.1812s,0.00,0.00,0.07,0.00
    sysbench memory --threads=2 --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: 2
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (9199234.70 per second)
    transferred (8983.63 MiB/sec)
    time: 0.1127s
    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 | 2 | 1KiB | 1024MiB | read | 1048576 | 8983.63 | 0.1127s | 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,2,1KiB,1024MiB,read,1048576,8983.63,0.1127s,0.00,0.00,0.05,0.00 

    AMD EPYC 7542 VPS sysbench file
    Code (Text):
    ./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: 10702.94
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 41.81
    written-MiB/s: 0.00
    time: 10.0000s
    min: 0.07
    avg: 0.09
    max: 1.31
    95th: 0.10
    | 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 | 10702.94 | 0.00 | 0.00 | 41.81 | 0.00 | 10.0000s | 0.07 | 0.09 | 1.31 | 0.10 |
    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,10702.94,0.00,0.00,41.81,0.00,10.0000s,0.07,0.09,1.31,0.10
    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: 5147.36
    fsyncs/s: 6590.03
    read-MiB/s: 0.00
    written-MiB/s: 20.11
    time: 10.0022s
    min: 0.01
    avg: 0.09
    max: 1.19
    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 | 1 | 4KiB | I/O | write | 0.00 | 5147.36 | 6590.03 | 0.00 | 20.11 | 10.0022s | 0.01 | 0.09 | 1.19 | 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,1,4KiB,I/O,write,0.00,5147.36,6590.03,0.00,20.11,10.0022s,0.01,0.09,1.19,0.20
    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: 10511.22
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 41.06
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.07
    avg: 0.09
    max: 4.85
    95th: 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 | 10511.22 | 0.00 | 0.00 | 41.06 | 0.00 | 10.0001s | 0.07 | 0.09 | 4.85 | 0.11 |
    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,10511.22,0.00,0.00,41.06,0.00,10.0001s,0.07,0.09,4.85,0.11
    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: 4757.39
    fsyncs/s: 6090.36
    read-MiB/s: 0.00
    written-MiB/s: 18.58
    time: 10.0033s
    min: 0.02
    avg: 0.09
    max: 46.25
    95th: 0.21
    | 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 | 4757.39 | 6090.36 | 0.00 | 18.58 | 10.0033s | 0.02 | 0.09 | 46.25 | 0.21 |
    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,4757.39,6090.36,0.00,18.58,10.0033s,0.02,0.09,46.25,0.21
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 19803.25
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 77.36
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.07
    avg: 0.10
    max: 1.48
    95th: 0.12
    | 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 | 2 | 4KiB | I/O | read | 19803.25 | 0.00 | 0.00 | 77.36 | 0.00 | 10.0001s | 0.07 | 0.10 | 1.48 | 0.12 |
    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,2,4KiB,I/O,read,19803.25,0.00,0.00,77.36,0.00,10.0001s,0.07,0.10,1.48,0.12
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 4720.22
    fsyncs/s: 6063.50
    read-MiB/s: 0.00
    written-MiB/s: 18.44
    time: 10.0053s
    min: 0.01
    avg: 0.19
    max: 5.61
    95th: 0.42
    | 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 | 2 | 4KiB | I/O | write | 0.00 | 4720.22 | 6063.50 | 0.00 | 18.44 | 10.0053s | 0.01 | 0.19 | 5.61 | 0.42 |
    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,2,4KiB,I/O,write,0.00,4720.22,6063.50,0.00,18.44,10.0053s,0.01,0.19,5.61,0.42
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 20259.77
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 79.14
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.07
    avg: 0.10
    max: 2.50
    95th: 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 | 2 | 4KiB | I/O | read | 20259.77 | 0.00 | 0.00 | 79.14 | 0.00 | 10.0001s | 0.07 | 0.10 | 2.50 | 0.11 |
    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,2,4KiB,I/O,read,20259.77,0.00,0.00,79.14,0.00,10.0001s,0.07,0.10,2.50,0.11
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    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: 6058.12
    fsyncs/s: 7778.95
    read-MiB/s: 0.00
    written-MiB/s: 23.66
    time: 10.0036s
    min: 0.01
    avg: 0.14
    max: 2917.42
    95th: 0.20
    | 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 | 2 | 4KiB | I/O | write | 0.00 | 6058.12 | 7778.95 | 0.00 | 23.66 | 10.0036s | 0.01 | 0.14 | 2917.42 | 0.20 |
    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,2,4KiB,I/O,write,0.00,6058.12,7778.95,0.00,23.66,10.0036s,0.01,0.14,2917.42,0.20
    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 | 10702.94 | 0.00 | 0.00 | 41.81 | 0.00 | 10.0000s | 0.07 | 0.09 | 1.31 | 0.10 |
    |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 5147.36 | 6590.03 | 0.00 | 20.11 | 10.0022s | 0.01 | 0.09 | 1.19 | 0.20 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | read | 19803.25 | 0.00 | 0.00 | 77.36 | 0.00 | 10.0001s | 0.07 | 0.10 | 1.48 | 0.12 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | write | 0.00 | 4720.22 | 6063.50 | 0.00 | 18.44 | 10.0053s | 0.01 | 0.19 | 5.61 | 0.42 |
    | 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 | 10511.22 | 0.00 | 0.00 | 41.06 | 0.00 | 10.0001s | 0.07 | 0.09 | 4.85 | 0.11 |
    |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 4757.39 | 6090.36 | 0.00 | 18.58 | 10.0033s | 0.02 | 0.09 | 46.25 | 0.21 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | read | 20259.77 | 0.00 | 0.00 | 79.14 | 0.00 | 10.0001s | 0.07 | 0.10 | 2.50 | 0.11 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | write | 0.00 | 6058.12 | 7778.95 | 0.00 | 23.66 | 10.0036s | 0.01 | 0.14 | 2917.42 | 0.20 |

    Intel Xeon Gold 6136 sysbench file
    Code (Text):
    ./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: 9069.32
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 35.43
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.07
    avg: 0.11
    max: 12.96
    95th: 0.16
    | 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 | 9069.32 | 0.00 | 0.00 | 35.43 | 0.00 | 10.0001s | 0.07 | 0.11 | 12.96 | 0.16 |
    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,9069.32,0.00,0.00,35.43,0.00,10.0001s,0.07,0.11,12.96,0.16
    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: 4147.91
    fsyncs/s: 5309.32
    read-MiB/s: 0.00
    written-MiB/s: 16.20
    time: 10.0038s
    min: 0.01
    avg: 0.11
    max: 9.87
    95th: 0.28
    | 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 | 4147.91 | 5309.32 | 0.00 | 16.20 | 10.0038s | 0.01 | 0.11 | 9.87 | 0.28 |
    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,4147.91,5309.32,0.00,16.20,10.0038s,0.01,0.11,9.87,0.28
    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: 8012.55
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 31.30
    written-MiB/s: 0.00
    time: 10.0002s
    min: 0.07
    avg: 0.12
    max: 8.10
    95th: 0.19
    | 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 | 8012.55 | 0.00 | 0.00 | 31.30 | 0.00 | 10.0002s | 0.07 | 0.12 | 8.10 | 0.19 |
    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,8012.55,0.00,0.00,31.30,0.00,10.0002s,0.07,0.12,8.10,0.19
    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: 4018.85
    fsyncs/s: 5155.64
    read-MiB/s: 0.00
    written-MiB/s: 15.70
    time: 10.0040s
    min: 0.02
    avg: 0.11
    max: 36.73
    95th: 0.25
    | 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 | 4018.85 | 5155.64 | 0.00 | 15.70 | 10.0040s | 0.02 | 0.11 | 36.73 | 0.25 |
    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,4018.85,5155.64,0.00,15.70,10.0040s,0.02,0.11,36.73,0.25
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 18270.78
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 71.37
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.07
    avg: 0.11
    max: 9.73
    95th: 0.14
    | 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 | 2 | 4KiB | I/O | read | 18270.78 | 0.00 | 0.00 | 71.37 | 0.00 | 10.0001s | 0.07 | 0.11 | 9.73 | 0.14 |
    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,2,4KiB,I/O,read,18270.78,0.00,0.00,71.37,0.00,10.0001s,0.07,0.11,9.73,0.14
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential write (creation) test
    reads/s: 0.00
    writes/s: 4412.89
    fsyncs/s: 5666.79
    read-MiB/s: 0.00
    written-MiB/s: 17.24
    time: 10.0051s
    min: 0.02
    avg: 0.20
    max: 12.79
    95th: 0.47
    | 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 | 2 | 4KiB | I/O | write | 0.00 | 4412.89 | 5666.79 | 0.00 | 17.24 | 10.0051s | 0.02 | 0.20 | 12.79 | 0.47 |
    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,2,4KiB,I/O,write,0.00,4412.89,5666.79,0.00,17.24,10.0051s,0.02,0.20,12.79,0.47
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    Block-size 4KiB
    Read/Write ratio for combined random IO test: 1.50
    Using synchronous I/O mode
    Doing random read test
    reads/s: 19100.73
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 74.61
    written-MiB/s: 0.00
    time: 10.0002s
    min: 0.07
    avg: 0.10
    max: 10.47
    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 | 2 | 4KiB | I/O | read | 19100.73 | 0.00 | 0.00 | 74.61 | 0.00 | 10.0002s | 0.07 | 0.10 | 10.47 | 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,2,4KiB,I/O,read,19100.73,0.00,0.00,74.61,0.00,10.0002s,0.07,0.10,10.47,0.13
    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=2 --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-2-raw.log
    sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
    threads: 2
    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: 7678.46
    fsyncs/s: 9849.28
    read-MiB/s: 0.00
    written-MiB/s: 29.99
    time: 10.0055s
    min: 0.02
    avg: 0.11
    max: 10.08
    95th: 0.26
    | 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 | 2 | 4KiB | I/O | write | 0.00 | 7678.46 | 9849.28 | 0.00 | 29.99 | 10.0055s | 0.02 | 0.11 | 10.08 | 0.26 |
    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,2,4KiB,I/O,write,0.00,7678.46,9849.28,0.00,29.99,10.0055s,0.02,0.11,10.08,0.26
    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 | 9069.32 | 0.00 | 0.00 | 35.43 | 0.00 | 10.0001s | 0.07 | 0.11 | 12.96 | 0.16 |
    |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 4147.91 | 5309.32 | 0.00 | 16.20 | 10.0038s | 0.01 | 0.11 | 9.87 | 0.28 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | read | 18270.78 | 0.00 | 0.00 | 71.37 | 0.00 | 10.0001s | 0.07 | 0.11 | 9.73 | 0.14 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | write | 0.00 | 4412.89 | 5666.79 | 0.00 | 17.24 | 10.0051s | 0.02 | 0.20 | 12.79 | 0.47 |
    | 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 | 8012.55 | 0.00 | 0.00 | 31.30 | 0.00 | 10.0002s | 0.07 | 0.12 | 8.10 | 0.19 |
    |fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 4018.85 | 5155.64 | 0.00 | 15.70 | 10.0040s | 0.02 | 0.11 | 36.73 | 0.25 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | read | 19100.73 | 0.00 | 0.00 | 74.61 | 0.00 | 10.0002s | 0.07 | 0.10 | 10.47 | 0.13 |
    |fileio | 1.0.20 | 2 | 4KiB | I/O | write | 0.00 | 7678.46 | 9849.28 | 0.00 | 29.99 | 10.0055s | 0.02 | 0.11 | 10.08 | 0.26 |

    AMD EPYC 7542 VPS sysbench file-fsync
    Code (Text):
    ./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: 2636.40
    fsyncs/s: 2636.40
    read-MiB/s: 0.00
    written-MiB/s: 10.30
    time: 30.0003s
    min: 0.21
    avg: 0.38
    max: 4.52
    99th: 0.73
    | 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 | 2636.40 | 2636.40 | 0.00 | 10.30 | 30.0003s | 0.21 | 0.38 | 4.52 | 0.73 |
    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,2636.40,2636.40,0.00,10.30,30.0003s,0.21,0.38,4.52,0.73
    sysbench fileio cleanup
    sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup

    Intel Xeon Gold 6136 file-fsync
    Code (Text):
    ./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: 2202.17
    fsyncs/s: 2202.17
    read-MiB/s: 0.00
    written-MiB/s: 8.60
    time: 30.0006s
    min: 0.20
    avg: 0.45
    max: 13.69
    99th: 1.14
    | 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 | 2202.17 | 2202.17 | 0.00 | 8.60 | 30.0006s | 0.20 | 0.45 | 13.69 | 1.14 |
    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,2202.17,2202.17,0.00,8.60,30.0006s,0.20,0.45,13.69,1.14
    sysbench fileio cleanup
    sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup


    sysbench-mysqloltp-01.png

    AMD EPYC 7542 VPS sysbench mysql oltp
    Code (Text):
    ./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           402653184
    aria_sort_buffer_size                100663296
    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              268435456
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     131072
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              67108864
    net_buffer_length                    8192
    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                     131072
    read_rnd_buffer_size                 262144
    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                      65769
    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            1666
    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                50331648
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   200
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               134217728
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                50331648
    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   8
    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                     1
    innodb_read_io_threads                   2
    innodb_thread_concurrency                8
    innodb_thread_sleep_delay                5000
    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                        128
    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                         2
    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                      268435456
    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                           1000
    innodb_io_capacity_max                       1666
    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                         134217728
    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                         1
    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                    8
    innodb_thread_sleep_delay                    5000
    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=2 --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 'sbtest1'...
    Inserting 150000 records into 'sbtest2'
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating a secondary index on 'sbtest3'...
    Creating a secondary index on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating a secondary index on 'sbtest5'...
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest7'...
    Creating a secondary index on 'sbtest8'...
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest2 | 150000 Rows    | InnoDB         | 0.08MB    | 2.52MB     | 2.59MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest3 | 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.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest6 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 2.52MB     | 2.53MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest8 | 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=2 --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: 2
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    Initializing worker threads...
    Threads started!
    [ 1s ] thds: 2 tps: 580.49 qps: 11639.85 (r/w/o: 8151.89/2324.97/1162.99) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 2 tps: 626.90 qps: 12515.10 (r/w/o: 8757.67/2504.62/1252.81) lat (ms,95%): 4.33 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 2 tps: 630.12 qps: 12620.38 (r/w/o: 8838.67/2520.48/1261.24) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 2 tps: 620.89 qps: 12409.70 (r/w/o: 8683.39/2485.54/1240.77) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 2 tps: 660.10 qps: 13202.92 (r/w/o: 9243.34/2638.38/1321.19) lat (ms,95%): 3.68 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 2 tps: 644.03 qps: 12879.61 (r/w/o: 9015.43/2576.12/1288.06) lat (ms,95%): 4.18 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 2 tps: 628.82 qps: 12585.34 (r/w/o: 8812.44/2515.27/1257.63) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 2 tps: 633.14 qps: 12664.81 (r/w/o: 8863.97/2534.56/1266.28) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 2 tps: 622.02 qps: 12422.34 (r/w/o: 8692.24/2486.07/1244.03) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 2 tps: 619.02 qps: 12394.44 (r/w/o: 8680.31/2476.09/1238.04) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 2 tps: 632.94 qps: 12654.84 (r/w/o: 8857.19/2531.77/1265.88) lat (ms,95%): 4.41 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 2 tps: 625.05 qps: 12488.01 (r/w/o: 8737.71/2500.20/1250.10) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 2 tps: 629.76 qps: 12596.22 (r/w/o: 8817.65/2519.04/1259.52) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 2 tps: 615.22 qps: 12310.46 (r/w/o: 8619.12/2460.89/1230.45) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 2 tps: 621.02 qps: 12441.34 (r/w/o: 8710.24/2489.07/1242.03) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 2 tps: 638.00 qps: 12756.02 (r/w/o: 8931.01/2549.00/1276.00) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 2 tps: 616.00 qps: 12313.90 (r/w/o: 8619.93/2461.98/1231.99) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 2 tps: 635.01 qps: 12700.15 (r/w/o: 8890.10/2540.03/1270.01) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 2 tps: 607.99 qps: 12144.78 (r/w/o: 8496.84/2431.96/1215.98) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 2 tps: 620.01 qps: 12402.11 (r/w/o: 8682.07/2480.02/1240.01) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 2 tps: 629.96 qps: 12620.16 (r/w/o: 8837.41/2522.83/1259.92) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 2 tps: 636.05 qps: 12713.04 (r/w/o: 8899.73/2541.21/1272.10) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 2 tps: 639.82 qps: 12800.45 (r/w/o: 8961.51/2559.29/1279.64) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 2 tps: 624.12 qps: 12482.48 (r/w/o: 8737.73/2496.50/1248.25) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 2 tps: 617.03 qps: 12347.55 (r/w/o: 8639.39/2474.11/1234.06) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 2 tps: 632.02 qps: 12610.41 (r/w/o: 8824.29/2522.08/1264.04) lat (ms,95%): 4.74 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 2 tps: 620.97 qps: 12433.30 (r/w/o: 8707.51/2483.86/1241.93) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 2 tps: 636.93 qps: 12737.53 (r/w/o: 8915.97/2547.71/1273.85) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 2 tps: 640.07 qps: 12796.35 (r/w/o: 8955.95/2560.27/1280.14) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 2 tps: 643.02 qps: 12870.44 (r/w/o: 9009.31/2575.09/1286.04) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            263606
            write:                           75316
            other:                           37658
            total:                           376580
        transactions:                        18829  (627.55 per sec.)
        queries:                             376580 (12550.97 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    General statistics:
        total time:                          30.0033s
        total number of events:              18829
    Latency (ms):
             min:                                    1.99
             avg:                                    3.19
             max:                                   23.23
             95th percentile:                        4.65
             sum:                                59976.59
    Threads fairness:
        events (avg/stddev):           9414.5000/38.50
        execution time (avg/stddev):   29.9883/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=2 --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: 2
    read: 263606
    write: 75316
    other: 37658
    total: 376580
    transactions/s: 627.55
    queries/s: 12550.97
    time: 30.0033s
    min: 1.99
    avg: 3.19
    max: 23.23
    95th: 4.65
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_write.lua | 1.0.20 | 2 | 263606 | 75316 | 37658 | 376580 | 627.55 | 12550.97 | 30.0033s | 1.99 | 3.19 | 23.23 | 4.65 |
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_write.lua,1.0.20,2,263606,75316,37658,376580,627.55,12550.97,30.0033s,1.99,3.19,23.23,4.65
    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=2 --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'...

    Intel Xeon Gold 6136 sysbench mysql oltp
    Code (Text):
    ./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           402653184
    aria_sort_buffer_size                100663296
    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              268435456
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     131072
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              67108864
    net_buffer_length                    8192
    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                     131072
    read_rnd_buffer_size                 262144
    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                      65769
    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            2333
    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                50331648
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   200
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               134217728
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                50331648
    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   8
    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                     1
    innodb_read_io_threads                   2
    innodb_thread_concurrency                8
    innodb_thread_sleep_delay                5000
    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                        128
    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                         2
    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                      268435456
    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                           1400
    innodb_io_capacity_max                       2333
    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                         134217728
    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                         1
    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                    8
    innodb_thread_sleep_delay                    5000
    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=2 --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 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest2'...
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating a secondary index on 'sbtest4'...
    Creating a secondary index on 'sbtest3'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest5'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest8'...
    Creating a secondary index on 'sbtest7'...
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest2 | 150000 Rows    | InnoDB         | 0.09MB    | 2.52MB     | 2.61MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest1 | 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.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest6 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8_general_ci |
    | sbt.sbtest5 | 150000 Rows    | InnoDB         | 0.02MB    | 2.52MB     | 2.53MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 2.52MB     | 2.53MB  | Dynamic    | utf8_general_ci |
    | sbt.sbtest7 | 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=2 --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: 2
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    Initializing worker threads...
    Threads started!
    [ 1s ] thds: 2 tps: 544.24 qps: 10890.87 (r/w/o: 7623.41/2176.97/1090.48) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 2 tps: 548.88 qps: 10985.51 (r/w/o: 7693.26/2195.50/1096.75) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 2 tps: 507.13 qps: 10152.63 (r/w/o: 7106.84/2030.53/1015.26) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 2 tps: 546.89 qps: 10939.76 (r/w/o: 7660.43/2185.55/1093.78) lat (ms,95%): 5.88 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 2 tps: 572.14 qps: 11431.77 (r/w/o: 7998.94/2288.55/1144.28) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 2 tps: 555.79 qps: 11126.85 (r/w/o: 7792.09/2223.17/1111.59) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 2 tps: 564.20 qps: 11277.93 (r/w/o: 7892.75/2256.79/1128.39) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 2 tps: 578.96 qps: 11584.24 (r/w/o: 8110.47/2315.85/1157.92) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 2 tps: 565.04 qps: 11298.81 (r/w/o: 7908.57/2260.16/1130.08) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 2 tps: 555.91 qps: 11110.17 (r/w/o: 7774.72/2223.63/1111.82) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 2 tps: 553.09 qps: 11060.70 (r/w/o: 7742.19/2212.34/1106.17) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 2 tps: 538.94 qps: 10784.84 (r/w/o: 7548.19/2158.77/1077.88) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 2 tps: 535.05 qps: 10701.92 (r/w/o: 7494.65/2137.18/1070.09) lat (ms,95%): 5.88 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 2 tps: 509.73 qps: 10197.52 (r/w/o: 7139.16/2038.90/1019.45) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 2 tps: 491.87 qps: 9842.43 (r/w/o: 6891.20/1967.49/983.74) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 2 tps: 471.34 qps: 9423.76 (r/w/o: 6595.73/1885.35/942.68) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 2 tps: 497.88 qps: 9947.70 (r/w/o: 6960.39/1992.54/994.77) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 2 tps: 541.10 qps: 10828.10 (r/w/o: 7581.47/2163.42/1083.21) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 2 tps: 520.04 qps: 10395.84 (r/w/o: 7274.59/2082.17/1039.08) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 2 tps: 531.89 qps: 10642.77 (r/w/o: 7452.44/2125.55/1064.78) lat (ms,95%): 5.67 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 2 tps: 515.72 qps: 10305.47 (r/w/o: 7211.13/2062.89/1031.45) lat (ms,95%): 5.77 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 2 tps: 541.39 qps: 10844.75 (r/w/o: 7595.43/2166.55/1082.77) lat (ms,95%): 5.77 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 2 tps: 548.97 qps: 10968.44 (r/w/o: 7675.61/2194.89/1097.94) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 2 tps: 528.06 qps: 10557.25 (r/w/o: 7388.87/2112.25/1056.12) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 2 tps: 570.95 qps: 11419.09 (r/w/o: 7993.36/2283.82/1141.91) lat (ms,95%): 5.09 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 2 tps: 557.02 qps: 11145.49 (r/w/o: 7803.34/2228.10/1114.05) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 2 tps: 540.01 qps: 10786.11 (r/w/o: 7546.07/2160.02/1080.01) lat (ms,95%): 6.43 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 2 tps: 564.00 qps: 11285.97 (r/w/o: 7901.98/2255.99/1128.00) lat (ms,95%): 5.28 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 2 tps: 539.98 qps: 10817.50 (r/w/o: 7576.65/2160.90/1079.95) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 2 tps: 562.94 qps: 11251.83 (r/w/o: 7875.18/2250.77/1125.88) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            226828
            write:                           64808
            other:                           32404
            total:                           324040
        transactions:                        16202  (539.74 per sec.)
        queries:                             324040 (10794.86 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    General statistics:
        total time:                          30.0166s
        total number of events:              16202
    Latency (ms):
             min:                                    2.00
             avg:                                    3.70
             max:                                   29.66
             95th percentile:                        5.67
             sum:                                59976.13
    Threads fairness:
        events (avg/stddev):           8101.0000/72.00
        execution time (avg/stddev):   29.9881/0.01
    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=2 --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: 2
    read: 226828
    write: 64808
    other: 32404
    total: 324040
    transactions/s: 539.74
    queries/s: 10794.86
    time: 30.0166s
    min: 2.00
    avg: 3.70
    max: 29.66
    95th: 5.67
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_write.lua | 1.0.20 | 2 | 226828 | 64808 | 32404 | 324040 | 539.74 | 10794.86 | 30.0166s | 2.00 | 3.70 | 29.66 | 5.67 |
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_write.lua,1.0.20,2,226828,64808,32404,324040,539.74,10794.86,30.0166s,2.00,3.70,29.66,5.67
    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=2 --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'...
     
    Last edited: Oct 21, 2020
  4. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+

    Nginx HTTP/2 HTTPS Benchmarks



    Ran some Nginx HTTP/2 HTTPS benchmarks to compare 2 cpu VPS with AMD EPYC Rome 7542 vs Intel Xeon Gold 6136 Skylake and wow AMD EPYC 7542 is a beast :D

    Chart is only comparing h2load HTTP/2 HTTPS 300 concurrent user + 6000 request tests for easier comparison and raw numbers below show the rest.

    h2load-https-nginx-amd-epyc7532-vs-intel-xeon-gold-6136-01.png

    raw h2load HTTP/2 HTTPS results
    Code (Text):
    -------------------------------------------------------------------------------------------
    System Information
    -------------------------------------------------------------------------------------------
    
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             AuthenticAMD
    CPU family:            23
    Model:                 49
    Model name:            AMD EPYC 7542 32-Core Processor
    Stepping:              0
    CPU MHz:               2894.560
    BogoMIPS:              5789.12
    Hypervisor vendor:     KVM
    Virtualization type:   full
    NUMA node0 CPU(s):     0,1
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    
    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 topoext perfctr_core retpoline_amd ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip spec_ctrl
    
    -------------------------------------------------------------------------------------------
    CPU NODE SOCKET CORE ONLINE
    0   0    0      0    yes
    1   0    1      1    yes
    
    -------------------------------------------------------------------------------------------
                  total        used        free      shared  buff/cache   available
    Mem:           3789         735        2708          18         346        2821
    Low:           3789        1081        2708
    High:             0           0           0
    Swap:          1023           1        1022
    
    -------------------------------------------------------------------------------------------
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  6.4G   74G   8% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    
    -------------------------------------------------------------------------------------------
    nginx version: nginx/1.19.1 (240720-041459-centos7-kvm-c417d09)
    built by gcc 9.3.1 20200408 (Red Hat 9.3.1-2) (GCC)
    built with OpenSSL 1.1.1g  21 Apr 2020
    TLS SNI support enabled
    configure arguments: --with-ld-opt='-Wl,-E -L/usr/local/zlib-cf/lib -L/usr/local/lib -ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/zlib-cf/lib:/usr/local/lib -flto=2 -fuse-ld=gold' --with-cc-opt='-I/usr/local/zlib-cf/include -I/usr/local/include -m64 -march=native -DTCP_FASTOPEN=23 -g -O3 -fstack-protector-strong -flto=2 -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wno-error=pointer-sign -Wimplicit-fallthrough=0 -fcode-hoisting -Wp,-D_FORTIFY_SOURCE=2' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --build=240720-041459-centos7-kvm-c417d09 --with-compat --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.5 --add-dynamic-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.32 --add-dynamic-module=../echo-nginx-module-0.61 --add-module=../redis2-nginx-module-0.15 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.18 --add-module=../srcache-nginx-module-0.32rc1 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre-jit --with-zlib=../zlib-cloudflare-1.3.0 --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.1g --with-openssl-opt='enable-ec_nistp_64_gcc_128 enable-tls1_3 -fuse-ld=gold'
    
    
    -------------------------------------------------------------------------------------------
    h2load --version
    h2load nghttp2/1.33.0
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 222.10ms, 4502.58 req/s, 10.01MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:     1.74ms     48.00ms     12.35ms      7.17ms    87.30%
    time for connect:     4.01ms    123.59ms     74.42ms     35.09ms    63.00%
    time to 1st byte:    92.51ms    133.91ms    113.95ms     12.55ms    58.00%
    req/s           :      46.12       50.66       47.68        1.08    65.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 214.89ms, 4653.46 req/s, 10.35MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:      445us     43.72ms     11.81ms      6.33ms    83.30%
    time for connect:     3.84ms    122.88ms     74.26ms     35.37ms    68.00%
    time to 1st byte:    91.63ms    133.56ms    113.15ms     12.69ms    62.00%
    req/s           :      47.38       50.79       48.51        0.84    69.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 195.32ms, 5119.75 req/s, 11.39MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:      719us     40.51ms     11.33ms      4.82ms    85.00%
    time for connect:     9.35ms     97.57ms     59.88ms     27.16ms    60.00%
    time to 1st byte:    68.22ms    107.13ms     91.59ms      9.94ms    55.00%
    req/s           :      52.32       58.81       54.36        1.24    65.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 192.34ms, 5199.15 req/s, 11.56MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:      926us     42.50ms     11.43ms      5.36ms    88.40%
    time for connect:     2.95ms     99.79ms     56.54ms     27.03ms    63.00%
    time to 1st byte:    67.27ms    108.68ms     90.23ms     11.22ms    72.00%
    req/s           :      53.29       59.40       55.10        1.52    75.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 937.79ms, 6397.99 req/s, 14.21MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:    17.27ms    167.17ms     31.89ms     11.39ms    97.12%
    time for connect:    78.59ms    335.47ms    253.32ms     75.78ms    79.67%
    time to 1st byte:   257.10ms    365.16ms    330.93ms     22.83ms    54.67%
    req/s           :      21.47       23.00       22.11        0.39    57.67%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 948.29ms, 6327.16 req/s, 14.06MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     2.72ms    123.03ms     32.49ms     12.36ms    91.47%
    time for connect:    20.48ms    370.49ms    226.28ms    105.32ms    58.67%
    time to 1st byte:   264.59ms    401.99ms    339.52ms     41.29ms    58.33%
    req/s           :      21.29       22.55       21.75        0.32    68.67%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 844.21ms, 7107.28 req/s, 15.79MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     2.52ms     91.11ms     29.82ms     12.17ms    82.77%
    time for connect:    21.31ms    299.43ms    165.31ms     83.96ms    58.67%
    time to 1st byte:   195.73ms    328.64ms    268.63ms     40.40ms    53.67%
    req/s           :      24.15       26.79       24.84        0.60    77.67%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 863.77ms, 6946.29 req/s, 15.43MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     7.80ms    112.08ms     31.13ms     11.45ms    90.45%
    time for connect:    21.74ms    302.52ms    165.84ms     86.03ms    58.00%
    time to 1st byte:   198.41ms    332.85ms    265.48ms     44.57ms    56.67%
    req/s           :      23.59       25.18       24.24        0.44    62.33%
    -------------------------------------------------------------------------------------------
    
    h2load tests completed using temp /etc/hosts entry:
    server-ip-mask http2.domain.com #h2load
    
    centmin mod local code last commit:
    
    c417d09 George Liu Sun, 19 Jul 2020 07:28:43 +1000
    libwebp/libwebp7 fix on yum re-check routine in 123.09beta01
    
    users requests req/s encoding cipher protocol started succeeded
    100 1000 4502.58 gzip ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 1000 1000
    100 1000 4653.46 gzip ECDHE-RSA-AES256-GCM-SHA384 TLSv1.2 1000 1000
    100 1000 5119.75 gzip ECDHE-ECDSA-AES128-GCM-SHA256 TLSv1.2 1000 1000
    100 1000 5199.15 gzip ECDHE-ECDSA-AES256-GCM-SHA384 TLSv1.2 1000 1000
    300 6000 6397.99 gzip ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 6000 6000
    300 6000 6327.16 gzip ECDHE-RSA-AES256-GCM-SHA384 TLSv1.2 6000 6000
    300 6000 7107.28 gzip ECDHE-ECDSA-AES128-GCM-SHA256 TLSv1.2 6000 6000
    300 6000 6946.29 gzip ECDHE-ECDSA-AES256-GCM-SHA384 TLSv1.2 6000 6000
    -------------------------------------------------------------------------------------------
    h2load result summary
    min:      avg:      max:      stddev:   requests-succeeded:
    4502.580  5781.708  7107.280  1033.537  100.00
    -------------------------------------------------------------------------------------------

    Code (Text):
    -------------------------------------------------------------------------------------------
    System Information
    -------------------------------------------------------------------------------------------
    
    3.10.0-1127.8.2.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):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             2
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 85
    Model name:            Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz
    Stepping:              4
    CPU MHz:               2992.968
    BogoMIPS:              5985.93
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0,1
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm mpx avx512f avx512dq rdseed adx smap clflushopt clwb avx512cd avx512bw avx512vl xsaveopt xsavec xgetbv1 arat umip pku ospke spec_ctrl
    
    -------------------------------------------------------------------------------------------
    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
    
    -------------------------------------------------------------------------------------------
                  total        used        free      shared  buff/cache   available
    Mem:           3789         733        2709          19         345        2822
    Low:           3789        1079        2709
    High:             0           0           0
    Swap:          1023           0        1023
    
    -------------------------------------------------------------------------------------------
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        1.9G     0  1.9G   0% /dev
    tmpfs           1.9G     0  1.9G   0% /dev/shm
    tmpfs           1.9G   17M  1.9G   1% /run
    tmpfs           1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/vda1        80G  6.1G   74G   8% /
    tmpfs           379M     0  379M   0% /run/user/0
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    
    -------------------------------------------------------------------------------------------
    nginx version: nginx/1.19.1 (240720-041549-centos7-kvm-c417d09)
    built by gcc 9.3.1 20200408 (Red Hat 9.3.1-2) (GCC)
    built with OpenSSL 1.1.1g  21 Apr 2020
    TLS SNI support enabled
    configure arguments: --with-ld-opt='-Wl,-E -L/usr/local/zlib-cf/lib -L/usr/local/lib -ljemalloc -Wl,-z,relro -Wl,-rpath,/usr/local/zlib-cf/lib:/usr/local/lib -flto=2 -fuse-ld=gold' --with-cc-opt='-I/usr/local/zlib-cf/include -I/usr/local/include -m64 -march=native -DTCP_FASTOPEN=23 -g -O3 -fstack-protector-strong -flto=2 -fuse-ld=gold --param=ssp-buffer-size=4 -Wformat -Werror=format-security -Wno-error=pointer-sign -Wimplicit-fallthrough=0 -fcode-hoisting -Wp,-D_FORTIFY_SOURCE=2' --sbin-path=/usr/local/sbin/nginx --conf-path=/usr/local/nginx/conf/nginx.conf --build=240720-041549-centos7-kvm-c417d09 --with-compat --with-http_stub_status_module --with-http_secure_link_module --with-libatomic --with-http_gzip_static_module --with-http_sub_module --with-http_addition_module --with-http_image_filter_module=dynamic --with-http_geoip_module --with-stream_geoip_module --with-stream_realip_module --with-stream_ssl_preread_module --with-threads --with-stream --with-stream_ssl_module --with-http_realip_module --add-dynamic-module=../ngx-fancyindex-0.4.2 --add-module=../ngx_cache_purge-2.5 --add-dynamic-module=../ngx_devel_kit-0.3.0 --add-dynamic-module=../set-misc-nginx-module-0.32 --add-dynamic-module=../echo-nginx-module-0.61 --add-module=../redis2-nginx-module-0.15 --add-module=../ngx_http_redis-0.3.7 --add-module=../memc-nginx-module-0.18 --add-module=../srcache-nginx-module-0.32rc1 --add-dynamic-module=../headers-more-nginx-module-0.33 --with-pcre-jit --with-zlib=../zlib-cloudflare-1.3.0 --with-http_ssl_module --with-http_v2_module --with-openssl=../openssl-1.1.1g --with-openssl-opt='enable-ec_nistp_64_gcc_128 enable-tls1_3 -fuse-ld=gold'
    
    
    -------------------------------------------------------------------------------------------
    h2load --version
    h2load nghttp2/1.33.0
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 335.76ms, 2978.28 req/s, 6.62MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:     3.12ms     72.71ms     18.90ms      9.80ms    84.80%
    time for connect:     7.64ms    182.87ms    114.48ms     49.53ms    65.00%
    time to 1st byte:   137.98ms    198.24ms    172.58ms     17.15ms    63.00%
    req/s           :      29.87       32.73       31.07        0.55    68.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 309.28ms, 3233.33 req/s, 7.19MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:     3.32ms     65.32ms     15.74ms      8.85ms    87.50%
    time for connect:     7.37ms    184.34ms    115.64ms     51.03ms    64.00%
    time to 1st byte:   141.42ms    198.45ms    170.30ms     17.45ms    56.00%
    req/s           :      33.08       36.05       34.13        0.78    62.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 304.08ms, 3288.61 req/s, 7.31MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:     2.84ms     70.29ms     18.36ms      9.89ms    93.40%
    time for connect:     5.63ms    155.27ms     87.62ms     43.68ms    61.00%
    time to 1st byte:   113.93ms    172.60ms    140.83ms     16.70ms    72.00%
    req/s           :      33.15       37.19       35.04        0.94    66.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c100 -n1000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 283.26ms, 3530.39 req/s, 7.85MB/s
    requests: 1000 total, 1000 started, 1000 done, 1000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 1000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 2.22MB (2331900) total, 202.15KB (207000) headers (space savings 26.86%), 2.00MB (2102000) data
                         min         max         mean         sd        +/- sd
    time for request:     3.01ms     51.09ms     16.31ms      7.52ms    84.80%
    time for connect:     9.40ms    152.08ms     88.38ms     42.48ms    59.00%
    time to 1st byte:   107.02ms    167.10ms    136.27ms     19.25ms    54.00%
    req/s           :      36.27       38.90       37.40        0.74    64.00%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 1.35s, 4453.15 req/s, 9.89MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     4.22ms    153.20ms     47.76ms     18.01ms    86.52%
    time for connect:    31.79ms    488.03ms    281.13ms    132.08ms    61.67%
    time to 1st byte:   332.13ms    533.67ms    436.16ms     61.28ms    54.67%
    req/s           :      15.04       16.35       15.46        0.40    80.33%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-RSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-RSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 1.36s, 4414.08 req/s, 9.81MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     5.70ms    172.11ms     47.36ms     16.49ms    89.22%
    time for connect:    28.51ms    446.53ms    297.95ms    133.22ms    61.00%
    time to 1st byte:   362.76ms    512.74ms    440.84ms     45.45ms    53.33%
    req/s           :      14.84       16.23       15.33        0.40    79.33%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES128-GCM-SHA256 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES128-GCM-SHA256
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 1.23s, 4867.83 req/s, 10.81MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:     5.56ms    140.59ms     45.89ms     13.44ms    91.00%
    time for connect:    23.90ms    394.69ms    224.19ms    107.20ms    59.67%
    time to 1st byte:   249.09ms    432.68ms    354.32ms     51.23ms    64.67%
    req/s           :      16.47       17.53       16.85        0.25    71.67%
    -------------------------------------------------------------------------------------------
    
    h2load -t1 --ciphers=ECDHE-ECDSA-AES256-GCM-SHA384 -H 'Accept-Encoding: gzip' -c300 -n6000 https://http2.domain.com/
    TLS Protocol: TLSv1.2
    Cipher: ECDHE-ECDSA-AES256-GCM-SHA384
    Server Temp Key: ECDH P-256 256 bits
    Application protocol: h2
    
    finished in 1.34s, 4491.41 req/s, 9.98MB/s
    requests: 6000 total, 6000 started, 6000 done, 6000 succeeded, 0 failed, 0 errored, 0 timeout
    status codes: 6000 2xx, 0 3xx, 0 4xx, 0 5xx
    traffic: 13.33MB (13976700) total, 1.18MB (1242000) headers (space savings 26.86%), 12.03MB (12612000) data
                         min         max         mean         sd        +/- sd
    time for request:    18.91ms    135.00ms     48.90ms     11.00ms    89.80%
    time for connect:    33.39ms    393.91ms    248.85ms    119.69ms    49.33%
    time to 1st byte:   265.19ms    450.09ms    359.04ms     65.90ms    41.67%
    req/s           :      15.24       16.66       15.87        0.40    59.67%
    -------------------------------------------------------------------------------------------
    
    h2load tests completed using temp /etc/hosts entry:
    server-ip-mask http2.domain.com #h2load
    
    centmin mod local code last commit:
    
    c417d09 George Liu Sun, 19 Jul 2020 07:28:43 +1000
    libwebp/libwebp7 fix on yum re-check routine in 123.09beta01
    
    users requests req/s encoding cipher protocol started succeeded
    100 1000 2978.28 gzip ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 1000 1000
    100 1000 3233.33 gzip ECDHE-RSA-AES256-GCM-SHA384 TLSv1.2 1000 1000
    100 1000 3288.61 gzip ECDHE-ECDSA-AES128-GCM-SHA256 TLSv1.2 1000 1000
    100 1000 3530.39 gzip ECDHE-ECDSA-AES256-GCM-SHA384 TLSv1.2 1000 1000
    300 6000 4453.15 gzip ECDHE-RSA-AES128-GCM-SHA256 TLSv1.2 6000 6000
    300 6000 4414.08 gzip ECDHE-RSA-AES256-GCM-SHA384 TLSv1.2 6000 6000
    300 6000 4867.83 gzip ECDHE-ECDSA-AES128-GCM-SHA256 TLSv1.2 6000 6000
    300 6000 4491.41 gzip ECDHE-ECDSA-AES256-GCM-SHA384 TLSv1.2 6000 6000
    -------------------------------------------------------------------------------------------
    h2load result summary
    min:      avg:      max:      stddev:  requests-succeeded:
    2978.280  3907.135  4867.830  723.161  100.00
    -------------------------------------------------------------------------------------------
     
    Last edited: Oct 21, 2020
  5. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    AMD EPYC 7532 info AMD EPYC 7662 and EPYC 7532 Launched | ServeTheHome
     
  6. amit338

    amit338 New Member

    5
    2
    3
    Jun 9, 2020
    Ratings:
    +2
    Local Time:
    7:57 PM
    Inside [/CODEB] it shows model name: AMD EPYC 7542 32-Core Processor

    7532.jpg

    I am currently using Linode and really liked it specially resize feature easy vertical upgrade and all the configuration, IP, remains the same do we have the same functionality in Upcloud, OVH VPS? Now, do you recommend "Upcloud AMD EPYC 7532 over Linode AMD EPYC 7501" or one should go with new OVH VPS for per CPU core pricing?

    //patiently waiting for a new 13-way benchmark :)

     
  7. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    OVH VPS cpu is slower and older. Linode I discussed why I'd go with Linode even if cpu is slower/older depending on what you value - see below quote and hyperlink to thread

     
  8. tininho

    tininho Active Member

    182
    44
    28
    May 22, 2019
    eu
    Ratings:
    +135
    Local Time:
    4:27 PM
    Also available in Upcloud's Germany datacenter:

    Code:
    [14:46][root@centos-2cpu-4gb-de-fra1 ~]# lscpu
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                2
    On-line CPU(s) list:   0,1
    Thread(s) per core:    1
    Core(s) per socket:    2
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             AuthenticAMD
    CPU family:            23
    Model:                 49
    Model name:            AMD EPYC 7542 32-Core Processor
    Stepping:              0
    CPU MHz:               2894.562
    BogoMIPS:              5789.12
    Hypervisor vendor:     KVM
    Virtualization type:   full
    NUMA node0 CPU(s):     0,1
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm rep_good nopl cpuid extd_apicid tsc_known_freq 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 topoext perfctr_core ssbd ibrs ibpb vmmcall fsgsbase tsc_adjust bmi1 avx2 smep bmi2 rdseed adx smap clflushopt clwb sha_ni xsaveopt xsavec xgetbv1 arat umip
    
     
  9. eva2000

    eva2000 Administrator Staff Member

    54,548
    12,221
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,790
    Local Time:
    12:27 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Yeah they sprinkled these AMD EPYC into the mix for other datacenters though only Upcloud New York datacenter is 100% AMD EPYC based :)
     
  10. Colin

    Colin Premium Member Premium Member

    191
    59
    28
    Oct 7, 2015
    Sheffield UK
    Ratings:
    +153
    Local Time:
    2:27 PM
    1.19.#
    MariaDB 10.1.#
    Indeed, I just fired up a small batch in london and got Intel(R) Xeon(R) Gold 6136 CPU @ 3.00GHz each time. Still not to bad for test nodes, better maybe.
    My prod linode seems to be a AMD EPYC 7601