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