SSDNodes SSDNodes review from solovyov.net

Jimmy · Jun 27, 2020

Great review of ssdnodes.
solovyov.net: SSDNodes review

Then the actual task: I went to download GraalVM release from Github. And that’s what set me off! I downloaded the same release an evening before on Linode VPS (where it died OOM during compilation, haha) and while it’s 100+ MB it wasn’t a burden. On SSDNodes it was taking a while, started at ~300 KB/s, and then settled at ~3 MB/s. I went to check and sure enough Linode was doing 20 MB/s.

Wow. Where’s my promised 10 Gbps network? That looks worse than my home connection!

And then tar xf took an infinite amount of time. Like, all of the time in the world. So I googled how to check disk speed and came back with hdparm - haven’t touched that tool since the early ‘00s.
Click to expand...

It’s a 4 years old CPU. Should be okay I guess if it’s not overloaded, shame I didn’t test. Linode is on AMD EPYC though, another score in their basket.
Click to expand...

eva2000 · Jun 28, 2020

confused that review suggests Linode is better than ssdnodes does it not ? My last comment on ssdnodes is at Benchmarks - SSDNodes - ssdnodes.com upto 91% discount on KVM VPS until May 31, 2018

Jimmy · Jun 28, 2020

I'm moving my busy site off of ssdnodes as things have been slow and horrible lately (I'm in the NYC / Newark location). I don't think they 100% know how to manage their systems. Two times the server went crazy and they had to reboot because the CPU was off the chart. I had to submit a ticket before they noticed the server was going crazy which I shouldn't have had to do. I assume something happened to mess up their system. I had no traffic on my site and my CPU was off the chart.

I think SSDNodes would be great for a small site, they probably only want customers with small sites for what they're charging.

After research I believe I'm going to put my busy site on Vultr's $24 high performance plan. Linode is nice too, but they don't have a higher performance plan like Vultr.

Jimmy · Jun 29, 2020

Here are a few runs on my NVME ssdnodes machine in NY / NJ.

Code:

load average: 0.70, 1.04, 1.09

Code:

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   4438 MB in  2.00 seconds = 2222.25 MB/sec
 Timing buffered disk reads: 170 MB in  3.05 seconds =  55.73 MB/sec

Code:

hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   1956 MB in  2.00 seconds = 977.40 MB/sec
 Timing buffered disk reads: 214 MB in  3.01 seconds =  71.06 MB/sec

Code:

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   1646 MB in  2.06 seconds = 799.25 MB/sec
 Timing buffered disk reads: 290 MB in  3.01 seconds =  96.22 MB/sec

Code:

hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   6796 MB in  2.00 seconds = 3394.64 MB/sec
 Timing buffered disk reads: 370 MB in  3.00 seconds = 123.32 MB/sec

Code:

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   1934 MB in  2.00 seconds = 967.78 MB/sec
 Timing buffered disk reads:  98 MB in  3.05 seconds =  32.08 MB/sec

Code:

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   7352 MB in  2.00 seconds = 3684.04 MB/sec
 Timing buffered disk reads: 454 MB in  3.03 seconds = 150.00 MB/sec

Code:

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   2968 MB in  2.01 seconds = 1477.88 MB/sec
 Timing buffered disk reads: 302 MB in  3.05 seconds =  99.14 MB/sec

SITE STATUS OFFLINE

Code:

# sitestatus offline
Restarting nginx (via systemctl):                          [
 OK  ]

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   3614 MB in  2.00 seconds = 1808.96 MB/sec
 Timing buffered disk reads: 458 MB in  3.00 seconds = 152.48 MB/sec

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   6152 MB in  1.99 seconds = 3097.76 MB/sec
 Timing buffered disk reads: 496 MB in  3.00 seconds = 165.17 MB/sec

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   6454 MB in  2.00 seconds = 3232.32 MB/sec
 Timing buffered disk reads: 450 MB in  3.01 seconds = 149.28 MB/sec

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   6864 MB in  2.00 seconds = 3426.91 MB/sec
 Timing buffered disk reads: 536 MB in  3.05 seconds = 175.62 MB/sec

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   7226 MB in  2.00 seconds = 3619.80 MB/sec
 Timing buffered disk reads: 560 MB in  3.00 seconds = 186.56 MB/sec

# hdparm -Tt /dev/sda

/dev/sda:
 Timing cached reads:   6450 MB in  2.00 seconds = 3232.08 MB/sec
 Timing buffered disk reads: 570 MB in  3.01 seconds = 189.14 MB/sec

eva2000 · Jun 29, 2020

Yeah pretty much story I have seen start off fast but slowly gets slower and slower on ssdnodes - as they add more shared VPS neighbours to the VPS node I suspect.

If you still have access to ssdnodes, give my sysbench.sh benchmark a run too centminmod/centminmod-sysbench

install
Code (Text):
mkdir -p /root/tools/sysbench
cd /root/tools/sysbench
wget -O /root/tools/sysbench/sysbench.sh https://github.com/centminmod/centminmod-sysbench/raw/master/sysbench.sh
chmod +x sysbench.sh
./sysbench.sh install
basic cpu, mem and disk/file benchmarks
Code (Text):
./sysbench.sh cpu
./sysbench.sh mem
./sysbench.sh file
./sysbench.sh file-fsync
mysql
Code (Text):
./sysbench.sh mysqloltpnew

Jimmy · Jun 29, 2020

Code:

# ./sysbench.sh cpu
-------------------------------------------
System Information
-------------------------------------------

3.10.0-1127.13.1.el7.x86_64

CentOS Linux release 7.8.2003 (Core)

Centmin Mod
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                6
On-line CPU(s) list:   0-5
Thread(s) per core:    1
Core(s) per socket:    1
Socket(s):             6
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 79
Model name:            Intel(R) Xeon(R) CPU E5-2650 v4 @ 2.20GHz
Stepping:              1
CPU MHz:               2199.996
BogoMIPS:              4399.99
Hypervisor vendor:     KVM
Virtualization type:   full
L1d cache:             32K
L1i cache:             32K
L2 cache:              4096K
NUMA node0 CPU(s):     0-5
Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat spec_ctrl intel_stibp

CPU Flags
 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat spec_ctrl intel_stibp

CPU NODE SOCKET CORE L1d:L1i:L2 ONLINE
0   0    0      0    0:0:0      yes
1   0    1      1    1:1:1      yes
2   0    2      2    2:2:2      yes
3   0    3      3    3:3:3      yes
4   0    4      4    4:4:4      yes
5   0    5      5    5:5:5      yes

              total        used        free      shared  buff/cache   available
Mem:          23947        8096       13935          84        1915       15412
Low:          23947       10011       13935
High:             0           0           0
Swap:          1023         535         488

Filesystem      Size  Used Avail Use% Mounted on
devtmpfs         12G     0   12G   0% /dev
tmpfs            12G     0   12G   0% /dev/shm
tmpfs            12G   41M   12G   1% /run
tmpfs            12G     0   12G   0% /sys/fs/cgroup
/dev/sda1       240G   54G  187G  23% /
tmpfs           2.4G     0  2.4G   0% /run/user/0


sysbench cpu --cpu-max-prime=20000 --threads=1 run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
prime: 20000
events/s: 113.29
time: 10.0162s
min: 3.23
avg: 8.81
max: 78.31
95th: 56.84

| cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 1.0.20 | 1 | 113.29 | 10.0162s | 3.23 | 8.81 | 78.31 | 56.84 |

sysbench,threads,events/s,time,min,avg,max,95th
1.0.20,1,113.29,10.0162s,3.23,8.81,78.31,56.84

sysbench cpu --cpu-max-prime=20000 --threads=6 run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
prime: 20000
events/s: 163.81
time: 10.0696s
min: 3.29
avg: 36.41
max: 283.42
95th: 99.33

| cpu sysbench | threads: | events/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 1.0.20 | 6 | 163.81 | 10.0696s | 3.29 | 36.41 | 283.42 | 99.33 |

sysbench,threads,events/s,time,min,avg,max,95th
1.0.20,6,163.81,10.0696s,3.29,36.41,283.42,99.33

Code:

# ./sysbench.sh mem
-------------------------------------------
System Information
-------------------------------------------

3.10.0-1127.13.1.el7.x86_64

CentOS Linux release 7.8.2003 (Core)

Centmin Mod
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                6
On-line CPU(s) list:   0-5
Thread(s) per core:    1
Core(s) per socket:    1
Socket(s):             6
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 79
Model name:            Intel(R) Xeon(R) CPU E5-2650 v4 @ 2.20GHz
Stepping:              1
CPU MHz:               2199.996
BogoMIPS:              4399.99
Hypervisor vendor:     KVM
Virtualization type:   full
L1d cache:             32K
L1i cache:             32K
L2 cache:              4096K
NUMA node0 CPU(s):     0-5
Flags:                 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat spec_ctrl intel_stibp

CPU Flags
 fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good nopl xtopology eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch invpcid_single ssbd ibrs ibpb stibp fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 erms invpcid rtm rdseed adx smap xsaveopt arat spec_ctrl intel_stibp

CPU NODE SOCKET CORE L1d:L1i:L2 ONLINE
0   0    0      0    0:0:0      yes
1   0    1      1    1:1:1      yes
2   0    2      2    2:2:2      yes
3   0    3      3    3:3:3      yes
4   0    4      4    4:4:4      yes
5   0    5      5    5:5:5      yes

              total        used        free      shared  buff/cache   available
Mem:          23947        8159       13872          84        1915       15349
Low:          23947       10075       13872
High:             0           0           0
Swap:          1023         535         488

Filesystem      Size  Used Avail Use% Mounted on
devtmpfs         12G     0   12G   0% /dev
tmpfs            12G     0   12G   0% /dev/shm
tmpfs            12G   41M   12G   1% /run
tmpfs            12G     0   12G   0% /sys/fs/cgroup
/dev/sda1       240G   54G  187G  23% /
tmpfs           2.4G     0  2.4G   0% /run/user/0


sysbench memory --threads=1 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
block-size: 1KiB
total-size: 1024MiB
operation: read
scope: global
total-ops: 1048576 (549599.54 per second)
transferred (536.72 MiB/sec)
time: 1.9050s
min: 0.00
avg: 0.00
max: 81.63
95th: 0.00

| memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| memory | 1.0.20 | 1 | 1KiB | 1024MiB | read | 1048576 | 536.72 | 1.9050s | 0.00 | 0.00 | 81.63 | 0.00 |

sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
memory,1.0.20,1,1KiB,1024MiB,read,1048576,536.72,1.9050s,0.00,0.00,81.63,0.00

sysbench memory --threads=6 --memory-block-size=1K --memory-scope=global --memory-total-size=1G --memory-oper=read run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
block-size: 1KiB
total-size: 1024MiB
operation: read
scope: global
total-ops: 1048572 (1175133.46 per second)
transferred (1147.59 MiB/sec)
time: 0.8197s
min: 0.00
avg: 0.00
max: 184.51
95th: 0.00

| memory sysbench | sysbench | threads: | block-size: | total-size: | operation: | total-ops: | transferred | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| memory | 1.0.20 | 6 | 1KiB | 1024MiB | read | 1048572 | 1147.59 | 0.8197s | 0.00 | 0.00 | 184.51 | 0.00 |

sysbench,sysbench,threads,block-size,total-size,operation,total-ops,transferred,time,min,avg,max,95th
memory,1.0.20,6,1KiB,1024MiB,read,1048572,1147.59,0.8197s,0.00,0.00,184.51,0.00

Code:

# ./sysbench.sh file

sysbench fileio prepare
sysbench fileio --file-total-size=2048M --file-test-mode=seqrd prepare

sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqrd --time=10 --events=0 run
raw log saved: /home/sysbench/sysbench-fileio-seqrd-threads-1-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
Block-size 4KiB
Using synchronous I/O mode
Doing sequential read test
reads/s: 980.32
writes/s: 0.00
fsyncs/s: 0.00
read-MiB/s: 3.83
written-MiB/s: 0.00
time: 10.0003s
min: 0.07
avg: 1.02
max: 112.07
95th: 2.86

| fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 1 | 4KiB | I/O | read | 980.32 | 0.00 | 0.00 | 3.83 | 0.00 | 10.0003s | 0.07 | 1.02 | 112.07 | 2.86 |

sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,1,4KiB,I/O,read,980.32,0.00,0.00,3.83,0.00,10.0003s,0.07,1.02,112.07,2.86


sysbench fileio cleanup
sysbench fileio --file-total-size=2048M cleanup

sysbench fileio prepare
sysbench fileio --file-total-size=2048M --file-test-mode=seqwr prepare

sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=seqwr --time=10 --events=0 run
raw log saved: /home/sysbench/sysbench-fileio-seqwr-threads-1-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
Block-size 4KiB
Using synchronous I/O mode
Doing sequential write (creation) test
reads/s: 0.00
writes/s: 450.20
fsyncs/s: 588.41
read-MiB/s: 0.00
written-MiB/s: 1.76
time: 10.0016s
min: 0.00
avg: 0.97
max: 87.31
95th: 4.03

| fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 450.20 | 588.41 | 0.00 | 1.76 | 10.0016s | 0.00 | 0.97 | 87.31 | 4.03 |

sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,1,4KiB,I/O,write,0.00,450.20,588.41,0.00,1.76,10.0016s,0.00,0.97,87.31,4.03


sysbench fileio cleanup
sysbench fileio --file-total-size=2048M cleanup

sysbench fileio prepare
sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare

sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndrd --time=10 --events=0 run
raw log saved: /home/sysbench/sysbench-fileio-rndrd-threads-1-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
Block-size 4KiB
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
reads/s: 1058.52
writes/s: 0.00
fsyncs/s: 0.00
read-MiB/s: 4.13
written-MiB/s: 0.00
time: 10.0003s
min: 0.08
avg: 0.94
max: 92.77
95th: 3.30

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 1 | 4KiB | I/O | read | 1058.52 | 0.00 | 0.00 | 4.13 | 0.00 | 10.0003s | 0.08 | 0.94 | 92.77 | 3.30 |

sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,1,4KiB,I/O,read,1058.52,0.00,0.00,4.13,0.00,10.0003s,0.08,0.94,92.77,3.30


sysbench fileio cleanup
sysbench fileio --file-total-size=2048M cleanup

sysbench fileio prepare
sysbench fileio --file-total-size=2048M --file-test-mode=rndwr prepare

sysbench fileio --threads=1 --file-num=128 --file-total-size=2048M --file-block-size=4096 --file-io-mode=sync --file-extra-flags=direct --file-test-mode=rndwr --time=10 --events=0 run
raw log saved: /home/sysbench/sysbench-fileio-rndwr-threads-1-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
Block-size 4KiB
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random write test
reads/s: 0.00
writes/s: 670.00
fsyncs/s: 869.23
read-MiB/s: 0.00
written-MiB/s: 2.62
time: 10.0110s
min: 0.00
avg: 0.65
max: 81.69
95th: 1.89

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 670.00 | 869.23 | 0.00 | 2.62 | 10.0110s | 0.00 | 0.65 | 81.69 | 1.89 |

sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,1,4KiB,I/O,write,0.00,670.00,869.23,0.00,2.62,10.0110s,0.00,0.65,81.69,1.89



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=6 --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-6-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
Block-size 4KiB
Using synchronous I/O mode
Doing sequential read test
reads/s: 1088.61
writes/s: 0.00
fsyncs/s: 0.00
read-MiB/s: 4.25
written-MiB/s: 0.00
time: 10.0150s
min: 0.07
avg: 5.50
max: 399.35
95th: 41.85

| fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 6 | 4KiB | I/O | read | 1088.61 | 0.00 | 0.00 | 4.25 | 0.00 | 10.0150s | 0.07 | 5.50 | 399.35 | 41.85 |

sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,6,4KiB,I/O,read,1088.61,0.00,0.00,4.25,0.00,10.0150s,0.07,5.50,399.35,41.85


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=6 --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-6-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
Block-size 4KiB
Using synchronous I/O mode
Doing sequential write (creation) test
reads/s: 0.00
writes/s: 217.68
fsyncs/s: 353.97
read-MiB/s: 0.00
written-MiB/s: 0.85
time: 10.1227s
min: 0.00
avg: 12.04
max: 1087.45
95th: 73.13

| fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 6 | 4KiB | I/O | write | 0.00 | 217.68 | 353.97 | 0.00 | 0.85 | 10.1227s | 0.00 | 12.04 | 1087.45 | 73.13 |

sysbench,sysbench,threads,Block-size,synchronous,sequential,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,6,4KiB,I/O,write,0.00,217.68,353.97,0.00,0.85,10.1227s,0.00,12.04,1087.45,73.13


sysbench fileio cleanup
sysbench fileio --file-total-size=2048M cleanup

sysbench fileio prepare
sysbench fileio --file-total-size=2048M --file-test-mode=rndrd prepare

sysbench fileio --threads=6 --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-6-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
Block-size 4KiB
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random read test
reads/s: 1563.04
writes/s: 0.00
fsyncs/s: 0.00
read-MiB/s: 6.11
written-MiB/s: 0.00
time: 10.5551s
min: 0.08
avg: 3.73
max: 566.57
95th: 11.65

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 6 | 4KiB | I/O | read | 1563.04 | 0.00 | 0.00 | 6.11 | 0.00 | 10.5551s | 0.08 | 3.73 | 566.57 | 11.65 |

sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,6,4KiB,I/O,read,1563.04,0.00,0.00,6.11,0.00,10.5551s,0.08,3.73,566.57,11.65


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=6 --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-6-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
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: 1399.31
fsyncs/s: 1861.62
read-MiB/s: 0.00
written-MiB/s: 5.47
time: 10.0350s
min: 0.00
avg: 1.88
max: 471.17
95th: 6.79

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 6 | 4KiB | I/O | write | 0.00 | 1399.31 | 1861.62 | 0.00 | 5.47 | 10.0350s | 0.00 | 1.88 | 471.17 | 6.79 |

sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,95th
fileio,1.0.20,6,4KiB,I/O,write,0.00,1399.31,1861.62,0.00,5.47,10.0350s,0.00,1.88,471.17,6.79


sysbench fileio cleanup
sysbench fileio --file-total-size=2048M cleanup

| fileio sysbench | sysbench | threads: | Block-size | synchronous | sequential | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|fileio | 1.0.20 | 1 | 4KiB | I/O | read | 980.32 | 0.00 | 0.00 | 3.83 | 0.00 | 10.0003s | 0.07 | 1.02 | 112.07 | 2.86 |
|fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 450.20 | 588.41 | 0.00 | 1.76 | 10.0016s | 0.00 | 0.97 | 87.31 | 4.03 |
|fileio | 1.0.20 | 6 | 4KiB | I/O | read | 1088.61 | 0.00 | 0.00 | 4.25 | 0.00 | 10.0150s | 0.07 | 5.50 | 399.35 | 41.85 |
|fileio | 1.0.20 | 6 | 4KiB | I/O | write | 0.00 | 217.68 | 353.97 | 0.00 | 0.85 | 10.1227s | 0.00 | 12.04 | 1087.45 | 73.13 |

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
|fileio | 1.0.20 | 1 | 4KiB | I/O | read | 1058.52 | 0.00 | 0.00 | 4.13 | 0.00 | 10.0003s | 0.08 | 0.94 | 92.77 | 3.30 |
|fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 670.00 | 869.23 | 0.00 | 2.62 | 10.0110s | 0.00 | 0.65 | 81.69 | 1.89 |
|fileio | 1.0.20 | 6 | 4KiB | I/O | read | 1563.04 | 0.00 | 0.00 | 6.11 | 0.00 | 10.5551s | 0.08 | 3.73 | 566.57 | 11.65 |
|fileio | 1.0.20 | 6 | 4KiB | I/O | write | 0.00 | 1399.31 | 1861.62 | 0.00 | 5.47 | 10.0350s | 0.00 | 1.88 | 471.17 | 6.79 |

Code:

# ./sysbench.sh file-fsync

sysbench fileio fsync prepare
sysbench fileio --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --threads=1 --percentile=99 prepare

sysbench fileio --threads=1 --time=30 --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 --file-fsync-all=on --file-test-mode=rndwr --file-fsync-freq=0 --file-fsync-end=0 --percentile=99 run
raw log saved: /home/sysbench/sysbench-fileio-fsync-threads-1-raw.log

sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 1
Block-size 4KiB
Read/Write ratio for combined random IO test: 1.50
Using synchronous I/O mode
Doing random write test
reads/s: 0.00
writes/s: 249.45
fsyncs/s: 249.45
read-MiB/s: 0.00
written-MiB/s: 0.97
time: 30.0075s
min: 0.12
avg: 4.00
max: 291.40
99th: 63.32

| fileio sysbench | sysbench | threads: | Block-size | synchronous | random | reads/s: | writes/s: | fsyncs/s: | read-MiB/s: | written-MiB/s: | time: | min: | avg: | max: | 99th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| fileio | 1.0.20 | 1 | 4KiB | I/O | write | 0.00 | 249.45 | 249.45 | 0.00 | 0.97 | 30.0075s | 0.12 | 4.00 | 291.40 | 63.32 |

sysbench,sysbench,threads,Block-size,synchronous,random,reads/s,writes/s,fsyncs/s,read-MiB/s,written-MiB/s,time,min,avg,max,99th
fileio,1.0.20,1,4KiB,I/O,write,0.00,249.45,249.45,0.00,0.97,30.0075s,0.12,4.00,291.40,63.32


sysbench fileio cleanup
sysbench fileio --file-num=1 --file-extra-flags= --file-total-size=4096 --file-block-size=4096 cleanup

Code:

# ./sysbench.sh mysqloltpnew

setup sbt database & user
mysqladmin create database: sbt
Grants for sbtest@localhost
GRANT USAGE ON *.* TO `sbtest`@`localhost` IDENTIFIED BY PASSWORD '*E6A410EB4C0B2737A6FC7845D7727289E65F2C8E'
GRANT ALL PRIVILEGES ON `sbt`.* TO `sbtest`@`localhost`

MySQL Buffers
aria_pagecache_buffer_size           134217728
aria_sort_buffer_size                134217728
bulk_insert_buffer_size              16777216
innodb_buffer_pool_chunk_size        134217728
innodb_buffer_pool_dump_at_shutdown  ON
innodb_buffer_pool_dump_now          OFF
innodb_buffer_pool_dump_pct          25
innodb_buffer_pool_filename          ib_buffer_pool
innodb_buffer_pool_instances         4
innodb_buffer_pool_load_abort        OFF
innodb_buffer_pool_load_at_startup   ON
innodb_buffer_pool_load_now          OFF
innodb_buffer_pool_size              4294967296
innodb_change_buffer_max_size        25
innodb_change_buffering              all
innodb_log_buffer_size               50331648
innodb_sort_buffer_size              2097152
join_buffer_size                     4194304
join_buffer_space_limit              2097152
key_buffer_size                      134217728
mrr_buffer_size                      262144
myisam_sort_buffer_size              805306368
net_buffer_length                    16384
optimizer_switch                     index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
preload_buffer_size                  32768
read_buffer_size                     2097152
read_rnd_buffer_size                 1048576
sort_buffer_size                     4194304
sql_buffer_result                    OFF

MySQL Limits
aria_pagecache_division_limit         100
delayed_insert_limit                  100
eq_range_index_dive_limit             0
expensive_subquery_limit              100
ft_query_expansion_limit              20
innodb_ft_result_cache_limit          2000000000
join_buffer_space_limit               2097152
key_cache_division_limit              100
log_slow_rate_limit                   1
min_examined_row_limit                0
open_files_limit                      161037
optimizer_selectivity_sampling_limit  100
query_cache_limit                     1048576
read_binlog_speed_limit               0
relay_log_space_limit                 0
sql_select_limit                      18446744073709551615
thread_pool_stall_limit               500
updatable_views_with_limit            YES

MySQL Maxes
aria_max_sort_file_size           9223372036853727232
extra_max_connections             1
ft_max_word_len                   84
group_concat_max_len              1024
innodb_adaptive_max_sleep_delay   150000
innodb_compression_pad_pct_max    50
innodb_ft_max_token_size          84
innodb_io_capacity_max            2000
innodb_max_dirty_pages_pct        75.000000
innodb_max_dirty_pages_pct_lwm    0.000000
innodb_max_purge_lag              0
innodb_max_purge_lag_delay        0
innodb_max_undo_log_size          10485760
innodb_online_alter_log_max_size  134217728
max_allowed_packet                134217728
max_binlog_cache_size             18446744073709547520
max_binlog_size                   1073741824
max_binlog_stmt_cache_size        18446744073709547520
max_connect_errors                1000000
max_connections                   1000
max_delayed_threads               20
max_digest_length                 1024
max_error_count                   64
max_heap_table_size               763363328
max_insert_delayed_threads        20
max_join_size                     18446744073709551615
max_length_for_sort_data          1024
max_long_data_size                134217728
max_prepared_stmt_count           16382
max_recursive_iterations          4294967295
max_relay_log_size                1073741824
max_seeks_for_key                 4294967295
max_session_mem_used              9223372036854775807
max_sort_length                   1024
max_sp_recursion_depth            0
max_statement_time                0.000000
max_tmp_tables                    32
max_user_connections              750
max_write_lock_count              4294967295
myisam_max_sort_file_size         9223372036853727232
slave_max_allowed_packet          1073741824
slave_parallel_max_queued         131072
thread_pool_max_threads           65536
wsrep_max_ws_rows                 0
wsrep_max_ws_size                 2147483647

MySQL Concurrency
concurrent_insert           ALWAYS
innodb_commit_concurrency   0
innodb_concurrency_tickets  5000
innodb_thread_concurrency   0
thread_concurrency          10

MySQL Read/Write
delay_key_write                 ON
idle_write_transaction_timeout  0
innodb_disallow_writes          OFF
innodb_doublewrite              ON
innodb_log_write_ahead_size     8192
innodb_use_atomic_writes        ON
max_write_lock_count            4294967295
net_write_timeout               60
wsrep_causal_reads              OFF
wsrep_dirty_reads               OFF

MySQL Threads
aria_repair_threads                      1
binlog_optimize_thread_scheduling        ON
debug_no_thread_alarm                    OFF
innodb_encryption_threads                0
innodb_purge_threads                     1
innodb_read_io_threads                   4
innodb_thread_concurrency                0
innodb_thread_sleep_delay                10000
innodb_write_io_threads                  2
max_delayed_threads                      20
max_insert_delayed_threads               20
myisam_repair_threads                    1
performance_schema_max_thread_classes    50
performance_schema_max_thread_instances  -1
slave_domain_parallel_threads            0
slave_parallel_threads                   0
thread_cache_size                        180
thread_concurrency                       10
thread_handling                          one-thread-per-connection
thread_pool_idle_timeout                 60
thread_pool_max_threads                  65536
thread_pool_oversubscribe                3
thread_pool_prio_kickup_timer            1000
thread_pool_priority                     auto
thread_pool_size                         6
thread_pool_stall_limit                  500
thread_stack                             299008
wsrep_slave_threads                      1

MySQL Binlog
binlog_annotate_row_events               ON
binlog_cache_size                        32768
binlog_checksum                          CRC32
binlog_commit_wait_count                 0
binlog_commit_wait_usec                  100000
binlog_direct_non_transactional_updates  OFF
binlog_file_cache_size                   16384
binlog_format                            MIXED
binlog_optimize_thread_scheduling        ON
binlog_row_image                         FULL
binlog_stmt_cache_size                   32768
encrypt_binlog                           OFF
gtid_binlog_pos
gtid_binlog_state
innodb_locks_unsafe_for_binlog           OFF
log_bin                                  OFF
log_bin_basename
log_bin_compress                         OFF
log_bin_compress_min_len                 256
log_bin_index
log_bin_trust_function_creators          OFF
max_binlog_cache_size                    18446744073709547520
max_binlog_size                          1073741824
max_binlog_stmt_cache_size               18446744073709547520
read_binlog_speed_limit                  0
sql_log_bin                              ON
sync_binlog                              0
wsrep_forced_binlog_format               NONE

MySQL InnoDB
ignore_builtin_innodb                        OFF
innodb_adaptive_flushing                     ON
innodb_adaptive_flushing_lwm                 10.000000
innodb_adaptive_hash_index                   OFF
innodb_adaptive_hash_index_parts             8
innodb_adaptive_max_sleep_delay              150000
innodb_autoextend_increment                  64
innodb_autoinc_lock_mode                     2
innodb_background_scrub_data_check_interval  3600
innodb_background_scrub_data_compressed      OFF
innodb_background_scrub_data_interval        604800
innodb_background_scrub_data_uncompressed    OFF
innodb_buf_dump_status_frequency             0
innodb_buffer_pool_chunk_size                134217728
innodb_buffer_pool_dump_at_shutdown          ON
innodb_buffer_pool_dump_now                  OFF
innodb_buffer_pool_dump_pct                  25
innodb_buffer_pool_filename                  ib_buffer_pool
innodb_buffer_pool_instances                 4
innodb_buffer_pool_load_abort                OFF
innodb_buffer_pool_load_at_startup           ON
innodb_buffer_pool_load_now                  OFF
innodb_buffer_pool_size                      4294967296
innodb_change_buffer_max_size                25
innodb_change_buffering                      all
innodb_checksum_algorithm                    crc32
innodb_checksums                             ON
innodb_cmp_per_index_enabled                 OFF
innodb_commit_concurrency                    0
innodb_compression_algorithm                 zlib
innodb_compression_default                   OFF
innodb_compression_failure_threshold_pct     5
innodb_compression_level                     6
innodb_compression_pad_pct_max               50
innodb_concurrency_tickets                   5000
innodb_data_file_path                        ibdata1:10M:autoextend
innodb_data_home_dir
innodb_deadlock_detect                       ON
innodb_default_encryption_key_id             1
innodb_default_row_format                    dynamic
innodb_defragment                            ON
innodb_defragment_fill_factor                0.900000
innodb_defragment_fill_factor_n_recs         20
innodb_defragment_frequency                  40
innodb_defragment_n_pages                    7
innodb_defragment_stats_accuracy             0
innodb_disable_sort_file_cache               OFF
innodb_disallow_writes                       OFF
innodb_doublewrite                           ON
innodb_encrypt_log                           OFF
innodb_encrypt_tables                        OFF
innodb_encrypt_temporary_tables              OFF
innodb_encryption_rotate_key_age             1
innodb_encryption_rotation_iops              100
innodb_encryption_threads                    0
innodb_fast_shutdown                         1
innodb_fatal_semaphore_wait_threshold        600
innodb_file_format
innodb_file_per_table                        ON
innodb_fill_factor                           100
innodb_flush_log_at_timeout                  1
innodb_flush_log_at_trx_commit               2
innodb_flush_method                          O_DIRECT
innodb_flush_neighbors                       1
innodb_flush_sync                            ON
innodb_flushing_avg_loops                    30
innodb_force_load_corrupted                  OFF
innodb_force_primary_key                     OFF
innodb_force_recovery                        0
innodb_ft_aux_table
innodb_ft_cache_size                         8000000
innodb_ft_enable_diag_print                  OFF
innodb_ft_enable_stopword                    ON
innodb_ft_max_token_size                     84
innodb_ft_min_token_size                     3
innodb_ft_num_word_optimize                  2000
innodb_ft_result_cache_limit                 2000000000
innodb_ft_server_stopword_table
innodb_ft_sort_pll_degree                    2
innodb_ft_total_cache_size                   640000000
innodb_ft_user_stopword_table
innodb_idle_flush_pct                        100
innodb_immediate_scrub_data_uncompressed     OFF
innodb_instant_alter_column_allowed          add_last
innodb_io_capacity                           1000
innodb_io_capacity_max                       2000
innodb_large_prefix                          1
innodb_lock_schedule_algorithm               fcfs
innodb_lock_wait_timeout                     50
innodb_locks_unsafe_for_binlog               OFF
innodb_log_buffer_size                       50331648
innodb_log_checksums                         ON
innodb_log_compressed_pages                  ON
innodb_log_file_size                         213909504
innodb_log_files_in_group                    5
innodb_log_group_home_dir                    ./
innodb_log_optimize_ddl                      ON
innodb_log_write_ahead_size                  8192
innodb_lru_scan_depth                        2048
innodb_max_dirty_pages_pct                   75.000000
innodb_max_dirty_pages_pct_lwm               0.000000
innodb_max_purge_lag                         0
innodb_max_purge_lag_delay                   0
innodb_max_undo_log_size                     10485760
innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct                        37
innodb_old_blocks_time                       1000
innodb_online_alter_log_max_size             134217728
innodb_open_files                            10000
innodb_optimize_fulltext_only                OFF
innodb_page_cleaners                         4
innodb_page_size                             16384
innodb_prefix_index_cluster_optimization     OFF
innodb_print_all_deadlocks                   OFF
innodb_purge_batch_size                      300
innodb_purge_rseg_truncate_frequency         128
innodb_purge_threads                         1
innodb_random_read_ahead                     OFF
innodb_read_ahead_threshold                  56
innodb_read_io_threads                       4
innodb_read_only                             OFF
innodb_replication_delay                     0
innodb_rollback_on_timeout                   OFF
innodb_rollback_segments                     128
innodb_scrub_log                             OFF
innodb_scrub_log_speed                       256
innodb_sort_buffer_size                      2097152
innodb_spin_wait_delay                       4
innodb_stats_auto_recalc                     ON
innodb_stats_include_delete_marked           OFF
innodb_stats_method                          nulls_equal
innodb_stats_modified_counter                0
innodb_stats_on_metadata                     OFF
innodb_stats_persistent                      ON
innodb_stats_persistent_sample_pages         20
innodb_stats_sample_pages                    8
innodb_stats_traditional                     ON
innodb_stats_transient_sample_pages          8
innodb_status_output                         OFF
innodb_status_output_locks                   OFF
innodb_strict_mode                           ON
innodb_sync_array_size                       1
innodb_sync_spin_loops                       30
innodb_table_locks                           ON
innodb_temp_data_file_path                   ibtmp1:12M:autoextend
innodb_thread_concurrency                    0
innodb_thread_sleep_delay                    10000
innodb_tmpdir
innodb_undo_directory                        ./
innodb_undo_log_truncate                     OFF
innodb_undo_logs                             128
innodb_undo_tablespaces                      0
innodb_use_atomic_writes                     ON
innodb_use_native_aio                        ON
innodb_version                               10.3.23
innodb_write_io_threads                      2
log_slow_verbosity                           innodb,query_plan,explain


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=6 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql prepare
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Initializing worker threads...

Creating table 'sbtest4'...
Creating table 'sbtest5'...
Creating table 'sbtest3'...
Creating table 'sbtest6'...
Creating table 'sbtest2'...
Creating table 'sbtest1'...
Inserting 150000 records into 'sbtest1'
Inserting 150000 records into 'sbtest4'
Inserting 150000 records into 'sbtest6'
Inserting 150000 records into 'sbtest3'
Inserting 150000 records into 'sbtest5'
Inserting 150000 records into 'sbtest2'
Creating a secondary index on 'sbtest4'...
Creating a secondary index on 'sbtest1'...
Creating a secondary index on 'sbtest5'...
Creating a secondary index on 'sbtest2'...
Creating a secondary index on 'sbtest3'...
Creating a secondary index on 'sbtest6'...
Creating table 'sbtest7'...
Inserting 150000 records into 'sbtest7'
Creating table 'sbtest8'...
Inserting 150000 records into 'sbtest8'
Creating a secondary index on 'sbtest7'...
Creating a secondary index on 'sbtest8'...

+-------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
| Table Name  | Number of Rows | Storage Engine | Data Size | Index Size | Total   | ROW_FORMAT | TABLE_COLLATION    |
+-------------+----------------+----------------+-----------+------------+---------+------------+--------------------+
| sbt.sbtest4 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest5 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest3 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest6 | 148261 Rows    | InnoDB         | 28.56MB   | 2.52MB     | 31.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest1 | 148181 Rows    | InnoDB         | 29.56MB   | 2.52MB     | 32.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest2 | 148032 Rows    | InnoDB         | 32.56MB   | 2.52MB     | 35.08MB | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest7 | 150000 Rows    | InnoDB         | 0.02MB    | 2.52MB     | 2.53MB  | Dynamic    | utf8mb4_unicode_ci |
| sbt.sbtest8 | 150000 Rows    | InnoDB         | 0.02MB    | 2.52MB     | 2.53MB  | Dynamic    | utf8mb4_unicode_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=6 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 6
Report intermediate results every 1 second(s)
Initializing random number generator from seed (1).


Initializing worker threads...

Threads started!

[ 1s ] thds: 6 tps: 39.31 qps: 863.87 (r/w/o: 618.17/161.18/84.52) lat (ms,95%): 363.18 err/s: 0.00 reconn/s: 0.00
[ 2s ] thds: 6 tps: 28.33 qps: 571.26 (r/w/o: 402.17/112.42/56.67) lat (ms,95%): 390.30 err/s: 0.00 reconn/s: 0.00
[ 3s ] thds: 6 tps: 16.45 qps: 321.40 (r/w/o: 225.97/62.53/32.91) lat (ms,95%): 719.92 err/s: 0.00 reconn/s: 0.00
[ 4s ] thds: 6 tps: 17.87 qps: 353.39 (r/w/o: 246.18/71.47/35.74) lat (ms,95%): 719.92 err/s: 0.00 reconn/s: 0.00
[ 5s ] thds: 6 tps: 20.68 qps: 420.46 (r/w/o: 293.44/85.67/41.36) lat (ms,95%): 458.96 err/s: 0.00 reconn/s: 0.00
[ 6s ] thds: 6 tps: 14.94 qps: 295.73 (r/w/o: 207.11/58.75/29.87) lat (ms,95%): 475.79 err/s: 0.00 reconn/s: 0.00
[ 7s ] thds: 6 tps: 5.23 qps: 119.49 (r/w/o: 81.11/27.91/10.47) lat (ms,95%): 1648.20 err/s: 0.00 reconn/s: 0.00
[ 8s ] thds: 6 tps: 20.59 qps: 402.07 (r/w/o: 280.96/79.93/41.18) lat (ms,95%): 943.16 err/s: 0.00 reconn/s: 0.00
[ 9s ] thds: 6 tps: 16.81 qps: 361.96 (r/w/o: 247.24/81.09/33.62) lat (ms,95%): 493.24 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 6 tps: 13.14 qps: 225.38 (r/w/o: 168.78/30.32/26.28) lat (ms,95%): 1327.91 err/s: 0.00 reconn/s: 0.00
[ 12s ] thds: 6 tps: 15.68 qps: 319.97 (r/w/o: 223.62/64.98/31.37) lat (ms,95%): 601.29 err/s: 0.00 reconn/s: 0.00
[ 13s ] thds: 6 tps: 57.81 qps: 1133.54 (r/w/o: 791.72/226.21/115.62) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
[ 14s ] thds: 6 tps: 13.98 qps: 300.15 (r/w/o: 207.86/64.32/27.96) lat (ms,95%): 816.63 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 6 tps: 20.00 qps: 403.34 (r/w/o: 287.78/75.56/40.00) lat (ms,95%): 943.16 err/s: 0.00 reconn/s: 0.00
[ 16s ] thds: 6 tps: 19.05 qps: 353.88 (r/w/o: 243.61/72.18/38.09) lat (ms,95%): 960.30 err/s: 0.00 reconn/s: 0.00
[ 17s ] thds: 6 tps: 26.02 qps: 525.08 (r/w/o: 367.09/105.94/52.04) lat (ms,95%): 404.61 err/s: 0.00 reconn/s: 0.00
[ 18s ] thds: 6 tps: 29.13 qps: 592.36 (r/w/o: 421.88/112.21/58.27) lat (ms,95%): 861.95 err/s: 0.00 reconn/s: 0.00
[ 19s ] thds: 6 tps: 25.80 qps: 522.04 (r/w/o: 364.24/106.19/51.61) lat (ms,95%): 646.19 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 6 tps: 47.71 qps: 940.93 (r/w/o: 655.71/189.81/95.41) lat (ms,95%): 434.83 err/s: 0.00 reconn/s: 0.00
[ 21s ] thds: 6 tps: 46.92 qps: 950.10 (r/w/o: 668.59/187.67/93.84) lat (ms,95%): 331.91 err/s: 0.00 reconn/s: 0.00
[ 22s ] thds: 6 tps: 47.07 qps: 940.44 (r/w/o: 652.89/193.41/94.15) lat (ms,95%): 303.33 err/s: 0.00 reconn/s: 0.00
[ 23s ] thds: 6 tps: 41.97 qps: 844.49 (r/w/o: 590.65/169.90/83.95) lat (ms,95%): 331.91 err/s: 0.00 reconn/s: 0.00
[ 24s ] thds: 6 tps: 39.74 qps: 786.00 (r/w/o: 553.40/153.13/79.47) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
[ 25s ] thds: 6 tps: 41.26 qps: 827.22 (r/w/o: 573.49/170.19/83.55) lat (ms,95%): 493.24 err/s: 0.00 reconn/s: 0.00
[ 26s ] thds: 6 tps: 45.99 qps: 926.86 (r/w/o: 655.90/179.97/90.99) lat (ms,95%): 369.77 err/s: 0.00 reconn/s: 0.00
[ 27s ] thds: 6 tps: 38.06 qps: 725.17 (r/w/o: 496.80/152.24/76.12) lat (ms,95%): 502.20 err/s: 0.00 reconn/s: 0.00
[ 28s ] thds: 6 tps: 50.69 qps: 1025.66 (r/w/o: 721.54/202.75/101.37) lat (ms,95%): 267.41 err/s: 0.00 reconn/s: 0.00
[ 29s ] thds: 6 tps: 39.15 qps: 793.31 (r/w/o: 559.33/155.68/78.31) lat (ms,95%): 383.33 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 6 tps: 38.40 qps: 772.34 (r/w/o: 540.85/154.68/76.81) lat (ms,95%): 308.84 err/s: 0.00 reconn/s: 0.00
SQL statistics:
    queries performed:
        read:                            12460
        write:                           3560
        other:                           1780
        total:                           17800
    transactions:                        890    (29.37 per sec.)
    queries:                             17800  (587.39 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          30.3012s
    total number of events:              890

Latency (ms):
         min:                                    8.08
         avg:                                  203.01
         max:                                 1753.05
         95th percentile:                      612.21
         sum:                               180675.22

Threads fairness:
    events (avg/stddev):           148.3333/9.43
    execution time (avg/stddev):   30.1125/0.11


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=6 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql run
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
threads: 6
read: 12460
write: 3560
other: 1780
total: 17800
transactions/s: 29.37
queries/s: 587.39
time: 30.3012s
min: 8.08
avg: 203.01
max: 1753.05
95th: 612.21

| mysql sysbench | sysbench | threads: | read: | write: | other: | total: | transactions/s: | queries/s: | time: | min: | avg: | max: | 95th: |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| oltp_read_write.lua | 1.0.20 | 6 | 12460 | 3560 | 1780 | 17800 | 29.37 | 587.39 | 30.3012s | 8.08 | 203.01 | 1753.05 | 612.21 |

sysbench,sysbench,threads,read,write,other,total,transactions/s,queries/s,time,min,avg,max,95th
oltp_read_write.lua,1.0.20,6,12460,3560,1780,17800,29.37,587.39,30.3012s,8.08,203.01,1753.05,612.21

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=6 --report-interval=1 --rand-type=uniform --rand-seed=1 --table-size=150000 --tables=8 --db-driver=mysql cleanup
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...

eva2000 · Jun 29, 2020

wow those are pretty poor performance results for sysbench cpu, mem and disk for what is meant to be 6 cpu thread VPS. Look at the poor scaling of sysbench cpu from 1 cpu thread 113 events/s to 6 cpu threads 163 events/s - clearly you're not getting full 6 cpu threads there and there is cpu utilisation capping of some kind I am guessing. Looks like really on 163/113 = 1.44 cpu thread result for 6 cpu thread test !!

and well disk file benchmarks are very slow as is mysql OLTP benchmark !

Guess you get what you pay for and Vultr high cpu frequency VPS will run rings around ssdnodes. Looking forward to your Vultr high cpu freq VPS sysbench.sh tests to compare

Jimmy · Jun 29, 2020

My server is so slow and my site takes forever to load. What I'm thinking is they're limiting me because my site has been getting hammered by scanners from everywhere. My server went from about 90% idle to 72% idle in a week - metric is in the back of IPB.

They probably want me to get that site off their servers. Which is fine, I can use the server for sites which are just starting and not getting a lot of traffic. There should be some sort of notice that they're rate limiting.

Vultr looks nice. I'm not sure about their DDoS solution if I should run Cloudflare in-front of their DDoS or bypass cloudflare? Any suggestions / experience on that?

eva2000 · Jun 29, 2020

These days always run Cloudflare in front of any Centmin Mod site for CDN cache and security/performance

You can compare your sysbench results with my old 13 way VPS benchmarks at DigitalOcean - Linode - Vultr - Benchmarks - Upcloud - 13-Way VPS Server Benchmark Comparison Tests - Upcloud vs DigitalOcean vs Linode vs Vultr vs Hetzner where Upcloud, Linode AMD EPYC and Vultr high cpu frequency 2 cpu thread VPS all have sysbench.sh 2 cpu thread scores over 900+ events/s which is 5x times more than ssdnode's 6 cpu thread sysbench cpu score !

edit: even slow DO std VPS has cpu 1 thread = 220 events/s and 2 cpu thread = 425 events/s and uses same Intel Xeon E5-2650v4 as ssdnodes so even ssdnode's 1 cpu thread is around 113/220 = 0.51 cpu thread !

Jimmy · Jun 29, 2020

The only thing I question is how Vultr's DDoS solution handles the IPs coming from CF. CMM will be expecting to convert those from CF right? With another DDoS solution between CF and the CMM server, could there be an issue? Didn't you setup CMM expecting --> CF --> CMM and not --> CF --> other --> CMM?

Wanted to let you know that the input box is missing from my view. I have to click on the reply to thread button to post.

eva2000 · Jun 29, 2020

Jimmy said: ↑

Wanted to let you know that the input box is missing from my view. I have to click on the reply to thread button to post.
Click to expand...

might want to report that here Forum Feedback & Suggestions with screenshot and resolution/width of your browser window, could be responsive view/media css coming into play ?

Jimmy said: ↑

The only thing I question is how Vultr's DDoS solution handles the IPs coming from CF. CMM will be expecting to convert those from CF right? With another DDoS solution between CF and the CMM server, could there be an issue? Didn't you setup CMM expecting --> CF --> CMM and not --> CF --> other --> CMM?
Click to expand...

Vultr DDOS only would really come into play for volumetric DDOS attacks not layer 7 so attacks trying to hit your Vultr server real IP address itself. Cloudflare will handle the layer 7 HTTP with help of CF WAF, Firewall/Rate limiting and any volumetric DDOS attacks hitting CF public reported IP and CF DNS nameservers. Combined best of both worlds

Jimmy · Jun 29, 2020

Thanks! Not sure what you did, but the box is back. Once I get the Vultr VPS I'll run the bench.

eva2000 · Jun 29, 2020

Jimmy said: ↑

Thanks! Not sure what you did, but the box is back. Once I get the Vultr VPS I'll run the bench.
Click to expand...

nothing done on my end

IIRC Vultr DDOS is also toggle on/off, so if it does cause issues just disbale it

FYI, Linode has native DDOS on all VPS too and have no problems with this forum behind Cloudflare

Jimmy · Jun 29, 2020

Sounds like you like Linode more than Vultr. I've never actually had a server on Linode though I have an account there. Linode wasn't even on the list for below $25 on VPSbenchmarks.net.

Best VPS 2020 under $25

Even under the $40 cap, linode was down the list.

Best VPS 2020 under $40

At $60 Vultr comes in 1st. Gets a little light on testing at the $60 level, I assume it's not easy putting $60 out for every VPS to test. They should've tested some more Linode VPS vs. just the one dedicated one they tested.

Best VPS 2020 under $60

Brian at Jamroom swears by Linode.

eva2000 · Jun 29, 2020

Linode for VPS and disk cloning, disk storage layer and resilience is what has me hooked still. Disk issues/alerts just require a one click in dashboard to migrate VPS to another VPS host node and disk transfer speed for VPS migrations are at least 8-10x times faster than DO and Vultr. Now that Linode has DDOS protection and new dedicated cpu plans out with better cost per cpu core, no brainer for me even if cpu isn't the fastest right now - Linode once they go AMD EPYC 2 Rome, will be even better

Linode.com <<

Linode has many generations of cpu models, so you need to spin up and land on a newer gen for best performance though. That's one thing Vultr has going for it, guaranteed cpu models of a certain range.

Jimmy · Jun 29, 2020

I'm not 100% on Vultr. You have some good points. I'll have to think about it more. Maybe I'll do Linode, seems like everyone is pro Linode.

The whole idea of having to find the good CPU doesn't thrill me. Not even sure what CPU to look for. LOL!

eva2000 · Jun 29, 2020

Jimmy said: ↑

The whole idea of having to find the good CPU doesn't thrill me. Not even sure what CPU to look for. LOL!
Click to expand...

Yeah Linode has community programs where they donate their old servers to charities and groups in their community, so hope they eventually dump all their old gear and go AMD EPYC 2 Rome

Or maybe move their Intel cpus over to specific usage product offerings i.e. dedicated Redis / PHP servers which perform better on Intel than AMD

Jimmy · Jun 29, 2020

Are they using the AMDs in all the locations? I'm assuming that is what I should look for.

eva2000 · Jun 29, 2020

AFAIK newer data centers get predominantly more new cpus Linode - Guessing Linode's next server cpus ?

buik · Jun 29, 2020

Jimmy said: ↑

Sounds like you like Linode more than Vultr. I've never actually had a server on Linode though I have an account there. Linode wasn't even on the list for below $25 on VPSbenchmarks.net.
Brian at Jamroom swears by Linode.
Click to expand...

Problem with VPS benchmarking is neighbors.
As with living, busy neighbors are more annoying than quieter.
That is why a benchmark on VPS servers is often biased.

You simply don't know under which conditions the benchmark was carried out.

For example, if the VPS server is provided free specifically for the benchmark or independently created by the tester itself.

If the server is provided free of charge for testing purposes,
it is often provided on a specific, quiet node or even without neighbors.

Benchmarks are also regularly paid for by VPS supplier.
More and more often you see in reviews, unknown, often small VPS vendors that are benching by far as number one in terms of results.

This gives a distorted test result.
In short, you can only find out what suits you best.

Make a shortlist with which functions you want and see at which suppliers this is possible. (@eva2000 examples)

Then create a number of VPS servers at the vendors on your shortlist.

Because a monthly VPS server doesn't cost more than a cheap meal in a restaurant (And achievable for most people). It is always recommended to test a number of different VPS servers for a while.

Log in / Register

Forums

Join the community today

SSDNodes SSDNodes review from solovyov.net

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

buik “The best traveler is one without a camera.”

.

Log in / Register

Useful Searches

Join the community today

SSDNodes SSDNodes review from solovyov.net

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

Jimmy Well-Known Member

eva2000 Administrator Staff Member

buik “The best traveler is one without a camera.”

.