MariaDB 10.4 – with Sysbench FreeBSD, Linux (CentOS) and ZFS

Software & Hardware Setup

• Linux
  • Linux 3.10.0-1062.1.1.el7.x86_64 #1 SMP Fri Sep 13 22:55:44 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux
  • CentOS Linux release 7.7.1908 (Core)
  • kmod-zfs-0.8.2-1.el7.x86_64
• FreeBSD
  • FreeBSD 12.1-STABLE FreeBSD 12.1-STABLE r354267 DPD amd64
    • ( ~ 12.1-release, from 12-stable svn )
  • base zfs in 12.1
  • openzfs-kmod-2019101600
  • AVAGO MegaRAID SAS FreeBSD mrsas driver version: 07.709.04.00-fbsd
• Hardware
  • Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz, Dual Sockets
  • Supermicro X10DRH-CT
  • 128GB RAM
  • AVAGO/Broadcom 3108 MegaRAID (Integrated)
    • Firmware Package Build = 24.21.0-0028
    • Firmware Version = 4.680.00-8290
    • RAID50
    • Cache : Read Ahead Always, Always WriteBack, Direct
    • Stripe 1MB
    • 8 x MZILS480HCGR Samsung PM1633, 480GB TLC SAS 12Gbps

Testing Script

#!/bin/sh
os=`uname`


if [ "${os}" == "FreeBSD" ]; then
	TEST="/usr/local/share/sysbench/oltp_read_write.lua"
	SOCK="/tmp/mysql.sock"
else
	TEST="/usr/share/sysbench/oltp_read_write.lua"
	SOCK="/var/lib/mysql/mysql.sock"

fi

OPT1="--mysql-user=sysbench --mysql-password=abcd1234 --mysql-socket=${SOCK} --mysql-db=sysbench --tables=2 --table-size=500000000 --events=0"

sysbench ${TEST} --threads=8 ${OPT1} --time=600  --db-ps-mode=disable --report-interval=30 run
sysbench ${TEST} --threads=8 ${OPT1} --time=3600 --db-ps-mode=disable --report-interval=300 run

OPT2="--delete_inserts=2 --index_updates=2 --non_index_updates=0"

sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=600  --db-ps-mode=disable --report-interval=30 run
sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=3600 --db-ps-mode=disable --report-interval=300 run


OPT2="--delete_inserts=5 --index_updates=5 --non_index_updates=0"

sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=600  --db-ps-mode=disable --report-interval=30 run
sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=3600 --db-ps-mode=disable --report-interval=300 run

OPT2="--delete_inserts=10 --index_updates=10 --non_index_updates=1"

sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=600  --db-ps-mode=disable --report-interval=30 run
sysbench ${TEST} --threads=8 ${OPT1} ${OPT2} --time=3600 --db-ps-mode=disable --report-interval=300 run