Benchmarks Upcloud Upcloud Benchmark

JJC84 · May 6, 2018

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

Colin · May 6, 2018

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

eva2000 · May 6, 2018

thanks for sharing.. @JJC84 seems you posted the same results twice though (there's 2 sets of them)

JJC84 · May 30, 2018

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.

JJC84 · May 30, 2018

Colin said: ↑

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
Click to expand...

Hello Colin. I just saw this reply, and I will get back to you soon.

eva2000 · May 30, 2018

JJC84 said: ↑

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.
Click to expand...

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

JJC84 · May 31, 2018

eva2000 said: ↑

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
Click to expand...

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!

JJC84 · May 31, 2018

Colin said: ↑

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
Click to expand...

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'

JJC84 · May 31, 2018

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 sbtest@localhost
GRANT USAGE ON *.* TO 'sbtest'@'localhost' IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E'
GRANT ALL PRIVILEGES ON `sbt`.* TO 'sbtest'@'localhost'

MySQL Buffers
aria_pagecache_buffer_size           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

JJC84 · May 31, 2018

Just noticed I'm using an older kernel than the previous. I will update with new stats shortly with the updated kernel.

Daniel J. Lewis · Jun 3, 2018

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

eva2000 · Jun 3, 2018

Daniel J. Lewis said: ↑

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

might try after Centmin Mod install too

Daniel J. Lewis · Jun 4, 2018

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).

eva2000 · Jun 4, 2018

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.

Daniel J. Lewis · Jun 4, 2018

eva2000 said: ↑

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.
Click to expand...

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

eva2000 · Jun 4, 2018

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

Log in / Register

Forums

Learn about Centmin Mod LEMP Stack today

Benchmarks Upcloud Upcloud Benchmark

JJC84 Ad astra per aspera

Colin Premium Member Premium Member

eva2000 Administrator Staff Member

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

eva2000 Administrator Staff Member

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

.

Log in / Register

Useful Searches

Learn about Centmin Mod LEMP Stack today

Benchmarks Upcloud Upcloud Benchmark

JJC84 Ad astra per aspera

Colin Premium Member Premium Member

eva2000 Administrator Staff Member

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

eva2000 Administrator Staff Member

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

JJC84 Ad astra per aspera

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

Daniel J. Lewis Award-winning podcaster and consultant

eva2000 Administrator Staff Member

.