Learn about Centmin Mod LEMP Stack today
Register Now

Benchmarks Upcloud Upcloud Benchmark

Discussion in 'Virtual Private Server (VPS) hosting' started by JJC84, May 6, 2018.

Tags:
  1. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    Here is my latest benchmarks after making a few tweaks to the custom_config.inc and recompiling nginx and php from the $10 Upcloud server 1 cpu 2 gb ram:

    Code:
    -------------------------------------------
    centminmodbench.sh 0.9.6
    http://bench.centminmod.com
    written by: George Liu (eva2000)
    http://centminmod.com
    -------------------------------------------
    
    -------------------------------------------
    System Information
    -------------------------------------------
    
    4.16.0-1.el7.elrepo.x86_64
    
    CentOS Linux release 7.4.1708 (Core)
    
    Centmin Mod
    ----------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 79
    Model name:            Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
    Stepping:              1
    CPU MHz:               2999.996
    BogoMIPS:              5999.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0
    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 cpuid 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 pti fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology cpuid 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 pti fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    ----------------------------------------------
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE
    0   0    0      0    0:0:0:0       yes
    
    ----------------------------------------------
                  total        used        free      shared  buff/cache   available
    Mem:           1994         484         291          29        1217        1178
    Low:           1994        1702         291
    High:             0           0           0
    Swap:          2047           1        2046
    
    ----------------------------------------------
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        986M     0  986M   0% /dev
    tmpfs           998M     0  998M   0% /dev/shm
    tmpfs           998M  8.5M  989M   1% /run
    tmpfs           998M     0  998M   0% /sys/fs/cgroup
    /dev/vda1        50G   12G   39G  23% /
    /dev/loop0      5.8G   26M  5.5G   1% /tmp
    tmpfs           200M     0  200M   0% /run/user/0
    tmpfs           200M     0  200M   0% /run/user/1000
    
    
    Code:
    -------------------------------------------
    disk ioping tests
    -------------------------------------------
    
    
    Running IOPing I/O benchmark...
    
    IOPing I/O: ./ioping -c 10 .
    4.0 KiB from . (xfs /dev/vda1): request=1 time=100 us
    4.0 KiB from . (xfs /dev/vda1): request=2 time=199 us
    4.0 KiB from . (xfs /dev/vda1): request=3 time=179 us
    4.0 KiB from . (xfs /dev/vda1): request=4 time=216 us
    4.0 KiB from . (xfs /dev/vda1): request=5 time=215 us
    4.0 KiB from . (xfs /dev/vda1): request=6 time=223 us
    4.0 KiB from . (xfs /dev/vda1): request=7 time=241 us
    4.0 KiB from . (xfs /dev/vda1): request=8 time=188 us
    4.0 KiB from . (xfs /dev/vda1): request=9 time=204 us
    4.0 KiB from . (xfs /dev/vda1): request=10 time=195 us
    
    --- . (xfs /dev/vda1) ioping statistics ---
    10 requests completed in 9.0 s, 5.1 k iops, 19.9 MiB/s
    min/avg/max/mdev = 100 us / 196 us / 241 us / 36 us
    
    IOPing seek rate: ./ioping -RD .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    39.6 k requests completed in 3.0 s, 13.4 k iops, 52.3 MiB/s
    min/avg/max/mdev = 52 us / 74 us / 1.1 ms / 35 us
    
    IOPing sequential: ./ioping -RL .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    4.7 k requests completed in 3.0 s, 1.6 k iops, 408.0 MiB/s
    min/avg/max/mdev = 467 us / 612 us / 12.0 ms / 542 us
    
    IOPing cached: ./ioping -RC .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    2.6 M requests completed in 3.0 s, 939.8 k iops, 3.6 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 112 us / 0 us
    
    
    Code:
    -------------------------------------------
    disk DD tests
    -------------------------------------------
    
    dd if=/dev/zero of=sb-io-test bs=1M count=1k conv=fdatasync
    1024+0 records in
    1024+0 records out
    1073741824 bytes (1.1 GB) copied, 3.76613 s, 285 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=64k count=16k conv=fdatasync
    16384+0 records in
    16384+0 records out
    1073741824 bytes (1.1 GB) copied, 4.59288 s, 234 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=1M count=1k oflag=dsync
    1024+0 records in
    1024+0 records out
    1073741824 bytes (1.1 GB) copied, 8.09465 s, 133 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=64k count=16k oflag=dsync
    16384+0 records in
    16384+0 records out
    1073741824 bytes (1.1 GB) copied, 21.3386 s, 50.3 MB/s
    
    Code:
    -------------------------------------------
    disk FIO tests
    -------------------------------------------
    
    
    Running FIO benchmark...
    
    
    FIO random reads:
    randomreads: (g=0): rw=randread, bs=4K-4K/4K-4K, ioengine=libaio, iodepth=64
    fio-2.0.9
    Starting 1 process
    randomreads: Laying out IO file(s) (1 file(s) / 1024MB)
    
    randomreads: (groupid=0, jobs=1): err= 0: pid=22295: Sat May  5 16:57:48 2018
      read : io=1024.3MB, bw=396233KB/s, iops=99058 , runt=  2647msec
      cpu          : usr=11.11%, sys=43.08%, ctx=11550, majf=0, minf=69
      IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=0.1%, 16=0.1%, 32=0.1%, >=64=100.0%
         submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
         complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.1%, >=64=0.0%
         issued    : total=r=262207/w=0/d=0, short=r=0/w=0/d=0
    
    Run status group 0 (all jobs):
       READ: io=1024.3MB, aggrb=396232KB/s, minb=396232KB/s, maxb=396232KB/s, mint=2647msec, maxt=2647msec
    
    Disk stats (read/write):
      vda: ios=255380/4, merge=0/0, ticks=128212/3, in_queue=124050, util=94.19%
    
    FIO random writes:
    randomwrites: (g=0): rw=randwrite, bs=4K-4K/4K-4K, ioengine=libaio, iodepth=64
    fio-2.0.9
    Starting 1 process
    
    randomwrites: (groupid=0, jobs=1): err= 0: pid=22299: Sat May  5 16:57:52 2018
      write: io=1024.3MB, bw=269552KB/s, iops=67388 , runt=  3891msec
      cpu          : usr=7.94%, sys=26.89%, ctx=17181, majf=0, minf=6
      IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=0.1%, 16=0.1%, 32=0.1%, >=64=100.0%
         submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
         complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.1%, >=64=0.0%
         issued    : total=r=0/w=262207/d=0, short=r=0/w=0/d=0
    
    Run status group 0 (all jobs):
      WRITE: io=1024.3MB, aggrb=269552KB/s, minb=269552KB/s, maxb=269552KB/s, mint=3891msec, maxt=3891msec
    
    Disk stats (read/write):
      vda: ios=0/246650, merge=0/0, ticks=0/196749, in_queue=193883, util=97.07%
    
    
    Code:
    -------------------------------------------
    ramdisk DD tests - memory bandwidth
    -------------------------------------------
    
    dd if=/dev/zero of=sb-io-test bs=128k count=1k conv=fdatasync
    1024+0 records in
    1024+0 records out
    134217728 bytes (134 MB) copied, 0.0544023 s, 2.5 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=8k count=16k conv=fdatasync
    16384+0 records in
    16384+0 records out
    134217728 bytes (134 MB) copied, 0.0668163 s, 2.0 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=128k count=1k oflag=dsync
    1024+0 records in
    1024+0 records out
    134217728 bytes (134 MB) copied, 0.0542016 s, 2.5 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=8k count=16k oflag=dsync
    16384+0 records in
    16384+0 records out
    134217728 bytes (134 MB) copied, 0.0656932 s, 2.0 GB/s
    
    Code:
    -------------------------------------------
    ramdisk ioping tests - memory bandwidth
    -------------------------------------------
    
    2018-05-05 16:57:55 URL:https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/ioping/ioping-0.8.tar.gz [10590/10590] -> "ioping-0.8.tar.gz" [1]
    Download done.
    ioping-0.8.tar.gz valid file.
    
    Running IOPing I/O ramdisk benchmark...
    cc -std=gnu99 -g -Wall -Wextra -pedantic -DVERSION=\"0.8\" -c -o ioping.o ioping.c
    cc -o ioping ioping.o -std=gnu99 -g -Wall -Wextra -pedantic  -lm
    
    IOPing I/O: ./ioping -c 10 .
    4.0 KiB from . (tmpfs tmpfs): request=1 time=2 us
    4.0 KiB from . (tmpfs tmpfs): request=2 time=8 us
    4.0 KiB from . (tmpfs tmpfs): request=3 time=8 us
    4.0 KiB from . (tmpfs tmpfs): request=4 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=5 time=7 us
    4.0 KiB from . (tmpfs tmpfs): request=6 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=7 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=8 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=9 time=7 us
    4.0 KiB from . (tmpfs tmpfs): request=10 time=7 us
    
    --- . (tmpfs tmpfs) ioping statistics ---
    10 requests completed in 9.0 s, 158.7 k iops, 620.0 MiB/s
    min/avg/max/mdev = 2 us / 6 us / 8 us / 1 us
    
    IOPing seek rate: ./ioping -R .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    1.9 M requests completed in 3.0 s, 846.3 k iops, 3.2 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 1.0 ms / 3 us
    
    IOPing sequential: ./ioping -RL .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    52.5 k requests completed in 3.0 s, 17.7 k iops, 4.3 GiB/s
    min/avg/max/mdev = 43 us / 56 us / 1.1 ms / 24 us
    
    IOPing cached: ./ioping -RC .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    2.4 M requests completed in 3.0 s, 857.3 k iops, 3.3 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 993 us / 2 us
    
    
    Code:
    -------------------------------------------
    Running bandwidth benchmark...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Cachefly (http://cachefly.cachefly.net/100mb.test)
    Download Cachefly: 26.5MB/s
    
    -------------------------------------------
    USA bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Linode, Atlanta, GA, USA (http://speedtest.atlanta.linode.com/100MB-atlanta.bin)
    Download Linode, Atlanta, GA, USA: 52.9MB/s
    ----------------------------------------------
    Download from Linode, Dallas, TX, USA (http://speedtest.dallas.linode.com/100MB-dallas.bin)
    Download Linode, Dallas, TX, USA: 45.8MB/s
    ----------------------------------------------
    Download from Leaseweb, Manassas, VA, USA (http://mirror.us.leaseweb.net/speedtest/100mb.bin)
    Download Leaseweb, Manassas, VA, USA: 53.1MB/s
    ----------------------------------------------
    Download from Softlayer, Seattle, WA, USA (http://speedtest.sea01.softlayer.com/downloads/test100.zip)
    Download Softlayer, Seattle, WA, USA: 39.0MB/s
    ----------------------------------------------
    Download from Softlayer, San Jose, CA, USA (http://speedtest.sjc01.softlayer.com/downloads/test100.zip)
    Download Softlayer, San Jose, CA, USA: 37.7MB/s
    ----------------------------------------------
    Download from Softlayer, Washington, DC, USA (http://speedtest.wdc01.softlayer.com/downloads/test100.zip)
    Download Softlayer, Washington, DC, USA: 49.4MB/s
    ----------------------------------------------
    Download from VersaWeb, Las Vegas, Nevada (http://lg.las1.as53340.net/100MB.test)
    Download VersaWeb, Las Vegas, Nevada: 7.43MB/s
    ----------------------------------------------
    Download from OVH, BHS, Canada (http://bhs.proof.ovh.net/files/100Mio.dat)
    Download OVH, BHS, Canada: 38.1MB/s
    
    -------------------------------------------
    Europe bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Linode, London, UK (http://speedtest.london.linode.com/100MB-london.bin)
    Download Linode, London, UK: 23.1MB/s
    ----------------------------------------------
    Download from OVH, Paris, France (http://proof.ovh.net/files/100Mio.dat)
    Download OVH, Paris, France: 406KB/s
    ----------------------------------------------
    Download from SmartDC, Rotterdam, Netherlands (http://mirror.i3d.net/100mb.bin)
    Download SmartDC, Rotterdam, Netherlands: 18.4MB/s
    
    Code:
    -------------------------------------------
    Running Axel multi-threaded bandwidth benchmark...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Cachefly (http://cachefly.cachefly.net/100mb.test)
    Axel Download Cachefly: 44.42MB/s
    
    -------------------------------------------
    USA bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Linode, Atlanta, GA, USA (http://speedtest.atlanta.linode.com/100MB-atlanta.bin)
    Axel Download Linode, Atlanta, GA, USA: 44.16MB/s
    ----------------------------------------------
    Axel Download from Linode, Dallas, TX, USA (http://speedtest.dallas.linode.com/100MB-dallas.bin)
    Axel Download Linode, Dallas, TX, USA: 45.78MB/s
    ----------------------------------------------
    Axel Download from Leaseweb, Manassas, VA, USA (http://mirror.us.leaseweb.net/speedtest/100mb.bin)
    Axel Download Leaseweb, Manassas, VA, USA: 44.79MB/s
    ----------------------------------------------
    Axel Download from Softlayer, Seattle, WA, USA (http://speedtest.sea01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, Seattle, WA, USA: 30.26MB/s
    ----------------------------------------------
    Axel Download from Softlayer, San Jose, CA, USA (http://speedtest.sjc01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, San Jose, CA, USA: 27.66MB/s
    ----------------------------------------------
    Axel Download from Softlayer, Washington, DC, USA (http://speedtest.wdc01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, Washington, DC, USA: 17.63MB/s
    ----------------------------------------------
    Axel Download from VersaWeb, Las Vegas, Nevada (http://lg.las1.as53340.net/100MB.test)
    Axel Download VersaWeb, Las Vegas, Nevada: 19.27MB/s
    ----------------------------------------------
    Axel Download from OVH, BHS, Canada (http://bhs.proof.ovh.net/files/100Mio.dat)
    Axel Download OVH, BHS, Canada: 45.39MB/s
    
    -------------------------------------------
    Europe bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Linode, London, UK (http://speedtest.london.linode.com/100MB-london.bin)
    Axel Download Linode, London, UK: 24.65MB/s
    ----------------------------------------------
    Axel Download from OVH, Paris, France (http://proof.ovh.net/files/100Mio.dat)
    Axel Download OVH, Paris, France: 11.66MB/s
    ----------------------------------------------
    Axel Download from SmartDC, Rotterdam, Netherlands (http://mirror.i3d.net/100mb.bin)
    Axel Download SmartDC, Rotterdam, Netherlands: 17.16MB/s
    
    Code:
    -------------------------------------------
    Check system entropy pool availability
    -------------------------------------------
    
    entropy_avail: 4067
    entropy_avail: 4067
    entropy_avail: 4067
    entropy_avail: 4067
    
    Code:
    -------------------------------------------
    OpenSSL System Benchmark
    -------------------------------------------
    
    OpenSSL 1.0.2k-fips  26 Jan 2017
    -------------------------------------------
    openssl speed -multi 1 rsa4096 rsa2048 ecdsap256 sha256 sha1 md5 rc4 aes-256-cbc aes-128-cbc
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    md5              59156.08k   172351.36k   378180.10k   533522.77k   621931.18k
    sha1             68463.91k   201351.51k   445136.81k   725715.63k   851323.56k
    rc4             418487.94k   694631.89k   782047.32k   777197.23k   790601.73k
    aes-128 cbc     123973.24k   135510.27k   138391.89k   321765.38k   324657.15k
    aes-256 cbc      90830.18k    96817.24k    98222.68k   235658.24k   237289.47k
    sha256           72614.13k   160987.14k   294604.80k   371588.10k   401877.67k
                      sign    verify    sign/s verify/s
    rsa 2048 bits 0.000668s 0.000019s   1497.0  52631.6
    rsa 4096 bits 0.004639s 0.000067s    215.6  14925.4
                                  sign    verify    sign/s verify/s
     256 bit ecdsa (nistp256)   0.0000s   0.0001s  25641.0  11494.3
    -------------------------------------------
    openssl speed -evp aes256 -multi 1
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    evp             473481.78k   501276.97k   505601.71k   509446.14k   509460.48k
    -------------------------------------------
    openssl speed -evp aes128 -multi 1
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    evp             647081.75k   694251.31k   706232.66k   709641.90k   711704.58k
    
    Code:
    -------------------------------------------
    Running mysqlslap
    -------------------------------------------
    
    mysqlslap --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=5 --number-int-cols=5 --number-char-cols=5 --number-of-queries=25000 --auto-generate-sql-unique-query-number=40 --auto-generate-sql-unique-write-number=40 --auto-generate-sql-write-number=1000 --concurrency=64 --iterations=10 --engine=myisam
    Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 2.309 seconds
        Minimum number of seconds to run all queries: 2.229 seconds
        Maximum number of seconds to run all queries: 2.583 seconds
        Number of clients running queries: 64
        Average number of queries per client: 390
    
    Dropping the database is potentially a very bad thing to do.
    Any data stored in the database will be destroyed.
    
    Do you really want to drop the 'test' database [y/N] Database "test" dropped
    
    Code:
    -------------------------------------------
    System PHP Info
    -------------------------------------------
    
    CPU: 1 x Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
                  total        used        free      shared  buff/cache   available
    Mem:           1994         397         821          30         775        1316
    Low:           1994        1172         821
    High:             0           0           0
    Swap:          2047           1        2046
    ----------------------------------------------
    PHP 7.2.5 (cli) (built: May  5 2018 16:51:32) ( NTS )
    Copyright (c) 1997-2018 The PHP Group
    Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
        with Zend OPcache v7.2.5, Copyright (c) 1999-2018, by Zend Technologies
    ----------------------------------------------
    Configuration File (php.ini) Path: /usr/local/lib
    Loaded Configuration File:         /usr/local/lib/php.ini
    Scan for additional .ini files in: /etc/centminmod/php.d
    Additional .ini files parsed:      /etc/centminmod/php.d/a_customphp.ini,
    /etc/centminmod/php.d/curlcainfo.ini,
    /etc/centminmod/php.d/geoip.ini,
    /etc/centminmod/php.d/igbinary.ini,
    /etc/centminmod/php.d/imagick.ini,
    /etc/centminmod/php.d/mailparse.ini,
    /etc/centminmod/php.d/mcrypt.ini,
    /etc/centminmod/php.d/memcache.ini,
    /etc/centminmod/php.d/memcached.ini,
    /etc/centminmod/php.d/redis.ini,
    /etc/centminmod/php.d/zendopcache.ini
    
    ----------------------------------------------
    [PHP Modules]
    bcmath
    bz2
    calendar
    Core
    ctype
    curl
    date
    dom
    enchant
    exif
    filter
    ftp
    gd
    geoip
    gettext
    gmp
    hash
    iconv
    igbinary
    imagick
    imap
    intl
    json
    ldap
    libxml
    mailparse
    mbstring
    mcrypt
    memcache
    memcached
    mysqli
    mysqlnd
    openssl
    pcntl
    pcre
    PDO
    pdo_mysql
    pdo_sqlite
    Phar
    posix
    pspell
    readline
    redis
    Reflection
    session
    shmop
    SimpleXML
    snmp
    soap
    sockets
    SPL
    sqlite3
    standard
    sysvmsg
    sysvsem
    sysvshm
    tidy
    tokenizer
    xml
    xmlreader
    xmlrpc
    xmlwriter
    xsl
    Zend OPcache
    zip
    zlib
    
    [Zend Modules]
    Zend OPcache
    
    ----------------------------------------------
    -------------------------------------------
    Run PHP test Zend/bench.php
    -------------------------------------------
    
    simple             0.030
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.022
    mandel             0.101
    mandel2            0.105
    ackermann(7)       0.023
    ary(50000)         0.005
    ary2(50000)        0.004
    ary3(2000)         0.047
    fibo(30)           0.073
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.024
    matrix(20)         0.024
    nestedloop(12)     0.049
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.577
    real: 0.61s user: 0.59s sys: 0.01s cpu: 99% maxmem: 39212 KB cswaits: 8
    
    simple             0.028
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.024
    mandel             0.098
    mandel2            0.105
    ackermann(7)       0.022
    ary(50000)         0.005
    ary2(50000)        0.003
    ary3(2000)         0.047
    fibo(30)           0.071
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.023
    matrix(20)         0.024
    nestedloop(12)     0.050
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.571
    real: 0.61s user: 0.59s sys: 0.01s cpu: 99% maxmem: 39392 KB cswaits: 1
    
    simple             0.028
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.022
    mandel             0.096
    mandel2            0.103
    ackermann(7)       0.021
    ary(50000)         0.005
    ary2(50000)        0.004
    ary3(2000)         0.046
    fibo(30)           0.070
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.024
    matrix(20)         0.024
    nestedloop(12)     0.049
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.563
    real: 0.60s user: 0.58s sys: 0.01s cpu: 99% maxmem: 39276 KB cswaits: 1
    
    bench.php results from 3 runs
    0.577
    0.571
    0.563
    
    bench.php avg: 0.5703
    Avg: real: 0.61s user: 0.59s sys: 0.01s cpu: 99.00% maxmem: 39293.33KB cswaits: 3.33
    created results log at /home/phpbench_logs/bench_050518-165626.log
    server PHP info log at /home/phpbench_logs/bench_phpinfo_050518-165626.log
    
    -------------------------------------------
    Run PHP test Zend/micro_bench.php
    -------------------------------------------
    
    empty_loop         0.035
    func()             0.098    0.063
    undef_func()       0.101    0.066
    int_func()         0.072    0.036
    $x = self::$x      0.091    0.056
    self::$x = 0       0.108    0.073
    isset(self::$x)    0.093    0.058
    empty(self::$x)    0.093    0.058
    $x = Foo::$x       0.068    0.033
    Foo::$x = 0        0.063    0.028
    isset(Foo::$x)     0.071    0.035
    empty(Foo::$x)     0.076    0.041
    self::f()          0.122    0.087
    Foo::f()           0.099    0.064
    $x = $this->x      0.065    0.030
    $this->x = 0       0.051    0.016
    $this->x += 2      0.090    0.055
    ++$this->x         0.069    0.033
    --$this->x         0.063    0.028
    $this->x++         0.087    0.052
    $this->x--         0.080    0.044
    isset($this->x)    0.083    0.048
    empty($this->x)    0.091    0.055
    $this->f()         0.099    0.064
    $x = Foo::TEST     0.093    0.058
    new Foo()          0.209    0.174
    $x = TEST          0.064    0.029
    $x = $_GET         0.087    0.052
    $x = $GLOBALS['v'] 0.129    0.094
    $x = $hash['v']    0.094    0.059
    $x = $str[0]       0.081    0.046
    $x = $a ?: null    0.075    0.040
    $x = $f ?: tmp     0.075    0.040
    $x = $f ? $f : $a  0.064    0.029
    $x = $f ? $f : tmp 0.069    0.034
    ------------------------
    Total              3.007
    real: 3.04s user: 3.02s sys: 0.01s cpu: 99% maxmem: 33120 KB cswaits: 2
    
    empty_loop         0.034
    func()             0.096    0.062
    undef_func()       0.101    0.067
    int_func()         0.069    0.036
    $x = self::$x      0.087    0.053
    self::$x = 0       0.090    0.057
    isset(self::$x)    0.088    0.054
    empty(self::$x)    0.094    0.061
    $x = Foo::$x       0.069    0.035
    Foo::$x = 0        0.064    0.030
    isset(Foo::$x)     0.071    0.037
    empty(Foo::$x)     0.077    0.044
    self::f()          0.122    0.088
    Foo::f()           0.101    0.067
    $x = $this->x      0.065    0.031
    $this->x = 0       0.050    0.017
    $this->x += 2      0.090    0.056
    ++$this->x         0.069    0.035
    --$this->x         0.063    0.029
    $this->x++         0.087    0.054
    $this->x--         0.082    0.048
    isset($this->x)    0.084    0.050
    empty($this->x)    0.090    0.057
    $this->f()         0.099    0.065
    $x = Foo::TEST     0.093    0.059
    new Foo()          0.209    0.176
    $x = TEST          0.069    0.035
    $x = $_GET         0.087    0.053
    $x = $GLOBALS['v'] 0.129    0.096
    $x = $hash['v']    0.095    0.061
    $x = $str[0]       0.081    0.047
    $x = $a ?: null    0.076    0.042
    $x = $f ?: tmp     0.078    0.044
    $x = $f ? $f : $a  0.068    0.034
    $x = $f ? $f : tmp 0.070    0.036
    ------------------------
    Total              2.996
    real: 3.03s user: 3.00s sys: 0.01s cpu: 99% maxmem: 33172 KB cswaits: 1
    
    empty_loop         0.034
    func()             0.096    0.062
    undef_func()       0.102    0.068
    int_func()         0.070    0.036
    $x = self::$x      0.088    0.054
    self::$x = 0       0.091    0.057
    isset(self::$x)    0.087    0.053
    empty(self::$x)    0.093    0.059
    $x = Foo::$x       0.068    0.034
    Foo::$x = 0        0.064    0.030
    isset(Foo::$x)     0.070    0.035
    empty(Foo::$x)     0.076    0.042
    self::f()          0.122    0.088
    Foo::f()           0.105    0.071
    $x = $this->x      0.065    0.031
    $this->x = 0       0.050    0.016
    $this->x += 2      0.090    0.056
    ++$this->x         0.069    0.034
    --$this->x         0.064    0.030
    $this->x++         0.087    0.053
    $this->x--         0.080    0.046
    isset($this->x)    0.083    0.049
    empty($this->x)    0.090    0.056
    $this->f()         0.098    0.064
    $x = Foo::TEST     0.093    0.059
    new Foo()          0.209    0.175
    
    ▽
    Foo::$x = 0        0.066    0.028
    isset(Foo::$x)     0.073    0.036
    empty(Foo::$x)     0.081    0.044
    self::f()          0.129    0.091
    Foo::f()           0.109    0.071
    $x = $this->x      0.069    0.031
    $this->x = 0       0.053    0.015
    $this->x += 2      0.093    0.055
    ++$this->x         0.072    0.034
    --$this->x         0.067    0.030
    $this->x++         0.091    0.053
    $this->x--         0.084    0.046
    isset($this->x)    0.086    0.049
    empty($this->x)    0.095    0.058
    $this->f()         0.101    0.063
    $x = Foo::TEST     0.096    0.058
    new Foo()          0.233    0.195
    $x = TEST          0.070    0.032
    $x = $_GET         0.092    0.054
    $x = $GLOBALS['v'] 0.137    0.099
    $x = $hash['v']    0.100    0.062
    $x = $str[0]       0.089    0.051
    $x = $a ?: null    0.079    0.042
    $x = $f ?: tmp     0.080    0.042
    $x = $f ? $f : $a  0.066    0.028
    $x = $f ? $f : tmp 0.072    0.034
    ------------------------
    Total              3.146
    real: 3.18s user: 3.15s sys: 0.00s cpu: 99% maxmem: 33488 KB cswaits: 1
    
    micro_bench.php results from 3 runs
    3.512
    3.225
    3.146
    
    micro_bench.php avg: 3.2943
    Avg: real: 3.33s user: 3.24s sys: 0.01s cpu: 97.33% maxmem: 33629.33KB cswaits: 1.33
    created results log at /home/phpbench_logs/bench_micro_050518-160924.log
    server PHP info log at /home/phpbench_logs/bench_phpinfo_050518-160924.log
    
    
    -------------------------------------------
    ^Ocentminmodbench.sh completed
    ^O-------------------------------------------
    ^O
    centminmodbench.sh Total Run Time: 1230.122236145 seconds


    Code:
    -------------------------------------------
    centminmodbench.sh 0.9.6
    http://bench.centminmod.com
    written by: George Liu (eva2000)
    http://centminmod.com
    -------------------------------------------
    
    -------------------------------------------
    System Information
    -------------------------------------------
    
    4.16.0-1.el7.elrepo.x86_64
    
    CentOS Linux release 7.4.1708 (Core)
    
    Centmin Mod
    ----------------------------------------------
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 79
    Model name:            Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
    Stepping:              1
    CPU MHz:               2999.996
    BogoMIPS:              5999.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0
    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 cpuid 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 pti fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology cpuid 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 pti fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    ----------------------------------------------
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE
    0   0    0      0    0:0:0:0       yes
    
    ----------------------------------------------
                  total        used        free      shared  buff/cache   available
    Mem:           1994         484         291          29        1217        1178
    Low:           1994        1702         291
    High:             0           0           0
    Swap:          2047           1        2046
    
    ----------------------------------------------
    Filesystem      Size  Used Avail Use% Mounted on
    devtmpfs        986M     0  986M   0% /dev
    tmpfs           998M     0  998M   0% /dev/shm
    tmpfs           998M  8.5M  989M   1% /run
    tmpfs           998M     0  998M   0% /sys/fs/cgroup
    /dev/vda1        50G   12G   39G  23% /
    /dev/loop0      5.8G   26M  5.5G   1% /tmp
    tmpfs           200M     0  200M   0% /run/user/0
    tmpfs           200M     0  200M   0% /run/user/1000
    
    
    Code:
    -------------------------------------------
    disk ioping tests
    -------------------------------------------
    
    
    Running IOPing I/O benchmark...
    
    IOPing I/O: ./ioping -c 10 .
    4.0 KiB from . (xfs /dev/vda1): request=1 time=100 us
    4.0 KiB from . (xfs /dev/vda1): request=2 time=199 us
    4.0 KiB from . (xfs /dev/vda1): request=3 time=179 us
    4.0 KiB from . (xfs /dev/vda1): request=4 time=216 us
    4.0 KiB from . (xfs /dev/vda1): request=5 time=215 us
    4.0 KiB from . (xfs /dev/vda1): request=6 time=223 us
    4.0 KiB from . (xfs /dev/vda1): request=7 time=241 us
    4.0 KiB from . (xfs /dev/vda1): request=8 time=188 us
    4.0 KiB from . (xfs /dev/vda1): request=9 time=204 us
    4.0 KiB from . (xfs /dev/vda1): request=10 time=195 us
    
    --- . (xfs /dev/vda1) ioping statistics ---
    10 requests completed in 9.0 s, 5.1 k iops, 19.9 MiB/s
    min/avg/max/mdev = 100 us / 196 us / 241 us / 36 us
    
    IOPing seek rate: ./ioping -RD .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    39.6 k requests completed in 3.0 s, 13.4 k iops, 52.3 MiB/s
    min/avg/max/mdev = 52 us / 74 us / 1.1 ms / 35 us
    
    IOPing sequential: ./ioping -RL .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    4.7 k requests completed in 3.0 s, 1.6 k iops, 408.0 MiB/s
    min/avg/max/mdev = 467 us / 612 us / 12.0 ms / 542 us
    
    IOPing cached: ./ioping -RC .
    
    --- . (xfs /dev/vda1) ioping statistics ---
    2.6 M requests completed in 3.0 s, 939.8 k iops, 3.6 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 112 us / 0 us
    
    
    Code:
    -------------------------------------------
    disk DD tests
    -------------------------------------------
    
    dd if=/dev/zero of=sb-io-test bs=1M count=1k conv=fdatasync
    1024+0 records in
    1024+0 records out
    1073741824 bytes (1.1 GB) copied, 3.76613 s, 285 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=64k count=16k conv=fdatasync
    16384+0 records in
    16384+0 records out
    1073741824 bytes (1.1 GB) copied, 4.59288 s, 234 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=1M count=1k oflag=dsync
    1024+0 records in
    1024+0 records out
    1073741824 bytes (1.1 GB) copied, 8.09465 s, 133 MB/s
    
    dd if=/dev/zero of=sb-io-test bs=64k count=16k oflag=dsync
    16384+0 records in
    16384+0 records out
    1073741824 bytes (1.1 GB) copied, 21.3386 s, 50.3 MB/s
    
    Code:
    -------------------------------------------
    disk FIO tests
    -------------------------------------------
    
    
    Running FIO benchmark...
    
    
    FIO random reads:
    randomreads: (g=0): rw=randread, bs=4K-4K/4K-4K, ioengine=libaio, iodepth=64
    fio-2.0.9
    Starting 1 process
    randomreads: Laying out IO file(s) (1 file(s) / 1024MB)
    
    randomreads: (groupid=0, jobs=1): err= 0: pid=22295: Sat May  5 16:57:48 2018
      read : io=1024.3MB, bw=396233KB/s, iops=99058 , runt=  2647msec
      cpu          : usr=11.11%, sys=43.08%, ctx=11550, majf=0, minf=69
      IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=0.1%, 16=0.1%, 32=0.1%, >=64=100.0%
         submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
         complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.1%, >=64=0.0%
         issued    : total=r=262207/w=0/d=0, short=r=0/w=0/d=0
    
    Run status group 0 (all jobs):
       READ: io=1024.3MB, aggrb=396232KB/s, minb=396232KB/s, maxb=396232KB/s, mint=2647msec, maxt=2647msec
    
    Disk stats (read/write):
      vda: ios=255380/4, merge=0/0, ticks=128212/3, in_queue=124050, util=94.19%
    
    FIO random writes:
    randomwrites: (g=0): rw=randwrite, bs=4K-4K/4K-4K, ioengine=libaio, iodepth=64
    fio-2.0.9
    Starting 1 process
    
    randomwrites: (groupid=0, jobs=1): err= 0: pid=22299: Sat May  5 16:57:52 2018
      write: io=1024.3MB, bw=269552KB/s, iops=67388 , runt=  3891msec
      cpu          : usr=7.94%, sys=26.89%, ctx=17181, majf=0, minf=6
      IO depths    : 1=0.1%, 2=0.1%, 4=0.1%, 8=0.1%, 16=0.1%, 32=0.1%, >=64=100.0%
         submit    : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.0%, >=64=0.0%
         complete  : 0=0.0%, 4=100.0%, 8=0.0%, 16=0.0%, 32=0.0%, 64=0.1%, >=64=0.0%
         issued    : total=r=0/w=262207/d=0, short=r=0/w=0/d=0
    
    Run status group 0 (all jobs):
      WRITE: io=1024.3MB, aggrb=269552KB/s, minb=269552KB/s, maxb=269552KB/s, mint=3891msec, maxt=3891msec
    
    Disk stats (read/write):
      vda: ios=0/246650, merge=0/0, ticks=0/196749, in_queue=193883, util=97.07%
    
    
    Code:
    -------------------------------------------
    ramdisk DD tests - memory bandwidth
    -------------------------------------------
    
    dd if=/dev/zero of=sb-io-test bs=128k count=1k conv=fdatasync
    1024+0 records in
    1024+0 records out
    134217728 bytes (134 MB) copied, 0.0544023 s, 2.5 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=8k count=16k conv=fdatasync
    16384+0 records in
    16384+0 records out
    134217728 bytes (134 MB) copied, 0.0668163 s, 2.0 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=128k count=1k oflag=dsync
    1024+0 records in
    1024+0 records out
    134217728 bytes (134 MB) copied, 0.0542016 s, 2.5 GB/s
    
    dd if=/dev/zero of=sb-io-test bs=8k count=16k oflag=dsync
    16384+0 records in
    16384+0 records out
    134217728 bytes (134 MB) copied, 0.0656932 s, 2.0 GB/s
    
    Code:
    -------------------------------------------
    ramdisk ioping tests - memory bandwidth
    -------------------------------------------
    
    2018-05-05 16:57:55 URL:https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/ioping/ioping-0.8.tar.gz [10590/10590] -> "ioping-0.8.tar.gz" [1]
    Download done.
    ioping-0.8.tar.gz valid file.
    
    Running IOPing I/O ramdisk benchmark...
    cc -std=gnu99 -g -Wall -Wextra -pedantic -DVERSION=\"0.8\" -c -o ioping.o ioping.c
    cc -o ioping ioping.o -std=gnu99 -g -Wall -Wextra -pedantic  -lm
    
    IOPing I/O: ./ioping -c 10 .
    4.0 KiB from . (tmpfs tmpfs): request=1 time=2 us
    4.0 KiB from . (tmpfs tmpfs): request=2 time=8 us
    4.0 KiB from . (tmpfs tmpfs): request=3 time=8 us
    4.0 KiB from . (tmpfs tmpfs): request=4 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=5 time=7 us
    4.0 KiB from . (tmpfs tmpfs): request=6 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=7 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=8 time=6 us
    4.0 KiB from . (tmpfs tmpfs): request=9 time=7 us
    4.0 KiB from . (tmpfs tmpfs): request=10 time=7 us
    
    --- . (tmpfs tmpfs) ioping statistics ---
    10 requests completed in 9.0 s, 158.7 k iops, 620.0 MiB/s
    min/avg/max/mdev = 2 us / 6 us / 8 us / 1 us
    
    IOPing seek rate: ./ioping -R .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    1.9 M requests completed in 3.0 s, 846.3 k iops, 3.2 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 1.0 ms / 3 us
    
    IOPing sequential: ./ioping -RL .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    52.5 k requests completed in 3.0 s, 17.7 k iops, 4.3 GiB/s
    min/avg/max/mdev = 43 us / 56 us / 1.1 ms / 24 us
    
    IOPing cached: ./ioping -RC .
    
    --- . (tmpfs tmpfs) ioping statistics ---
    2.4 M requests completed in 3.0 s, 857.3 k iops, 3.3 GiB/s
    min/avg/max/mdev = 0 us / 1 us / 993 us / 2 us
    
    
    Code:
    -------------------------------------------
    Running bandwidth benchmark...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Cachefly (http://cachefly.cachefly.net/100mb.test)
    Download Cachefly: 26.5MB/s
    
    -------------------------------------------
    USA bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Linode, Atlanta, GA, USA (http://speedtest.atlanta.linode.com/100MB-atlanta.bin)
    Download Linode, Atlanta, GA, USA: 52.9MB/s
    ----------------------------------------------
    Download from Linode, Dallas, TX, USA (http://speedtest.dallas.linode.com/100MB-dallas.bin)
    Download Linode, Dallas, TX, USA: 45.8MB/s
    ----------------------------------------------
    Download from Leaseweb, Manassas, VA, USA (http://mirror.us.leaseweb.net/speedtest/100mb.bin)
    Download Leaseweb, Manassas, VA, USA: 53.1MB/s
    ----------------------------------------------
    Download from Softlayer, Seattle, WA, USA (http://speedtest.sea01.softlayer.com/downloads/test100.zip)
    Download Softlayer, Seattle, WA, USA: 39.0MB/s
    ----------------------------------------------
    Download from Softlayer, San Jose, CA, USA (http://speedtest.sjc01.softlayer.com/downloads/test100.zip)
    Download Softlayer, San Jose, CA, USA: 37.7MB/s
    ----------------------------------------------
    Download from Softlayer, Washington, DC, USA (http://speedtest.wdc01.softlayer.com/downloads/test100.zip)
    Download Softlayer, Washington, DC, USA: 49.4MB/s
    ----------------------------------------------
    Download from VersaWeb, Las Vegas, Nevada (http://lg.las1.as53340.net/100MB.test)
    Download VersaWeb, Las Vegas, Nevada: 7.43MB/s
    ----------------------------------------------
    Download from OVH, BHS, Canada (http://bhs.proof.ovh.net/files/100Mio.dat)
    Download OVH, BHS, Canada: 38.1MB/s
    
    -------------------------------------------
    Europe bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Download from Linode, London, UK (http://speedtest.london.linode.com/100MB-london.bin)
    Download Linode, London, UK: 23.1MB/s
    ----------------------------------------------
    Download from OVH, Paris, France (http://proof.ovh.net/files/100Mio.dat)
    Download OVH, Paris, France: 406KB/s
    ----------------------------------------------
    Download from SmartDC, Rotterdam, Netherlands (http://mirror.i3d.net/100mb.bin)
    Download SmartDC, Rotterdam, Netherlands: 18.4MB/s
    
    Code:
    -------------------------------------------
    Running Axel multi-threaded bandwidth benchmark...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Cachefly (http://cachefly.cachefly.net/100mb.test)
    Axel Download Cachefly: 44.42MB/s
    
    -------------------------------------------
    USA bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Linode, Atlanta, GA, USA (http://speedtest.atlanta.linode.com/100MB-atlanta.bin)
    Axel Download Linode, Atlanta, GA, USA: 44.16MB/s
    ----------------------------------------------
    Axel Download from Linode, Dallas, TX, USA (http://speedtest.dallas.linode.com/100MB-dallas.bin)
    Axel Download Linode, Dallas, TX, USA: 45.78MB/s
    ----------------------------------------------
    Axel Download from Leaseweb, Manassas, VA, USA (http://mirror.us.leaseweb.net/speedtest/100mb.bin)
    Axel Download Leaseweb, Manassas, VA, USA: 44.79MB/s
    ----------------------------------------------
    Axel Download from Softlayer, Seattle, WA, USA (http://speedtest.sea01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, Seattle, WA, USA: 30.26MB/s
    ----------------------------------------------
    Axel Download from Softlayer, San Jose, CA, USA (http://speedtest.sjc01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, San Jose, CA, USA: 27.66MB/s
    ----------------------------------------------
    Axel Download from Softlayer, Washington, DC, USA (http://speedtest.wdc01.softlayer.com/downloads/test100.zip)
    Axel Download Softlayer, Washington, DC, USA: 17.63MB/s
    ----------------------------------------------
    Axel Download from VersaWeb, Las Vegas, Nevada (http://lg.las1.as53340.net/100MB.test)
    Axel Download VersaWeb, Las Vegas, Nevada: 19.27MB/s
    ----------------------------------------------
    Axel Download from OVH, BHS, Canada (http://bhs.proof.ovh.net/files/100Mio.dat)
    Axel Download OVH, BHS, Canada: 45.39MB/s
    
    -------------------------------------------
    Europe bandwidth tests...
    -------------------------------------------
    
    ----------------------------------------------
    Axel Download from Linode, London, UK (http://speedtest.london.linode.com/100MB-london.bin)
    Axel Download Linode, London, UK: 24.65MB/s
    ----------------------------------------------
    Axel Download from OVH, Paris, France (http://proof.ovh.net/files/100Mio.dat)
    Axel Download OVH, Paris, France: 11.66MB/s
    ----------------------------------------------
    Axel Download from SmartDC, Rotterdam, Netherlands (http://mirror.i3d.net/100mb.bin)
    Axel Download SmartDC, Rotterdam, Netherlands: 17.16MB/s
    
    Code:
    -------------------------------------------
    Check system entropy pool availability
    -------------------------------------------
    
    entropy_avail: 4067
    entropy_avail: 4067
    entropy_avail: 4067
    entropy_avail: 4067
    
    Code:
    -------------------------------------------
    OpenSSL System Benchmark
    -------------------------------------------
    
    OpenSSL 1.0.2k-fips  26 Jan 2017
    -------------------------------------------
    openssl speed -multi 1 rsa4096 rsa2048 ecdsap256 sha256 sha1 md5 rc4 aes-256-cbc aes-128-cbc
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    md5              59156.08k   172351.36k   378180.10k   533522.77k   621931.18k
    sha1             68463.91k   201351.51k   445136.81k   725715.63k   851323.56k
    rc4             418487.94k   694631.89k   782047.32k   777197.23k   790601.73k
    aes-128 cbc     123973.24k   135510.27k   138391.89k   321765.38k   324657.15k
    aes-256 cbc      90830.18k    96817.24k    98222.68k   235658.24k   237289.47k
    sha256           72614.13k   160987.14k   294604.80k   371588.10k   401877.67k
                      sign    verify    sign/s verify/s
    rsa 2048 bits 0.000668s 0.000019s   1497.0  52631.6
    rsa 4096 bits 0.004639s 0.000067s    215.6  14925.4
                                  sign    verify    sign/s verify/s
     256 bit ecdsa (nistp256)   0.0000s   0.0001s  25641.0  11494.3
    -------------------------------------------
    openssl speed -evp aes256 -multi 1
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    evp             473481.78k   501276.97k   505601.71k   509446.14k   509460.48k
    -------------------------------------------
    openssl speed -evp aes128 -multi 1
    OpenSSL 1.0.2k-fips  26 Jan 2017
    built on: reproducible build, date unspecified
    options:bn(64,64) md2(int) rc4(16x,int) des(idx,cisc,16,int) aes(partial) idea(int) blowfish(idx)
    compiler: gcc -I. -I.. -I../include  -fPIC -DOPENSSL_PIC -DZLIB -DOPENSSL_THREADS -D_REENTRANT -DDSO_DLFCN -DHAVE_DLFCN_H -DKRB5_MIT -m64 -DL_ENDIAN -Wall -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches   -m64 -mtune=generic -Wa,--noexecstack -DPURIFY -DOPENSSL_IA32_SSE2 -DOPENSSL_BN_ASM_MONT -DOPENSSL_BN_ASM_MONT5 -DOPENSSL_BN_ASM_GF2m -DRC4_ASM -DSHA1_ASM -DSHA256_ASM -DSHA512_ASM -DMD5_ASM -DAES_ASM -DVPAES_ASM -DBSAES_ASM -DWHIRLPOOL_ASM -DGHASH_ASM -DECP_NISTZ256_ASM
    evp             647081.75k   694251.31k   706232.66k   709641.90k   711704.58k
    
    Code:
    -------------------------------------------
    Running mysqlslap
    -------------------------------------------
    
    mysqlslap --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=5 --number-int-cols=5 --number-char-cols=5 --number-of-queries=25000 --auto-generate-sql-unique-query-number=40 --auto-generate-sql-unique-write-number=40 --auto-generate-sql-write-number=1000 --concurrency=64 --iterations=10 --engine=myisam
    Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 2.309 seconds
        Minimum number of seconds to run all queries: 2.229 seconds
        Maximum number of seconds to run all queries: 2.583 seconds
        Number of clients running queries: 64
        Average number of queries per client: 390
    
    Dropping the database is potentially a very bad thing to do.
    Any data stored in the database will be destroyed.
    
    Do you really want to drop the 'test' database [y/N] Database "test" dropped
    
    Code:
    -------------------------------------------
    System PHP Info
    -------------------------------------------
    
    CPU: 1 x Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
                  total        used        free      shared  buff/cache   available
    Mem:           1994         397         821          30         775        1316
    Low:           1994        1172         821
    High:             0           0           0
    Swap:          2047           1        2046
    ----------------------------------------------
    PHP 7.2.5 (cli) (built: May  5 2018 16:51:32) ( NTS )
    Copyright (c) 1997-2018 The PHP Group
    Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
        with Zend OPcache v7.2.5, Copyright (c) 1999-2018, by Zend Technologies
    ----------------------------------------------
    Configuration File (php.ini) Path: /usr/local/lib
    Loaded Configuration File:         /usr/local/lib/php.ini
    Scan for additional .ini files in: /etc/centminmod/php.d
    Additional .ini files parsed:      /etc/centminmod/php.d/a_customphp.ini,
    /etc/centminmod/php.d/curlcainfo.ini,
    /etc/centminmod/php.d/geoip.ini,
    /etc/centminmod/php.d/igbinary.ini,
    /etc/centminmod/php.d/imagick.ini,
    /etc/centminmod/php.d/mailparse.ini,
    /etc/centminmod/php.d/mcrypt.ini,
    /etc/centminmod/php.d/memcache.ini,
    /etc/centminmod/php.d/memcached.ini,
    /etc/centminmod/php.d/redis.ini,
    /etc/centminmod/php.d/zendopcache.ini
    
    ----------------------------------------------
    [PHP Modules]
    bcmath
    bz2
    calendar
    Core
    ctype
    curl
    date
    dom
    enchant
    exif
    filter
    ftp
    gd
    geoip
    gettext
    gmp
    hash
    iconv
    igbinary
    imagick
    imap
    intl
    json
    ldap
    libxml
    mailparse
    mbstring
    mcrypt
    memcache
    memcached
    mysqli
    mysqlnd
    openssl
    pcntl
    pcre
    PDO
    pdo_mysql
    pdo_sqlite
    Phar
    posix
    pspell
    readline
    redis
    Reflection
    session
    shmop
    SimpleXML
    snmp
    soap
    sockets
    SPL
    sqlite3
    standard
    sysvmsg
    sysvsem
    sysvshm
    tidy
    tokenizer
    xml
    xmlreader
    xmlrpc
    xmlwriter
    xsl
    Zend OPcache
    zip
    zlib
    
    [Zend Modules]
    Zend OPcache
    
    ----------------------------------------------
    -------------------------------------------
    Run PHP test Zend/bench.php
    -------------------------------------------
    
    simple             0.030
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.022
    mandel             0.101
    mandel2            0.105
    ackermann(7)       0.023
    ary(50000)         0.005
    ary2(50000)        0.004
    ary3(2000)         0.047
    fibo(30)           0.073
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.024
    matrix(20)         0.024
    nestedloop(12)     0.049
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.577
    real: 0.61s user: 0.59s sys: 0.01s cpu: 99% maxmem: 39212 KB cswaits: 8
    
    simple             0.028
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.024
    mandel             0.098
    mandel2            0.105
    ackermann(7)       0.022
    ary(50000)         0.005
    ary2(50000)        0.003
    ary3(2000)         0.047
    fibo(30)           0.071
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.023
    matrix(20)         0.024
    nestedloop(12)     0.050
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.571
    real: 0.61s user: 0.59s sys: 0.01s cpu: 99% maxmem: 39392 KB cswaits: 1
    
    simple             0.028
    simplecall         0.009
    simpleucall        0.020
    simpleudcall       0.022
    mandel             0.096
    mandel2            0.103
    ackermann(7)       0.021
    ary(50000)         0.005
    ary2(50000)        0.004
    ary3(2000)         0.046
    fibo(30)           0.070
    hash1(50000)       0.011
    hash2(500)         0.009
    heapsort(20000)    0.024
    matrix(20)         0.024
    nestedloop(12)     0.049
    sieve(30)          0.017
    strcat(200000)     0.005
    ------------------------
    Total              0.563
    real: 0.60s user: 0.58s sys: 0.01s cpu: 99% maxmem: 39276 KB cswaits: 1
    
    bench.php results from 3 runs
    0.577
    0.571
    0.563
    
    bench.php avg: 0.5703
    Avg: real: 0.61s user: 0.59s sys: 0.01s cpu: 99.00% maxmem: 39293.33KB cswaits: 3.33
    created results log at /home/phpbench_logs/bench_050518-165626.log
    server PHP info log at /home/phpbench_logs/bench_phpinfo_050518-165626.log
    
    -------------------------------------------
    Run PHP test Zend/micro_bench.php
    -------------------------------------------
    
    empty_loop         0.035
    func()             0.098    0.063
    undef_func()       0.101    0.066
    int_func()         0.072    0.036
    $x = self::$x      0.091    0.056
    self::$x = 0       0.108    0.073
    isset(self::$x)    0.093    0.058
    empty(self::$x)    0.093    0.058
    $x = Foo::$x       0.068    0.033
    Foo::$x = 0        0.063    0.028
    isset(Foo::$x)     0.071    0.035
    empty(Foo::$x)     0.076    0.041
    self::f()          0.122    0.087
    Foo::f()           0.099    0.064
    $x = $this->x      0.065    0.030
    $this->x = 0       0.051    0.016
    $this->x += 2      0.090    0.055
    ++$this->x         0.069    0.033
    --$this->x         0.063    0.028
    $this->x++         0.087    0.052
    $this->x--         0.080    0.044
    isset($this->x)    0.083    0.048
    empty($this->x)    0.091    0.055
    $this->f()         0.099    0.064
    $x = Foo::TEST     0.093    0.058
    new Foo()          0.209    0.174
    $x = TEST          0.064    0.029
    $x = $_GET         0.087    0.052
    $x = $GLOBALS['v'] 0.129    0.094
    $x = $hash['v']    0.094    0.059
    $x = $str[0]       0.081    0.046
    $x = $a ?: null    0.075    0.040
    $x = $f ?: tmp     0.075    0.040
    $x = $f ? $f : $a  0.064    0.029
    $x = $f ? $f : tmp 0.069    0.034
    ------------------------
    Total              3.007
    real: 3.04s user: 3.02s sys: 0.01s cpu: 99% maxmem: 33120 KB cswaits: 2
    
    empty_loop         0.034
    func()             0.096    0.062
    undef_func()       0.101    0.067
    int_func()         0.069    0.036
    $x = self::$x      0.087    0.053
    self::$x = 0       0.090    0.057
    isset(self::$x)    0.088    0.054
    empty(self::$x)    0.094    0.061
    $x = Foo::$x       0.069    0.035
    Foo::$x = 0        0.064    0.030
    isset(Foo::$x)     0.071    0.037
    empty(Foo::$x)     0.077    0.044
    self::f()          0.122    0.088
    Foo::f()           0.101    0.067
    $x = $this->x      0.065    0.031
    $this->x = 0       0.050    0.017
    $this->x += 2      0.090    0.056
    ++$this->x         0.069    0.035
    --$this->x         0.063    0.029
    $this->x++         0.087    0.054
    $this->x--         0.082    0.048
    isset($this->x)    0.084    0.050
    empty($this->x)    0.090    0.057
    $this->f()         0.099    0.065
    $x = Foo::TEST     0.093    0.059
    new Foo()          0.209    0.176
    $x = TEST          0.069    0.035
    $x = $_GET         0.087    0.053
    $x = $GLOBALS['v'] 0.129    0.096
    $x = $hash['v']    0.095    0.061
    $x = $str[0]       0.081    0.047
    $x = $a ?: null    0.076    0.042
    $x = $f ?: tmp     0.078    0.044
    $x = $f ? $f : $a  0.068    0.034
    $x = $f ? $f : tmp 0.070    0.036
    ------------------------
    Total              2.996
    real: 3.03s user: 3.00s sys: 0.01s cpu: 99% maxmem: 33172 KB cswaits: 1
    
    empty_loop         0.034
    func()             0.096    0.062
    undef_func()       0.102    0.068
    int_func()         0.070    0.036
    $x = self::$x      0.088    0.054
    self::$x = 0       0.091    0.057
    isset(self::$x)    0.087    0.053
    empty(self::$x)    0.093    0.059
    $x = Foo::$x       0.068    0.034
    Foo::$x = 0        0.064    0.030
    isset(Foo::$x)     0.070    0.035
    empty(Foo::$x)     0.076    0.042
    self::f()          0.122    0.088
    Foo::f()           0.105    0.071
    $x = $this->x      0.065    0.031
    $this->x = 0       0.050    0.016
    $this->x += 2      0.090    0.056
    ++$this->x         0.069    0.034
    --$this->x         0.064    0.030
    $this->x++         0.087    0.053
    $this->x--         0.080    0.046
    isset($this->x)    0.083    0.049
    empty($this->x)    0.090    0.056
    $this->f()         0.098    0.064
    $x = Foo::TEST     0.093    0.059
    new Foo()          0.209    0.175
    
    ▽
    $x = TEST          0.073    0.039
    $x = $_GET         0.087    0.053
    $x = $GLOBALS['v'] 0.129    0.095
    $x = $hash['v']    0.094    0.060
    $x = $str[0]       0.081    0.047
    
    ▽
    Foo::$x = 0        0.064    0.030
    isset(Foo::$x)     0.070    0.035
    empty(Foo::$x)     0.076    0.042
    self::f()          0.122    0.088
    Foo::f()           0.105    0.071
    $x = $this->x      0.065    0.031
    $this->x = 0       0.050    0.016
    $this->x += 2      0.090    0.056
    ++$this->x         0.069    0.034
    --$this->x         0.064    0.030
    $this->x++         0.087    0.053
    $this->x--         0.080    0.046
    isset($this->x)    0.083    0.049
    empty($this->x)    0.090    0.056
    $this->f()         0.098    0.064
    $x = Foo::TEST     0.093    0.059
    new Foo()          0.209    0.175
    $x = TEST          0.073    0.039
    $x = $_GET         0.087    0.053
    $x = $GLOBALS['v'] 0.129    0.095
    $x = $hash['v']    0.094    0.060
    $x = $str[0]       0.081    0.047
    $x = $a ?: null    0.075    0.041
    $x = $f ?: tmp     0.075    0.041
    $x = $f ? $f : $a  0.064    0.030
    $x = $f ? $f : tmp 0.069    0.035
    ------------------------
    Total              2.989
    real: 3.02s user: 3.00s sys: 0.01s cpu: 99% maxmem: 33296 KB cswaits: 1
    
    micro_bench.php results from 3 runs
    3.007
    2.996
    2.989
    
    micro_bench.php avg: 2.9973
    Avg: real: 3.03s user: 3.01s sys: 0.01s cpu: 99.00% maxmem: 33196.00KB cswaits: 1.33
    created results log at /home/phpbench_logs/bench_micro_050518-165626.log
    server PHP info log at /home/phpbench_logs/bench_phpinfo_050518-165626.log
    
    
    -------------------------------------------
    centminmodbench.sh completed
    -------------------------------------------

    centminmodbench.sh Total Run Time: 715.650788491 seconds
     
    • Like Like x 2
  2. Colin

    Colin Active Member

    139
    41
    28
    Oct 7, 2015
    Sheffield UK
    Ratings:
    +102
    Local Time:
    7:11 PM
    1.13.#
    MariaDB 10.1.#
    I'm back running my test environment on upcloud. The `private` private network is mighty appealing. And it seems the pricing has had a tweak or two as well.

    May I ask what changes you made in the custom_inc ? And the reasoning if time permits :)
     
  3. eva2000

    eva2000 Administrator Staff Member

    38,511
    8,487
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,050
    Local Time:
    5:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    thanks for sharing.. @JJC84 seems you posted the same results twice though (there's 2 sets of them)
     
  4. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    They were two subsequent runs after a few tweaks to the custom_config.inc. Sorry for the late reply I have been taking courses 40 hours a week plus working at night.
     
    • Informative Informative x 1
  5. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    Hello Colin. I just saw this reply, and I will get back to you soon.
     
  6. eva2000

    eva2000 Administrator Staff Member

    38,511
    8,487
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,050
    Local Time:
    5:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    No probs hope you having fun with your courses. For benchmarks, I rolled out a new one for sysbench benchmarks too you might want to play with centminmod/centminmod-sysbench :)
     
  7. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    That is great and yes I'm having a lot of fun. I will check out the sysbench benchmarks very soon and report with my results. Cheers!
     
  8. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    Here is what I'm using regarding performance in my custom_config.inc which might actually need to be changed as I think some of the flags have become default or maybe deprecated with some of the newer beta branch updates.

    PHP_TUNING='y'
    PHP_PGO='y'
    MARCH_TARGETNATIVE='y'
    GCCINTEL_PHP='y'
    NGXDYNAMIC_DEVELKIT='y'
    NGINXPATCH='y'
    NGINX_ZLIBNG='y'
    NGINX_ZLIBCUSTOM='y'
    PHP_CUSTOMSSL='y'
    OPENSSL_THREADS='y'
    CLOUDFLARE_PATCHSSL='y'
    CLOUDFLARE_ZLIB='y'
    CLOUDFLARE_ZLIBPHP='y'
    OPENSSLECDSA_PATCH='y'
    OPENSSLECDHX_PATCH='y'
    VHOSTCTRL_CLOUDFLAREINC='y'
    OPENSSLEQUALCIPHER_PATCH='y'
     
    • Like Like x 1
  9. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    Results for the sysbench using the same config:

    Code:
    -------------------------------------------
    System Information
    -------------------------------------------
    
    3.10.0-862.2.3.el7.x86_64
    
    CentOS Linux release 7.5.1804 (Core)
    
    Centmin Mod
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                1
    On-line CPU(s) list:   0
    Thread(s) per core:    1
    Core(s) per socket:    1
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 79
    Model name:            Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
    Stepping:              1
    CPU MHz:               2999.996
    BogoMIPS:              5999.99
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0
    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 fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 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 fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE
    0   0    0      0    0:0:0:0       yes
    
                  total        used        free      shared  buff/cache   available
    Mem:           1838         330         256         123        1251        1069
    Low:           1838        1582         256
    High:             0           0           0
    Swap:          2047          16        2031
    
    Filesystem      Size  Used Avail Use% Mounted on
    /dev/vda1        50G   13G   38G  25% /
    devtmpfs        909M     0  909M   0% /dev
    tmpfs           920M     0  920M   0% /dev/shm
    tmpfs           920M   41M  879M   5% /run
    tmpfs           920M     0  920M   0% /sys/fs/cgroup
    /dev/loop0      5.8G   25M  5.5G   1% /tmp
    tmpfs           184M     0  184M   0% /run/user/0
    tmpfs           184M     0  184M   0% /run/user/1000
    
    
    sysbench cpu --cpu-max-prime=20000 --threads=1 run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    prime: 20000
    events/s: 411.92
    time: 10.0017s
    min: 2.38
    avg: 2.43
    max: 11.93
    95th: 2.48
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.14 | 1 | 411.92 | 10.0017s | 2.38 | 2.43 | 11.93 | 2.48 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.14,1,411.92,10.0017s,2.38,2.43,11.93,2.48
    
    sysbench cpu --cpu-max-prime=20000 --threads=1 run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    prime: 20000
    events/s: 407.86
    time: 10.0016s
    min: 2.38
    avg: 2.45
    max: 3.63
    95th: 2.52
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.14 | 1 | 407.86 | 10.0016s | 2.38 | 2.45 | 3.63 | 2.52 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.14,1,407.86,10.0016s,2.38,2.45,3.63,2.52
    
    sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (5469202.78 per second)
    transferred (5341.02 MiB/sec)
    time: 0.1900s
    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.14 | 1 | 1KiB | 1024MiB | read | 1048576 | 5341.02 | 0.1900s | 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.14,1,1KiB,1024MiB,read,1048576,5341.02,0.1900s,0.00,0.00,0.07,0.00
    
    sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (5448431.08 per second)
    transferred (5320.73 MiB/sec)
    time: 0.1908s
    min: 0.00
    avg: 0.00
    max: 0.04
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.14 | 1 | 1KiB | 1024MiB | read | 1048576 | 5320.73 | 0.1908s | 0.00 | 0.00 | 0.04 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.14,1,1KiB,1024MiB,read,1048576,5320.73,0.1908s,0.00,0.00,0.04,0.00
    
    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.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 13904.39
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 54.31
    written-MiB/s: 0.00
    time: 10.0002s
    min: 0.05
    avg: 0.07
    max: 3.86
    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.14 | 1 | 4KiB | I/O | read | 13904.39 | 0.00 | 0.00 | 54.31 | 0.00 | 10.0002s | 0.05 | 0.07 | 3.86 | 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.14,1,4KiB,I/O,read,13904.39,0.00,0.00,54.31,0.00,10.0002s,0.05,0.07,3.86,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.14 (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: 5960.40
    fsyncs/s: 7627.27
    read-MiB/s: 0.00
    written-MiB/s: 23.28
    time: 10.0002s
    min: 0.01
    avg: 0.07
    max: 68.09
    95th: 0.15
    
    | 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.14 | 1 | 4KiB | I/O | write | 0.00 | 5960.40 | 7627.27 | 0.00 | 23.28 | 10.0002s | 0.01 | 0.07 | 68.09 | 0.15 |
    
    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.14,1,4KiB,I/O,write,0.00,5960.40,7627.27,0.00,23.28,10.0002s,0.01,0.07,68.09,0.15
    
    
    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.14 (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: 12747.24
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 49.79
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.06
    avg: 0.08
    max: 4.92
    95th: 0.10
    
    | 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.14 | 1 | 4KiB | I/O | read | 12747.24 | 0.00 | 0.00 | 49.79 | 0.00 | 10.0001s | 0.06 | 0.08 | 4.92 | 0.10 |
    
    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.14,1,4KiB,I/O,read,12747.24,0.00,0.00,49.79,0.00,10.0001s,0.06,0.08,4.92,0.10
    
    
    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.14 (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: 5703.10
    fsyncs/s: 7294.59
    read-MiB/s: 0.00
    written-MiB/s: 22.28
    time: 10.0002s
    min: 0.01
    avg: 0.08
    max: 10.16
    95th: 0.17
    
    | fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.14 | 1 | 4KiB | I/O | write | 0.00 | 5703.10 | 7294.59 | 0.00 | 22.28 | 10.0002s | 0.01 | 0.08 | 10.16 | 0.17 |
    
    sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
    fileio,1.0.14,1,4KiB,I/O,write,0.00,5703.10,7294.59,0.00,22.28,10.0002s,0.01,0.08,10.16,0.17
    
    
    
    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=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.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    Block-size 4KiB
    Using synchronous I/O mode
    Doing sequential read test
    reads/s: 12324.83
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 48.14
    written-MiB/s: 0.00
    time: 10.0002s
    min: 0.06
    avg: 0.08
    max: 12.88
    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.14 | 1 | 4KiB | I/O | read | 12324.83 | 0.00 | 0.00 | 48.14 | 0.00 | 10.0002s | 0.06 | 0.08 | 12.88 | 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.14,1,4KiB,I/O,read,12324.83,0.00,0.00,48.14,0.00,10.0002s,0.06,0.08,12.88,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.14 (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: 6053.49
    fsyncs/s: 7742.45
    read-MiB/s: 0.00
    written-MiB/s: 23.65
    time: 10.0002s
    min: 0.01
    avg: 0.07
    max: 5.56
    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.14 | 1 | 4KiB | I/O | write | 0.00 | 6053.49 | 7742.45 | 0.00 | 23.65 | 10.0002s | 0.01 | 0.07 | 5.56 | 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.14,1,4KiB,I/O,write,0.00,6053.49,7742.45,0.00,23.65,10.0002s,0.01,0.07,5.56,0.16
    
    
    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.14 (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: 13175.22
    writes/s: 0.00
    fsyncs/s: 0.00
    read-MiB/s: 51.47
    written-MiB/s: 0.00
    time: 10.0001s
    min: 0.06
    avg: 0.08
    max: 5.78
    95th: 0.10
    
    | 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.14 | 1 | 4KiB | I/O | read | 13175.22 | 0.00 | 0.00 | 51.47 | 0.00 | 10.0001s | 0.06 | 0.08 | 5.78 | 0.10 |
    
    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.14,1,4KiB,I/O,read,13175.22,0.00,0.00,51.47,0.00,10.0001s,0.06,0.08,5.78,0.10
    
    
    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.14 (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: 6736.15
    fsyncs/s: 8612.67
    read-MiB/s: 0.00
    written-MiB/s: 26.31
    time: 10.0002s
    min: 0.01
    avg: 0.06
    max: 3.72
    95th: 0.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: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | fileio | 1.0.14 | 1 | 4KiB | I/O | write | 0.00 | 6736.15 | 8612.67 | 0.00 | 26.31 | 10.0002s | 0.01 | 0.06 | 3.72 | 0.14 |
    
    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.14,1,4KiB,I/O,write,0.00,6736.15,8612.67,0.00,26.31,10.0002s,0.01,0.06,3.72,0.14
    
    
    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.14 | 1 | 4KiB | I/O | read | 12324.83 | 0.00 | 0.00 | 48.14 | 0.00 | 10.0002s | 0.06 | 0.08 | 12.88 | 0.10 |
    |fileio | 1.0.14 | 1 | 4KiB | I/O | write | 0.00 | 6053.49 | 7742.45 | 0.00 | 23.65 | 10.0002s | 0.01 | 0.07 | 5.56 | 0.16 |
    
    | 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.14 | 1 | 4KiB | I/O | read | 13175.22 | 0.00 | 0.00 | 51.47 | 0.00 | 10.0001s | 0.06 | 0.08 | 5.78 | 0.10 |
    |fileio | 1.0.14 | 1 | 4KiB | I/O | write | 0.00 | 6736.15 | 8612.67 | 0.00 | 26.31 | 10.0002s | 0.01 | 0.06 | 3.72 | 0.14 |
    
    
    setup sbt database & user
    mysqladmin create database: sbt
    Grants for [email protected]
    GRANT USAGE ON *.* TO 'sbtest'@'localhost' IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E'
    GRANT ALL PRIVILEGES ON `sbt`.* TO 'sbtest'@'localhost'
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating secondary indexes on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating secondary indexes on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating secondary indexes on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating secondary indexes on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating secondary indexes on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating secondary indexes on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating secondary indexes on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating secondary indexes on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql benchmark:
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from current time
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 197.66 qps: 3971.82 (r/w/o: 2780.97/794.56/396.30) lat (ms,95%): 11.45 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 251.83 qps: 5023.43 (r/w/o: 3516.50/1003.28/503.65) lat (ms,95%): 7.43 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 259.95 qps: 5206.07 (r/w/o: 3646.35/1039.81/519.91) lat (ms,95%): 7.70 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 251.04 qps: 5011.85 (r/w/o: 3505.60/1004.17/502.09) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 264.00 qps: 5285.95 (r/w/o: 3701.96/1055.99/527.99) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 275.00 qps: 5503.07 (r/w/o: 3853.05/1100.01/550.01) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 272.00 qps: 5440.05 (r/w/o: 3808.04/1088.01/544.01) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 283.00 qps: 5648.92 (r/w/o: 3950.94/1131.98/565.99) lat (ms,95%): 5.28 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 275.01 qps: 5511.12 (r/w/o: 3861.08/1100.02/550.01) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 290.00 qps: 5792.92 (r/w/o: 4052.94/1159.98/579.99) lat (ms,95%): 5.37 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 277.00 qps: 5546.03 (r/w/o: 3884.02/1108.01/554.00) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 281.00 qps: 5616.97 (r/w/o: 3930.98/1123.99/562.00) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 282.98 qps: 5657.67 (r/w/o: 3959.77/1131.93/565.97) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 292.00 qps: 5833.02 (r/w/o: 4082.01/1168.00/583.00) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 284.01 qps: 5686.22 (r/w/o: 3981.15/1136.04/569.02) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 284.00 qps: 5692.03 (r/w/o: 3985.02/1139.01/568.00) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 272.00 qps: 5423.93 (r/w/o: 3794.95/1084.99/543.99) lat (ms,95%): 6.79 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 269.99 qps: 5398.72 (r/w/o: 3778.81/1079.94/539.97) lat (ms,95%): 6.43 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 271.00 qps: 5419.99 (r/w/o: 3794.00/1084.00/542.00) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 254.97 qps: 5114.35 (r/w/o: 3583.54/1020.87/509.93) lat (ms,95%): 7.04 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 280.86 qps: 5601.12 (r/w/o: 3917.99/1122.42/560.71) lat (ms,95%): 5.88 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 268.74 qps: 5389.81 (r/w/o: 3776.36/1074.96/538.48) lat (ms,95%): 7.04 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 273.29 qps: 5465.89 (r/w/o: 3826.12/1093.18/546.59) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 275.81 qps: 5516.16 (r/w/o: 3861.31/1103.23/551.62) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 271.22 qps: 5428.39 (r/w/o: 3797.05/1088.90/542.44) lat (ms,95%): 6.21 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 275.10 qps: 5496.09 (r/w/o: 3849.46/1096.42/550.21) lat (ms,95%): 7.43 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 273.93 qps: 5483.56 (r/w/o: 3837.00/1098.70/547.86) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 260.83 qps: 5213.58 (r/w/o: 3651.62/1040.30/521.66) lat (ms,95%): 7.04 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 278.09 qps: 5558.82 (r/w/o: 3890.28/1112.36/556.18) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 261.28 qps: 5227.65 (r/w/o: 3659.96/1045.13/522.56) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            113554
            write:                           32444
            other:                           16222
            total:                           162220
        transactions:                        8111   (270.22 per sec.)
        queries:                             162220 (5404.38 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0150s
        total number of events:              8111
    
    Latency (ms):
             min:                                    1.91
             avg:                                    3.70
             max:                                   52.24
             95th percentile:                        6.43
             sum:                                29994.62
    
    Threads fairness:
        events (avg/stddev):           8111.0000/0.00
        execution time (avg/stddev):   29.9946/0.00
    
    
    sysbench mysql summary:
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 113554
    write: 32444
    other: 16222
    total: 162220
    transactions/s: 270.22
    queries/s: 5404.38
    time: 30.0150s
    min: 1.91
    avg: 3.70
    max: 52.24
    95th: 6.43
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp.lua | 1.0.14 | 1 | 113554 | 32444 | 16222 | 162220 | 270.22 | 5404.38 | 30.0150s | 1.91 | 3.70 | 52.24 | 6.43 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp.lua,1.0.14,1,113554,32444,16222,162220,270.22,5404.38,30.0150s,1.91,3.70,52.24,6.43
    
    sysbench mysql cleanup database: sbt
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating secondary indexes on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating secondary indexes on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating secondary indexes on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating secondary indexes on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating secondary indexes on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating secondary indexes on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating secondary indexes on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating secondary indexes on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql read only benchmark:
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --oltp-read-only=on --oltp-skip-trx=on --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from current time
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 398.69 qps: 5582.72 (r/w/o: 5582.72/0.00/0.00) lat (ms,95%): 3.30 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 410.28 qps: 5754.88 (r/w/o: 5754.88/0.00/0.00) lat (ms,95%): 3.19 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 423.03 qps: 5918.39 (r/w/o: 5918.39/0.00/0.00) lat (ms,95%): 3.02 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 423.59 qps: 5929.28 (r/w/o: 5929.28/0.00/0.00) lat (ms,95%): 2.97 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 420.97 qps: 5894.53 (r/w/o: 5894.53/0.00/0.00) lat (ms,95%): 3.07 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 422.61 qps: 5921.53 (r/w/o: 5921.53/0.00/0.00) lat (ms,95%): 3.02 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 428.44 qps: 5996.15 (r/w/o: 5996.15/0.00/0.00) lat (ms,95%): 3.02 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 449.84 qps: 6299.84 (r/w/o: 6299.84/0.00/0.00) lat (ms,95%): 2.76 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 431.14 qps: 6035.96 (r/w/o: 6035.96/0.00/0.00) lat (ms,95%): 2.97 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 442.00 qps: 6184.96 (r/w/o: 6184.96/0.00/0.00) lat (ms,95%): 2.81 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 437.97 qps: 6129.52 (r/w/o: 6129.52/0.00/0.00) lat (ms,95%): 2.91 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 438.00 qps: 6134.98 (r/w/o: 6134.98/0.00/0.00) lat (ms,95%): 2.81 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 429.91 qps: 6020.80 (r/w/o: 6020.80/0.00/0.00) lat (ms,95%): 2.91 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 432.09 qps: 6041.25 (r/w/o: 6041.25/0.00/0.00) lat (ms,95%): 2.81 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 432.87 qps: 6055.20 (r/w/o: 6055.20/0.00/0.00) lat (ms,95%): 2.86 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 424.14 qps: 5939.92 (r/w/o: 5939.92/0.00/0.00) lat (ms,95%): 3.02 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 423.01 qps: 5932.20 (r/w/o: 5932.20/0.00/0.00) lat (ms,95%): 3.13 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 441.84 qps: 6186.81 (r/w/o: 6186.81/0.00/0.00) lat (ms,95%): 2.76 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 416.14 qps: 5823.93 (r/w/o: 5823.93/0.00/0.00) lat (ms,95%): 3.36 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 424.78 qps: 5948.93 (r/w/o: 5948.93/0.00/0.00) lat (ms,95%): 3.02 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 417.16 qps: 5840.20 (r/w/o: 5840.20/0.00/0.00) lat (ms,95%): 3.19 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 419.97 qps: 5878.62 (r/w/o: 5878.62/0.00/0.00) lat (ms,95%): 3.30 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 433.07 qps: 6059.94 (r/w/o: 6059.94/0.00/0.00) lat (ms,95%): 2.91 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 422.91 qps: 5911.81 (r/w/o: 5911.81/0.00/0.00) lat (ms,95%): 2.91 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 432.08 qps: 6057.16 (r/w/o: 6057.16/0.00/0.00) lat (ms,95%): 2.91 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 421.02 qps: 5886.27 (r/w/o: 5886.27/0.00/0.00) lat (ms,95%): 3.36 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 452.03 qps: 6339.39 (r/w/o: 6339.39/0.00/0.00) lat (ms,95%): 2.71 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 445.88 qps: 6231.29 (r/w/o: 6231.29/0.00/0.00) lat (ms,95%): 2.81 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 427.96 qps: 6003.42 (r/w/o: 6003.42/0.00/0.00) lat (ms,95%): 2.81 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 416.14 qps: 5820.94 (r/w/o: 5820.94/0.00/0.00) lat (ms,95%): 3.19 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            179774
            write:                           0
            other:                           0
            total:                           179774
        transactions:                        12841  (427.89 per sec.)
        queries:                             179774 (5990.45 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0085s
        total number of events:              12841
    
    Latency (ms):
             min:                                    1.04
             avg:                                    2.33
             max:                                   25.74
             95th percentile:                        3.02
             sum:                                29982.57
    
    Threads fairness:
        events (avg/stddev):           12841.0000/0.00
        execution time (avg/stddev):   29.9826/0.00
    
    
    sysbench mysql read only summary:
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --oltp-read-only=on --oltp-skip-trx=on --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 179774
    write: 0
    other: 0
    total: 179774
    transactions/s: 427.89
    queries/s: 5990.45
    time: 30.0085s
    min: 1.04
    avg: 2.33
    max: 25.74
    95th: 3.02
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp.lua | 1.0.14 | 1 | 179774 | 0 | 0 | 179774 | 427.89 | 5990.45 | 30.0085s | 1.04 | 2.33 | 25.74 | 3.02 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp.lua,1.0.14,1,179774,0,0,179774,427.89,5990.45,30.0085s,1.04,2.33,25.74,3.02
    
    sysbench mysql cleanup database: sbt
    sysbench oltp.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench update_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating secondary indexes on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating secondary indexes on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating secondary indexes on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating secondary indexes on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating secondary indexes on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating secondary indexes on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating secondary indexes on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating secondary indexes on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql update index benchmark:
    sysbench update_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from current time
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 1497.40 qps: 1497.40 (r/w/o: 0.00/1497.40/0.00) lat (ms,95%): 1.37 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 1803.20 qps: 1803.20 (r/w/o: 0.00/1803.20/0.00) lat (ms,95%): 1.44 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 2318.15 qps: 2318.15 (r/w/o: 0.00/2318.15/0.00) lat (ms,95%): 1.16 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 2142.99 qps: 2142.99 (r/w/o: 0.00/2142.99/0.00) lat (ms,95%): 1.06 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 2542.87 qps: 2542.87 (r/w/o: 0.00/2542.87/0.00) lat (ms,95%): 1.04 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 2133.29 qps: 2133.29 (r/w/o: 0.00/2133.29/0.00) lat (ms,95%): 1.04 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 2818.52 qps: 2818.52 (r/w/o: 0.00/2818.52/0.00) lat (ms,95%): 0.87 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 2173.50 qps: 2173.50 (r/w/o: 0.00/2173.50/0.00) lat (ms,95%): 1.01 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 2602.67 qps: 2602.67 (r/w/o: 0.00/2602.67/0.00) lat (ms,95%): 0.94 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 2295.10 qps: 2295.10 (r/w/o: 0.00/2295.10/0.00) lat (ms,95%): 0.94 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 2582.41 qps: 2582.41 (r/w/o: 0.00/2582.41/0.00) lat (ms,95%): 0.90 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 2335.18 qps: 2335.18 (r/w/o: 0.00/2335.18/0.00) lat (ms,95%): 0.89 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 2902.29 qps: 2902.29 (r/w/o: 0.00/2902.29/0.00) lat (ms,95%): 0.84 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 2335.71 qps: 2335.71 (r/w/o: 0.00/2335.71/0.00) lat (ms,95%): 0.92 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 2784.40 qps: 2784.40 (r/w/o: 0.00/2784.40/0.00) lat (ms,95%): 0.86 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 2392.31 qps: 2392.31 (r/w/o: 0.00/2392.31/0.00) lat (ms,95%): 0.94 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 3002.19 qps: 3002.19 (r/w/o: 0.00/3002.19/0.00) lat (ms,95%): 0.80 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 2466.00 qps: 2466.00 (r/w/o: 0.00/2466.00/0.00) lat (ms,95%): 0.84 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 2881.99 qps: 2881.99 (r/w/o: 0.00/2881.99/0.00) lat (ms,95%): 0.81 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 2389.87 qps: 2389.87 (r/w/o: 0.00/2389.87/0.00) lat (ms,95%): 0.89 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 3030.92 qps: 3030.92 (r/w/o: 0.00/3030.92/0.00) lat (ms,95%): 0.78 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 2358.98 qps: 2358.98 (r/w/o: 0.00/2358.98/0.00) lat (ms,95%): 0.89 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 3053.28 qps: 3053.28 (r/w/o: 0.00/3053.28/0.00) lat (ms,95%): 0.80 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 2460.44 qps: 2460.44 (r/w/o: 0.00/2460.44/0.00) lat (ms,95%): 0.84 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 3207.66 qps: 3207.66 (r/w/o: 0.00/3207.66/0.00) lat (ms,95%): 0.73 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 2532.90 qps: 2532.90 (r/w/o: 0.00/2532.90/0.00) lat (ms,95%): 0.87 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 3185.77 qps: 3185.77 (r/w/o: 0.00/3185.77/0.00) lat (ms,95%): 0.75 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 2833.34 qps: 2833.34 (r/w/o: 0.00/2833.34/0.00) lat (ms,95%): 0.72 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 3446.08 qps: 3446.08 (r/w/o: 0.00/3446.08/0.00) lat (ms,95%): 0.67 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 2701.14 qps: 2701.14 (r/w/o: 0.00/2701.14/0.00) lat (ms,95%): 0.81 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            0
            write:                           77214
            other:                           0
            total:                           77214
        transactions:                        77214  (2573.16 per sec.)
        queries:                             77214  (2573.16 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0059s
        total number of events:              77214
    
    Latency (ms):
             min:                                    0.08
             avg:                                    0.39
             max:                                   42.98
             95th percentile:                        0.90
             sum:                                29885.84
    
    Threads fairness:
        events (avg/stddev):           77214.0000/0.00
        execution time (avg/stddev):   29.8858/0.00
    
    
    sysbench mysql update index summary:
    sysbench update_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 0
    write: 77214
    other: 0
    total: 77214
    transactions/s: 2573.16
    queries/s: 2573.16
    time: 30.0059s
    min: 0.08
    avg: 0.39
    max: 42.98
    95th: 0.90
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | update_index.lua | 1.0.14 | 1 | 0 | 77214 | 0 | 77214 | 2573.16 | 2573.16 | 30.0059s | 0.08 | 0.39 | 42.98 | 0.90 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    update_index.lua,1.0.14,1,0,77214,0,77214,2573.16,2573.16,30.0059s,0.08,0.39,42.98,0.90
    
    sysbench mysql cleanup database: sbt
    sysbench update_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench update_non_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating secondary indexes on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating secondary indexes on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating secondary indexes on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating secondary indexes on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating secondary indexes on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating secondary indexes on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating secondary indexes on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating secondary indexes on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql update index benchmark:
    sysbench update_non_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from current time
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 5656.11 qps: 5656.11 (r/w/o: 0.00/5656.11/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 5802.50 qps: 5802.50 (r/w/o: 0.00/5802.50/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 5705.87 qps: 5705.87 (r/w/o: 0.00/5705.87/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 5919.05 qps: 5919.05 (r/w/o: 0.00/5919.05/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 5753.99 qps: 5753.99 (r/w/o: 0.00/5753.99/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 5795.81 qps: 5795.81 (r/w/o: 0.00/5795.81/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 6056.25 qps: 6056.25 (r/w/o: 0.00/6056.25/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 6177.60 qps: 6177.60 (r/w/o: 0.00/6177.60/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 5860.51 qps: 5860.51 (r/w/o: 0.00/5860.51/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 5625.40 qps: 5625.40 (r/w/o: 0.00/5625.40/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 5793.30 qps: 5793.30 (r/w/o: 0.00/5793.30/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 5877.12 qps: 5877.12 (r/w/o: 0.00/5877.12/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 5874.20 qps: 5874.20 (r/w/o: 0.00/5874.20/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 5774.87 qps: 5774.87 (r/w/o: 0.00/5774.87/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 5989.88 qps: 5989.88 (r/w/o: 0.00/5989.88/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 6180.16 qps: 6180.16 (r/w/o: 0.00/6180.16/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 5946.85 qps: 5946.85 (r/w/o: 0.00/5946.85/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 6018.42 qps: 6018.42 (r/w/o: 0.00/6018.42/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 5861.56 qps: 5861.56 (r/w/o: 0.00/5861.56/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 6264.60 qps: 6264.60 (r/w/o: 0.00/6264.60/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 6377.68 qps: 6377.68 (r/w/o: 0.00/6377.68/0.00) lat (ms,95%): 0.26 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 6316.21 qps: 6316.21 (r/w/o: 0.00/6316.21/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 6515.72 qps: 6515.72 (r/w/o: 0.00/6515.72/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 6079.49 qps: 6079.49 (r/w/o: 0.00/6079.49/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 5658.41 qps: 5658.41 (r/w/o: 0.00/5658.41/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 6432.22 qps: 6432.22 (r/w/o: 0.00/6432.22/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 6140.20 qps: 6140.20 (r/w/o: 0.00/6140.20/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 6078.97 qps: 6078.97 (r/w/o: 0.00/6078.97/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 5819.71 qps: 5819.71 (r/w/o: 0.00/5819.71/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 6056.34 qps: 6056.34 (r/w/o: 0.00/6056.34/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            0
            write:                           179422
            other:                           0
            total:                           179422
        transactions:                        179422 (5979.87 per sec.)
        queries:                             179422 (5979.87 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0029s
        total number of events:              179422
    
    Latency (ms):
             min:                                    0.08
             avg:                                    0.17
             max:                                   42.98
             95th percentile:                        0.28
             sum:                                29758.96
    
    Threads fairness:
        events (avg/stddev):           179422.0000/0.00
        execution time (avg/stddev):   29.7590/0.00
    
    
    sysbench mysql update index summary:
    sysbench update_non_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 0
    write: 179422
    other: 0
    total: 179422
    transactions/s: 5979.87
    queries/s: 5979.87
    time: 30.0029s
    min: 0.08
    avg: 0.17
    max: 42.98
    95th: 0.28
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | update_non_index.lua | 1.0.14 | 1 | 0 | 179422 | 0 | 179422 | 5979.87 | 5979.87 | 30.0029s | 0.08 | 0.17 | 42.98 | 0.28 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    update_non_index.lua,1.0.14,1,0,179422,0,179422,5979.87,5979.87,30.0029s,0.08,0.17,42.98,0.28
    
    sysbench mysql cleanup database: sbt
    sysbench update_non_index.lua --mysql-host=localhost --mysql-port=3306 --mysql-socket=/var/lib/mysql/mysql.sock --mysql-user=sbtest --mysql-password=sbtestpass --mysql-db=sbt --mysql-table-engine=InnoDB --time=30 --threads=1 --report-interval=1 --oltp-table-size=150000 --oltp-tables-count=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating a secondary index on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating a secondary index on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | 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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 88.76 qps: 1786.14 (r/w/o: 1252.59/355.03/178.51) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 121.92 qps: 2446.43 (r/w/o: 1710.90/491.68/243.84) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 122.88 qps: 2457.60 (r/w/o: 1720.32/491.52/245.76) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 132.48 qps: 2642.62 (r/w/o: 1851.73/525.93/264.96) lat (ms,95%): 16.41 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 130.38 qps: 2610.66 (r/w/o: 1828.36/521.53/260.77) lat (ms,95%): 17.01 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 126.74 qps: 2538.88 (r/w/o: 1774.42/510.97/253.49) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 148.01 qps: 2949.11 (r/w/o: 2065.07/588.02/296.01) lat (ms,95%): 17.63 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 135.00 qps: 2705.96 (r/w/o: 1895.97/539.99/270.00) lat (ms,95%): 16.41 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 124.87 qps: 2502.49 (r/w/o: 1749.24/503.49/249.75) lat (ms,95%): 21.50 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 118.73 qps: 2368.59 (r/w/o: 1660.23/470.90/237.46) lat (ms,95%): 21.89 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 132.78 qps: 2657.49 (r/w/o: 1860.84/531.10/265.55) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 136.32 qps: 2712.21 (r/w/o: 1894.31/545.27/272.64) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 131.62 qps: 2644.30 (r/w/o: 1854.57/526.49/263.24) lat (ms,95%): 16.41 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 125.32 qps: 2505.29 (r/w/o: 1753.40/501.26/250.63) lat (ms,95%): 15.55 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 140.00 qps: 2800.96 (r/w/o: 1960.97/559.99/280.00) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 129.00 qps: 2568.98 (r/w/o: 1794.99/516.00/258.00) lat (ms,95%): 24.83 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 147.00 qps: 2956.10 (r/w/o: 2071.07/591.02/294.01) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 141.99 qps: 2831.85 (r/w/o: 1982.89/564.97/283.98) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 148.88 qps: 2986.54 (r/w/o: 2089.28/599.51/297.75) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 149.04 qps: 2970.73 (r/w/o: 2080.51/592.15/298.07) lat (ms,95%): 15.00 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 142.09 qps: 2843.75 (r/w/o: 1991.23/568.35/284.18) lat (ms,95%): 16.12 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 136.98 qps: 2740.50 (r/w/o: 1918.65/547.90/273.95) lat (ms,95%): 20.00 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 141.83 qps: 2831.68 (r/w/o: 1980.68/567.34/283.67) lat (ms,95%): 17.32 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 130.04 qps: 2608.72 (r/w/o: 1828.51/520.14/260.07) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 135.88 qps: 2720.52 (r/w/o: 1902.27/546.50/271.75) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 147.21 qps: 2940.25 (r/w/o: 2059.98/585.85/294.43) lat (ms,95%): 16.71 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 145.07 qps: 2902.33 (r/w/o: 2031.93/580.27/290.13) lat (ms,95%): 20.00 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 152.87 qps: 3061.40 (r/w/o: 2140.18/615.48/305.74) lat (ms,95%): 15.55 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 147.03 qps: 2927.67 (r/w/o: 2049.47/584.13/294.07) lat (ms,95%): 19.29 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 152.10 qps: 3038.94 (r/w/o: 2126.36/608.39/304.19) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            56896
            write:                           16256
            other:                           8128
            total:                           81280
        transactions:                        4064   (135.33 per sec.)
        queries:                             81280  (2706.59 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0289s
        total number of events:              4064
    
    Latency (ms):
             min:                                    4.03
             avg:                                    7.39
             max:                                  229.21
             95th percentile:                       18.61
             sum:                                30014.97
    
    Threads fairness:
        events (avg/stddev):           4064.0000/0.00
        execution time (avg/stddev):   30.0150/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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 56896
    write: 16256
    other: 8128
    total: 81280
    transactions/s: 135.33
    queries/s: 2706.59
    time: 30.0289s
    min: 4.03
    avg: 7.39
    max: 229.21
    95th: 18.61
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_write.lua | 1.0.14 | 1 | 56896 | 16256 | 8128 | 81280 | 135.33 | 2706.59 | 30.0289s | 4.03 | 7.39 | 229.21 | 18.61 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_write.lua,1.0.14,1,56896,16256,8128,81280,135.33,2706.59,30.0289s,4.03,7.39,229.21,18.61
    
    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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench oltp_read_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating a secondary index on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating a secondary index on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql OLTP read only new benchmark:
    sysbench oltp_read_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 153.65 qps: 2461.47 (r/w/o: 2153.16/0.00/308.31) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 169.07 qps: 2713.16 (r/w/o: 2375.01/0.00/338.14) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 164.01 qps: 2616.16 (r/w/o: 2288.14/0.00/328.02) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 191.01 qps: 3066.14 (r/w/o: 2684.12/0.00/382.02) lat (ms,95%): 11.24 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 194.00 qps: 3105.07 (r/w/o: 2717.06/0.00/388.01) lat (ms,95%): 11.45 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 176.00 qps: 2812.95 (r/w/o: 2460.96/0.00/351.99) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 192.97 qps: 3090.52 (r/w/o: 2704.58/0.00/385.94) lat (ms,95%): 10.65 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 196.03 qps: 3134.55 (r/w/o: 2742.48/0.00/392.07) lat (ms,95%): 10.27 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 188.99 qps: 3025.85 (r/w/o: 2647.87/0.00/377.98) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 196.00 qps: 3127.97 (r/w/o: 2735.98/0.00/392.00) lat (ms,95%): 11.04 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 181.00 qps: 2901.95 (r/w/o: 2539.95/0.00/361.99) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 187.01 qps: 2986.09 (r/w/o: 2612.08/0.00/374.01) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 186.00 qps: 2970.96 (r/w/o: 2598.96/0.00/371.99) lat (ms,95%): 12.08 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 194.01 qps: 3109.19 (r/w/o: 2721.17/0.00/388.02) lat (ms,95%): 10.84 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 232.99 qps: 3727.83 (r/w/o: 3261.86/0.00/465.98) lat (ms,95%): 5.28 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 218.99 qps: 3511.88 (r/w/o: 3073.89/0.00/437.98) lat (ms,95%): 5.67 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 239.01 qps: 3821.23 (r/w/o: 3343.20/0.00/478.03) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 240.98 qps: 3855.74 (r/w/o: 3373.77/0.00/481.97) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 238.02 qps: 3804.35 (r/w/o: 3328.30/0.00/476.04) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 228.99 qps: 3669.81 (r/w/o: 3211.83/0.00/457.98) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 236.01 qps: 3777.18 (r/w/o: 3305.15/0.00/472.02) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 238.99 qps: 3818.91 (r/w/o: 3340.92/0.00/477.99) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 237.01 qps: 3788.10 (r/w/o: 3314.09/0.00/474.01) lat (ms,95%): 5.18 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 242.93 qps: 3895.92 (r/w/o: 3410.05/0.00/485.87) lat (ms,95%): 4.65 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 244.04 qps: 3904.61 (r/w/o: 3416.53/0.00/488.08) lat (ms,95%): 4.57 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 212.00 qps: 3392.00 (r/w/o: 2968.00/0.00/424.00) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 211.02 qps: 3377.37 (r/w/o: 2955.33/0.00/422.05) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 235.99 qps: 3772.90 (r/w/o: 3300.92/0.00/471.99) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 232.00 qps: 3711.06 (r/w/o: 3247.05/0.00/464.01) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 235.99 qps: 3771.83 (r/w/o: 3299.85/0.00/471.98) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            88144
            write:                           0
            other:                           12592
            total:                           100736
        transactions:                        6296   (209.82 per sec.)
        queries:                             100736 (3357.11 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0053s
        total number of events:              6296
    
    Latency (ms):
             min:                                    2.97
             avg:                                    4.76
             max:                                  163.91
             95th percentile:                        9.22
             sum:                                29978.47
    
    Threads fairness:
        events (avg/stddev):           6296.0000/0.00
        execution time (avg/stddev):   29.9785/0.00
    
    
    sysbench mysql OLTP read only new summary:
    sysbench oltp_read_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 88144
    write: 0
    other: 12592
    total: 100736
    transactions/s: 209.82
    queries/s: 3357.11
    time: 30.0053s
    min: 2.97
    avg: 4.76
    max: 163.91
    95th: 9.22
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_read_only.lua | 1.0.14 | 1 | 88144 | 0 | 12592 | 100736 | 209.82 | 3357.11 | 30.0053s | 2.97 | 4.76 | 163.91 | 9.22 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_read_only.lua,1.0.14,1,88144,0,12592,100736,209.82,3357.11,30.0053s,2.97,4.76,163.91,9.22
    
    sysbench mysql cleanup database: sbt
    sysbench oltp_read_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench oltp_write_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating a secondary index on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating a secondary index on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql OLTP write only new benchmark:
    sysbench oltp_write_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 385.23 qps: 2312.37 (r/w/o: 0.00/1540.91/771.46) lat (ms,95%): 7.84 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 432.07 qps: 2592.43 (r/w/o: 0.00/1728.28/864.14) lat (ms,95%): 7.30 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 503.00 qps: 3020.00 (r/w/o: 0.00/2014.00/1006.00) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 510.96 qps: 3063.76 (r/w/o: 0.00/2041.84/1021.92) lat (ms,95%): 6.67 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 493.09 qps: 2961.49 (r/w/o: 0.00/1975.32/986.17) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 482.91 qps: 2898.44 (r/w/o: 0.00/1932.63/965.81) lat (ms,95%): 6.79 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 531.76 qps: 3187.59 (r/w/o: 0.00/2124.06/1063.53) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 540.03 qps: 3239.18 (r/w/o: 0.00/2159.12/1080.06) lat (ms,95%): 6.91 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 605.89 qps: 3636.33 (r/w/o: 0.00/2424.56/1211.78) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 570.50 qps: 3421.97 (r/w/o: 0.00/2280.98/1140.99) lat (ms,95%): 5.67 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 602.97 qps: 3620.77 (r/w/o: 0.00/2414.84/1205.93) lat (ms,95%): 5.47 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 575.99 qps: 3454.94 (r/w/o: 0.00/2302.96/1151.98) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 548.44 qps: 3290.66 (r/w/o: 0.00/2193.77/1096.89) lat (ms,95%): 6.09 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 595.42 qps: 3572.50 (r/w/o: 0.00/2381.67/1190.83) lat (ms,95%): 5.77 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 573.11 qps: 3438.63 (r/w/o: 0.00/2292.42/1146.21) lat (ms,95%): 6.43 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 581.78 qps: 3488.69 (r/w/o: 0.00/2325.13/1163.56) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 505.55 qps: 3035.33 (r/w/o: 0.00/2024.22/1011.10) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 618.31 qps: 3707.89 (r/w/o: 0.00/2471.26/1236.62) lat (ms,95%): 5.77 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 578.19 qps: 3471.16 (r/w/o: 0.00/2314.78/1156.38) lat (ms,95%): 6.32 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 628.90 qps: 3773.43 (r/w/o: 0.00/2515.62/1257.81) lat (ms,95%): 5.00 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 619.34 qps: 3716.07 (r/w/o: 0.00/2477.38/1238.69) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 625.01 qps: 3749.07 (r/w/o: 0.00/2499.05/1250.02) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 615.99 qps: 3694.94 (r/w/o: 0.00/2462.96/1231.98) lat (ms,95%): 4.91 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 624.37 qps: 3746.25 (r/w/o: 0.00/2497.50/1248.75) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 496.47 qps: 2982.81 (r/w/o: 0.00/1989.87/992.93) lat (ms,95%): 7.17 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 674.71 qps: 4044.27 (r/w/o: 0.00/2694.85/1349.42) lat (ms,95%): 4.82 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 544.61 qps: 3270.68 (r/w/o: 0.00/2181.46/1089.22) lat (ms,95%): 6.55 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 699.82 qps: 4199.92 (r/w/o: 0.00/2800.28/1399.64) lat (ms,95%): 4.49 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 570.05 qps: 3416.32 (r/w/o: 0.00/2276.21/1140.11) lat (ms,95%): 5.99 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 593.25 qps: 3560.52 (r/w/o: 0.00/2374.01/1186.51) lat (ms,95%): 5.57 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            0
            write:                           67732
            other:                           33866
            total:                           101598
        transactions:                        16933  (564.28 per sec.)
        queries:                             101598 (3385.67 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0068s
        total number of events:              16933
    
    Latency (ms):
             min:                                    0.32
             avg:                                    1.77
             max:                                   55.27
             95th percentile:                        6.09
             sum:                                29972.74
    
    Threads fairness:
        events (avg/stddev):           16933.0000/0.00
        execution time (avg/stddev):   29.9727/0.00
    
    
    sysbench mysql OLTP write only new summary:
    sysbench oltp_write_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 0
    write: 67732
    other: 33866
    total: 101598
    transactions/s: 564.28
    queries/s: 3385.67
    time: 30.0068s
    min: 0.32
    avg: 1.77
    max: 55.27
    95th: 6.09
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_write_only.lua | 1.0.14 | 1 | 0 | 67732 | 33866 | 101598 | 564.28 | 3385.67 | 30.0068s | 0.32 | 1.77 | 55.27 | 6.09 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_write_only.lua,1.0.14,1,0,67732,33866,101598,564.28,3385.67,30.0068s,0.32,1.77,55.27,6.09
    
    sysbench mysql cleanup database: sbt
    sysbench oltp_write_only.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
    sysbench 1.0.14 (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'...
    
    setup sbt database & user
    mysqladmin create database: sbt
    
    MySQL Buffers
    aria_pagecache_buffer_size           67108864
    aria_sort_buffer_size                33554432
    bulk_insert_buffer_size              8388608
    innodb_buffer_pool_dump_at_shutdown  OFF
    innodb_buffer_pool_dump_now          OFF
    innodb_buffer_pool_dump_pct          100
    innodb_buffer_pool_filename          ib_buffer_pool
    innodb_buffer_pool_instances         1
    innodb_buffer_pool_load_abort        OFF
    innodb_buffer_pool_load_at_startup   OFF
    innodb_buffer_pool_load_now          OFF
    innodb_buffer_pool_populate          OFF
    innodb_buffer_pool_size              50331648
    innodb_change_buffer_max_size        25
    innodb_change_buffering              all
    innodb_log_buffer_size               8388608
    innodb_sort_buffer_size              2097152
    join_buffer_size                     65536
    join_buffer_space_limit              2097152
    key_buffer_size                      33554432
    mrr_buffer_size                      262144
    myisam_sort_buffer_size              33554432
    net_buffer_length                    16384
    optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
    preload_buffer_size                  32768
    read_buffer_size                     65536
    read_rnd_buffer_size                 262144
    sort_buffer_size                     131072
    sql_buffer_result                    OFF
    
    MySQL Limits
    aria_pagecache_division_limit         100
    delayed_insert_limit                  100
    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                      524288
    optimizer_selectivity_sampling_limit  100
    query_cache_limit                     524288
    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              1024
    innodb_adaptive_max_sleep_delay   150000
    innodb_compression_pad_pct_max    50
    innodb_file_format_max            Antelope
    innodb_ft_max_token_size          84
    innodb_io_capacity_max            4200
    innodb_max_bitmap_file_size       104857600
    innodb_max_changed_pages          1000000
    innodb_max_dirty_pages_pct        75.000000
    innodb_max_dirty_pages_pct_lwm    0.001000
    innodb_max_purge_lag              0
    innodb_max_purge_lag_delay        0
    innodb_online_alter_log_max_size  134217728
    max_allowed_packet                33554432
    max_binlog_cache_size             18446744073709547520
    max_binlog_size                   1073741824
    max_binlog_stmt_cache_size        18446744073709547520
    max_connect_errors                100000
    max_connections                   300
    max_delayed_threads               20
    max_digest_length                 1024
    max_error_count                   64
    max_heap_table_size               33554432
    max_insert_delayed_threads        20
    max_join_size                     18446744073709551615
    max_length_for_sort_data          1024
    max_long_data_size                33554432
    max_prepared_stmt_count           16382
    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           1000
    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   0
    thread_concurrency          10
    
    
    sysbench prepare database: sbt
    sysbench oltp_point_select.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Creating table 'sbtest1'...
    Inserting 150000 records into 'sbtest1'
    Creating a secondary index on 'sbtest1'...
    Creating table 'sbtest2'...
    Inserting 150000 records into 'sbtest2'
    Creating a secondary index on 'sbtest2'...
    Creating table 'sbtest3'...
    Inserting 150000 records into 'sbtest3'
    Creating a secondary index on 'sbtest3'...
    Creating table 'sbtest4'...
    Inserting 150000 records into 'sbtest4'
    Creating a secondary index on 'sbtest4'...
    Creating table 'sbtest5'...
    Inserting 150000 records into 'sbtest5'
    Creating a secondary index on 'sbtest5'...
    Creating table 'sbtest6'...
    Inserting 150000 records into 'sbtest6'
    Creating a secondary index on 'sbtest6'...
    Creating table 'sbtest7'...
    Inserting 150000 records into 'sbtest7'
    Creating a secondary index on 'sbtest7'...
    Creating table 'sbtest8'...
    Inserting 150000 records into 'sbtest8'
    Creating a secondary index on 'sbtest8'...
    
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    | sbt.sbtest1 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Compact    | utf8_general_ci |
    | sbt.sbtest6 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    | sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 0.00MB     | 0.02MB  | Compact    | utf8_general_ci |
    +-------------+----------------+----------------+-----------+------------+---------+------------+-----------------+
    
    sysbench mysql OLTP POINT SELECT new benchmark:
    sysbench oltp_point_select.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    
    Running the test with following options:
    Number of threads: 1
    Report intermediate results every 1 second(s)
    Initializing random number generator from seed (1).
    
    
    Initializing worker threads...
    
    Threads started!
    
    [ 1s ] thds: 1 tps: 4268.82 qps: 4268.82 (r/w/o: 4268.82/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 2s ] thds: 1 tps: 4431.16 qps: 4431.16 (r/w/o: 4431.16/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 3s ] thds: 1 tps: 4108.23 qps: 4108.23 (r/w/o: 4108.23/0.00/0.00) lat (ms,95%): 0.35 err/s: 0.00 reconn/s: 0.00
    [ 4s ] thds: 1 tps: 4339.96 qps: 4339.96 (r/w/o: 4339.96/0.00/0.00) lat (ms,95%): 0.31 err/s: 0.00 reconn/s: 0.00
    [ 5s ] thds: 1 tps: 4493.88 qps: 4493.88 (r/w/o: 4493.88/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 6s ] thds: 1 tps: 4464.84 qps: 4464.84 (r/w/o: 4464.84/0.00/0.00) lat (ms,95%): 0.31 err/s: 0.00 reconn/s: 0.00
    [ 7s ] thds: 1 tps: 4592.20 qps: 4592.20 (r/w/o: 4592.20/0.00/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 8s ] thds: 1 tps: 4621.97 qps: 4621.97 (r/w/o: 4621.97/0.00/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 9s ] thds: 1 tps: 4520.01 qps: 4520.01 (r/w/o: 4520.01/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 10s ] thds: 1 tps: 4434.10 qps: 4434.10 (r/w/o: 4434.10/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 11s ] thds: 1 tps: 4345.04 qps: 4345.04 (r/w/o: 4345.04/0.00/0.00) lat (ms,95%): 0.31 err/s: 0.00 reconn/s: 0.00
    [ 12s ] thds: 1 tps: 4423.72 qps: 4423.72 (r/w/o: 4423.72/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 13s ] thds: 1 tps: 4469.91 qps: 4469.91 (r/w/o: 4469.91/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 14s ] thds: 1 tps: 4447.42 qps: 4447.42 (r/w/o: 4447.42/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 15s ] thds: 1 tps: 4545.09 qps: 4545.09 (r/w/o: 4545.09/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 16s ] thds: 1 tps: 4370.88 qps: 4370.88 (r/w/o: 4370.88/0.00/0.00) lat (ms,95%): 0.31 err/s: 0.00 reconn/s: 0.00
    [ 17s ] thds: 1 tps: 4392.67 qps: 4392.67 (r/w/o: 4392.67/0.00/0.00) lat (ms,95%): 0.28 err/s: 0.00 reconn/s: 0.00
    [ 18s ] thds: 1 tps: 4209.11 qps: 4209.11 (r/w/o: 4209.11/0.00/0.00) lat (ms,95%): 0.32 err/s: 0.00 reconn/s: 0.00
    [ 19s ] thds: 1 tps: 4224.74 qps: 4224.74 (r/w/o: 4224.74/0.00/0.00) lat (ms,95%): 0.33 err/s: 0.00 reconn/s: 0.00
    [ 20s ] thds: 1 tps: 4412.42 qps: 4412.42 (r/w/o: 4412.42/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    [ 21s ] thds: 1 tps: 4373.97 qps: 4373.97 (r/w/o: 4373.97/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
    [ 22s ] thds: 1 tps: 4624.92 qps: 4624.92 (r/w/o: 4624.92/0.00/0.00) lat (ms,95%): 0.27 err/s: 0.00 reconn/s: 0.00
    [ 23s ] thds: 1 tps: 4243.15 qps: 4243.15 (r/w/o: 4243.15/0.00/0.00) lat (ms,95%): 0.32 err/s: 0.00 reconn/s: 0.00
    [ 24s ] thds: 1 tps: 3719.82 qps: 3719.82 (r/w/o: 3719.82/0.00/0.00) lat (ms,95%): 0.35 err/s: 0.00 reconn/s: 0.00
    [ 25s ] thds: 1 tps: 3431.29 qps: 3431.29 (r/w/o: 3431.29/0.00/0.00) lat (ms,95%): 0.34 err/s: 0.00 reconn/s: 0.00
    [ 26s ] thds: 1 tps: 3504.83 qps: 3504.83 (r/w/o: 3504.83/0.00/0.00) lat (ms,95%): 0.32 err/s: 0.00 reconn/s: 0.00
    [ 27s ] thds: 1 tps: 3470.98 qps: 3470.98 (r/w/o: 3470.98/0.00/0.00) lat (ms,95%): 0.34 err/s: 0.00 reconn/s: 0.00
    [ 28s ] thds: 1 tps: 3434.89 qps: 3434.89 (r/w/o: 3434.89/0.00/0.00) lat (ms,95%): 0.35 err/s: 0.00 reconn/s: 0.00
    [ 29s ] thds: 1 tps: 3969.86 qps: 3969.86 (r/w/o: 3969.86/0.00/0.00) lat (ms,95%): 0.32 err/s: 0.00 reconn/s: 0.00
    [ 30s ] thds: 1 tps: 4526.67 qps: 4526.67 (r/w/o: 4526.67/0.00/0.00) lat (ms,95%): 0.29 err/s: 0.00 reconn/s: 0.00
    SQL statistics:
        queries performed:
            read:                            127425
            write:                           0
            other:                           0
            total:                           127425
        transactions:                        127425 (4246.96 per sec.)
        queries:                             127425 (4246.96 per sec.)
        ignored errors:                      0      (0.00 per sec.)
        reconnects:                          0      (0.00 per sec.)
    
    General statistics:
        total time:                          30.0023s
        total number of events:              127425
    
    Latency (ms):
             min:                                    0.02
             avg:                                    0.23
             max:                                   78.32
             95th percentile:                        0.31
             sum:                                29880.53
    
    Threads fairness:
        events (avg/stddev):           127425.0000/0.00
        execution time (avg/stddev):   29.8805/0.00
    
    
    sysbench mysql OLTP POINT SELECT new summary:
    sysbench oltp_point_select.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=1 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    read: 127425
    write: 0
    other: 0
    total: 127425
    transactions/s: 4246.96
    queries/s: 4246.96
    time: 30.0023s
    min: 0.02
    avg: 0.23
    max: 78.32
    95th: 0.31
    
    | mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | oltp_point_select.lua | 1.0.14 | 1 | 127425 | 0 | 0 | 127425 | 4246.96 | 4246.96 | 30.0023s | 0.02 | 0.23 | 78.32 | 0.31 |
    
    sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
    oltp_point_select.lua,1.0.14,1,127425,0,0,127425,4246.96,4246.96,30.0023s,0.02,0.23,78.32,0.31
    
     
  10. JJC84

    JJC84 Active Member

    202
    83
    28
    Jan 31, 2018
    Ratings:
    +128
    Local Time:
    2:11 PM
    1.15.x
    10.1.x
    Just noticed I'm using an older kernel than the previous. I will update with new stats shortly with the updated kernel.
     
  11. Daniel J. Lewis

    Daniel J. Lewis Award-winning podcaster and consultant

    101
    14
    18
    Oct 20, 2014
    Ratings:
    +24
    Local Time:
    3:11 PM
    1.8.0
    5.6
    Seeing the deal on ssdnodes, I decided to run my own performance checks on a new UpCloud 8 GB / 4 CPU VPS in Chicago. (I just finished moving my main sites off Vultr.)

    These tests were actually run _before_ installing Centminmod, so maybe they're not as accurate.

    Code:
    -------------------------------------------
    System Information
    -------------------------------------------
    
    3.10.0-862.3.2.el7.x86_64
    
    CentOS Linux release 7.5.1804 (Core)
    
    Architecture:          x86_64
    CPU op-mode(s):        32-bit, 64-bit
    Byte Order:            Little Endian
    CPU(s):                4
    On-line CPU(s) list:   0-3
    Thread(s) per core:    1
    Core(s) per socket:    4
    Socket(s):             1
    NUMA node(s):          1
    Vendor ID:             GenuineIntel
    CPU family:            6
    Model:                 79
    Model name:            Intel(R) Xeon(R) CPU E5-2687W v4 @ 3.00GHz
    Stepping:              1
    CPU MHz:               2999.994
    BogoMIPS:              5999.98
    Hypervisor vendor:     KVM
    Virtualization type:   full
    L1d cache:             32K
    L1i cache:             32K
    L2 cache:              4096K
    L3 cache:              16384K
    NUMA node0 CPU(s):     0-3
    Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht 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 fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU Flags
     fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht 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 fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat
    
    CPU NODE SOCKET CORE L1d:L1i:L2:L3 ONLINE
    0   0    0      0    0:0:0:0       yes
    1   0    0      1    1:1:1:0       yes
    2   0    0      2    2:2:2:0       yes
    3   0    0      3    3:3:3:0       yes
    
                  total        used        free      shared  buff/cache   available
    Mem:           7821         145        7359           8         317        7419
    Low:           7821         462        7359
    High:             0           0           0
    Swap:             0           0           0
    
    Filesystem      Size  Used Avail Use% Mounted on
    /dev/vda1       160G  1.1G  159G   1% /
    devtmpfs        3.9G     0  3.9G   0% /dev
    tmpfs           3.9G     0  3.9G   0% /dev/shm
    tmpfs           3.9G  8.5M  3.9G   1% /run
    tmpfs           3.9G     0  3.9G   0% /sys/fs/cgroup
    tmpfs           783M     0  783M   0% /run/user/0
    
    ./sysbench cpu

    Code:
    sysbench cpu --cpu-max-prime=20000 --threads=1 run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    prime: 20000
    events/s: 414.16
    time: 10.0015s
    min: 2.38
    avg: 2.41
    max: 2.90
    95th: 2.48
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.14 | 1 | 414.16 | 10.0015s | 2.38 | 2.41 | 2.90 | 2.48 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.14,1,414.16,10.0015s,2.38,2.41,2.90,2.48
    
    sysbench cpu --cpu-max-prime=20000 --threads=4 run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    prime: 20000
    events/s: 1647.30
    time: 10.0019s
    min: 2.38
    avg: 2.43
    max: 7.56
    95th: 2.52
    
    | cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- |
    | 1.0.14 | 4 | 1647.30 | 10.0019s | 2.38 | 2.43 | 7.56 | 2.52 |
    
    sysbench,threads,events/s,time,min,avg,max,95th
    1.0.14,4,1647.30,10.0019s,2.38,2.43,7.56,2.52
    
    ./sysbench.sh mem

    Code:
    sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 1
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (4847275.03 per second)
    transferred (4733.67 MiB/sec)
    time: 0.2146s
    min: 0.00
    avg: 0.00
    max: 0.15
    95th: 0.00
    
    | memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
    | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
    | memory | 1.0.14 | 1 | 1KiB | 1024MiB | read | 1048576 | 4733.67 | 0.2146s | 0.00 | 0.00 | 0.15 | 0.00 |
    
    sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
    memory,1.0.14,1,1KiB,1024MiB,read,1048576,4733.67,0.2146s,0.00,0.00,0.15,0.00
    
    sysbench memory --threads=4 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
    sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2)
    threads: 4
    block-size: 1KiB
    total-size: 1024MiB
    operation: read
    scope: global
    total-ops: 1048576 (15311773.67 per second)
    transferred (14952.90 MiB/sec)
    time: 0.0668s
    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.14 | 4 | 1KiB | 1024MiB | read | 1048576 | 14952.90 | 0.0668s | 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.14,4,1KiB,1024MiB,read,1048576,14952.90,0.0668s,0.00,0.00,0.05,0.00
    
     
    Last edited: Jun 3, 2018
    • Informative Informative x 1
  12. eva2000

    eva2000 Administrator Staff Member

    38,511
    8,487
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,050
    Local Time:
    5:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    might try after Centmin Mod install too :)
     
  13. Daniel J. Lewis

    Daniel J. Lewis Award-winning podcaster and consultant

    101
    14
    18
    Oct 20, 2014
    Ratings:
    +24
    Local Time:
    3:11 PM
    1.8.0
    5.6
    After installing centminmod via the install and benchmark, here are my results:

    single thread: events/s: 279.25
    4-thread: events/s: 1117.71

    Eew. Suddenly not so impressive. But almost identical results to what I get with a Vultr 4 CPU / 8 GB server (at 2.4 GHZ).
     
  14. eva2000

    eva2000 Administrator Staff Member

    38,511
    8,487
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,050
    Local Time:
    5:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    There will be variance between benchmark runs as you're using VPS so resources are still shared with neighbours. You can run sysbench.sh a few times to see if there's more variance. Also Vultr has different cpus masked under their hidden /proc/cpuinfo info so if you spun up a different Vultr VPS instead of reinstall the CentOS 7 OS, then you may possible have gotten a different underlying cpu model too.. Whoops mixed up you're using Upcloud not Vultr.

    You can post the beginning system info line from sysbench.sh cpu runs for both runs of sysbench.sh to compare cpu reported flag/instructions to see if it was indeed same type of cpu model or different.
     
  15. Daniel J. Lewis

    Daniel J. Lewis Award-winning podcaster and consultant

    101
    14
    18
    Oct 20, 2014
    Ratings:
    +24
    Local Time:
    3:11 PM
    1.8.0
    5.6
    Yes, I'm pretty sure I tested it several times and got similar results within that range.

    But on my live server (with multiple WP websites), I get the following:

    1 thread: events/s: ~310
    4 threads: events/s: ~1050
     
    Last edited: Jun 4, 2018
  16. eva2000

    eva2000 Administrator Staff Member

    38,511
    8,487
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +13,050
    Local Time:
    5:11 AM
    Nginx 1.15.x
    MariaDB 5.5/10.x
    Yes on live servers results will be impacted by existing sites' usage of resources too. Guess you can use sysbench.sh and https_bench.sh HTTP/2 HTTPS benchmarks to track your server's performance over time with regular runs too :)
     
..