SQL Performance with sysbench on different disks

[Christophe CHEVALLIER]

Hello everybody,

I have some problem about performance with sysbench on my different OVH servers, here are my results :

With this command : sysbench --test=fileio --file-test-mode=seqwr run

RISE-2 server : ( Intel Xeon-E 2386G / 64Gb RAM DDR4 ECC )
Two NVMe disks mounted in RAID 1 (SoftRAID) : SAMSUNG MZVL2512HCJQ-00B07 / 488.16Gb / Performance Write SQL : average 27 MiB/s <========== BAD PERFORMANCE !!!

RISE-S server : ( AMD Ryzen 7 9700K / 64Gb RAM DDR5 )
Two NVMe disks mounted in RAID 1 (SoftRAID) : SAMSUNG MZVL2512HCJQ-00B07 / 488.16Gb / Performance Write SQL : average 34 MiB/s <========== BAD PERFORMANCE !!!

KS-5 server : ( Intel Xeon-E3 1270 v6 / 32Gb RAM DDR4 ECC )
Two NVMe disks mounted in RAID 1 (SoftRAID) : INTEL SSDPE2MX450G7 / 429.04Gb / Performance Write SQL : average 542 MiB/s <========== OK !!!

SYS-LE-2 server : ( Intel Xeon-E 2274G / 64Gb RAM DDR4 ECC )
Two NVMe disks mounted in RAID 1 (SoftRAID) : SAMSUNG MZQLB1T9HAJR-00007 / 1.78Tb / Performance Write SQL : Environ 886 MiB/s <========== OK !!!

It seems the disk SAMSUNG MZVL2512HCJQ-00B07 has poor performance about write.
What do you think about these results??? Is it the disk fault?

BUT if we use command : fio, all is fine with good performance.
With this command : fio --name=rand-write --ioengine=libaio --iodepth=32 --rw=randwrite --invalidate=1 --bsrange=4k:4k,4k:4k --size=512m --runtime=120 --time_based --do_verify=1 --direct=1 --group_reporting --numjobs=1

RISE-2 server : IOPS =213K / BW=830MiB/s (870MB/s).
RISE-S server : IOPS=453k, BW=1771MiB/s (1857MB/s)(208GiB/120001msec)
KS-5 server : IOPS=117k, BW=459MiB/s (481MB/s)(53.7GiB/120001msec)
SYS-LE-2 server : IOPS=148k, BW=577MiB/s (605MB/s)(67.6GiB/120001msec)

I don’t really know what’s happen. I’m not an expert about this.

Regards,

Christophe.