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 )

    <li>
      base zfs in 12.1
    </li>
    <li>
      openzfs-kmod-2019101600
    </li>
    <li>
      AVAGO MegaRAID SAS FreeBSD mrsas driver version: 07.709.04.00-fbsd
    </li>
  </ul>
  

  • 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