HammerDB - MariaDB 1.1.0

pts/hammerdb-mariadb-1.1.0 - 01 November 2022 - Update against HammerDB 4.5, MariaDB 10.9.3 upstream. Closes: https://github.com/phoronix-test-suite/test-profiles/pull/253

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://archive.mariadb.org/mariadb-10.9.3/source/mariadb-10.9.3.tar.gz</URL>
      <MD5>148bd81146b6d4332673e298d5606724</MD5>
      <SHA256>9a1e229972fcccc8270e633f68d3fb824da151dcf4f53da1df8d947aca876bee</SHA256>
      <FileName>mariadb-10.9.3.tar.gz</FileName>
      <FileSize>97243702</FileSize>
    </Package>
    <Package>
      <URL>https://github.com/TPC-Council/HammerDB/releases/download/v4.5/HammerDB-4.5-Linux.tar.gz</URL>
      <MD5>ca4401e7826e2bcd1c3652a4fc96953e</MD5>
      <SHA256>af9fd885afa15c6bcff8c81d8ca05485992f6519ee714f923466382447e2c754</SHA256>
      <FileName>HammerDB-4.5-Linux.tar.gz</FileName>
      <FileSize>6198386</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh
rm -rf mysql_
# BUILD
tar -xf mariadb-10.9.3.tar.gz
mkdir ~/mysql_
cd mariadb-10.9.3/BUILD/
cmake -DCMAKE_INSTALL_PREFIX=$HOME/mysql_ -DDEFAULT_SYSCONFDIR=$HOME ..
if [ "$OS_TYPE" = "BSD" ]
then
	gmake -j $NUM_CPU_CORES
	echo $? > ~/install-exit-status
	gmake install
else
	make -j $NUM_CPU_CORES
	echo $? > ~/install-exit-status
	make install
fi

# SETUP
# Moved to pre process to wipe .data each time
#cd ~/mysql_
#./scripts/mysql_install_db --no-defaults --user=`basename $DEBUG_REAL_HOME` --basedir=$HOME/mysql_ --ldata=$HOME/mysql_/.data
#chmod -R 777 .data
cd ~
tar -xf HammerDB-4.5-Linux.tar.gz
echo "[mysqld]
skip-log-bin
datadir=/data
default_authentication_plugin=mysql_native_password
socket=/tmp/mysql.sock
port=3306
bind_address=localhost
# general
max_connections=4000
table_open_cache=8000
table_open_cache_instances=16
back_log=1500
default_password_lifetime=0
ssl=0
performance_schema=OFF
max_prepared_stmt_count=128000
skip_log_bin=1
character_set_server=latin1
collation_server=latin1_swedish_ci
transaction_isolation=REPEATABLE-READ
# files
innodb_file_per_table
innodb_log_file_size=1024M
innodb_log_files_in_group=32
innodb_open_files=4000
# buffers
innodb_buffer_pool_size=64000M
innodb_buffer_pool_instances=16
innodb_log_buffer_size=64M
# tune
innodb_page_size=8192
innodb_doublewrite=0
innodb_thread_concurrency=0
innodb_flush_log_at_trx_commit=0
innodb_max_dirty_pages_pct=90
innodb_max_dirty_pages_pct_lwm=10
join_buffer_size=32K
sort_buffer_size=32K
innodb_use_native_aio=1
innodb_stats_persistent=1
innodb_spin_wait_delay=6
innodb_max_purge_lag_delay=300000
innodb_max_purge_lag=0
innodb_flush_method=O_DIRECT_NO_FSYNC
innodb_checksum_algorithm=none
innodb_io_capacity=4000
innodb_io_capacity_max=20000
innodb_lru_scan_depth=9000
innodb_change_buffering=none
innodb_read_only=0
innodb_page_cleaners=4
innodb_undo_log_truncate=off
# perf special
innodb_adaptive_flushing=1
innodb_flush_neighbors=0
innodb_read_io_threads=16
innodb_write_io_threads=16
innodb_purge_threads=4
innodb_adaptive_hash_index=0
# monitoring
innodb_monitor_enable='%'" > my.cnf
ln -s my.cnf .my.cnf

echo "#!/bin/sh
cd HammerDB-4.5/
export LD_LIBRARY_PATH=\$HOME/mysql_/lib/:\$LD_LIBRARY_PATH
echo \"#vi mysqlrun.tcl
puts \\\"SETTING CONFIGURATION\\\"
dbset db mysql
diset connection mysql_host localhost
diset connection mysql_port 3306
diset tpcc mysql_driver timed
diset tpcc mysql_prepared false
diset tpcc mysql_rampup 2
diset tpcc mysql_duration 6
diset tpcc mysql_user `basename $DEBUG_REAL_HOME`
diset tpcc mysql_pass phoronix
vuset logtotemp 1
loadscript
puts \\\"TEST STARTED\\\"
vuset vu \$1
vucreate
vurun
runtimer 500
vudestroy
puts \\\"TEST COMPLETE\\\"\" > mysqlrun.tcl
./hammerdbcli auto mysqlrun.tcl > \$LOG_FILE 2>&1
echo \$? > ~/test-exit-status" > hammerdb-mariadb
chmod +x hammerdb-mariadb

post.sh

#!/bin/sh
# STOP SERVER
cd mysql_
./bin/mysqladmin -u `basename $DEBUG_REAL_HOME` -pphoronix shutdown
sleep 5
rm -rf .data/*

pre.sh

#!/bin/sh
export LD_LIBRARY_PATH=\$HOME/mysql_/lib/:$LD_LIBRARY_PATH
# SETUP
cd $HOME/mysql_
rm -rf .data/*
./scripts/mysql_install_db --no-defaults --user=`basename $DEBUG_REAL_HOME` --basedir=$HOME/mysql_ --ldata=$HOME/mysql_/.data
chmod -R 777 .data

# START SERVER
cd $HOME/mysql_
if [ "$(whoami)" == "root" ] ; then
    $HOME/mysql_/bin/mysqld_safe --no-defaults --user=root --datadir=$HOME/mysql_/.data > server.log 2>&1 &
else
    $HOME/mysql_/bin/mysqld_safe --no-defaults --datadir=$HOME/mysql_/.data > server.log 2>&1 &
fi

sleep 5
$HOME/mysql_/bin/mysqladmin -u `basename $DEBUG_REAL_HOME` password 'phoronix'
cd ~/HammerDB-4.5/
echo "puts \"SETTING CONFIGURATION\"
dbset db mysql
diset connection mysql_host localhost
diset connection mysql_port 3306
diset tpcc mysql_count_ware $2
diset tpcc mysql_partition true
diset tpcc mysql_num_vu $1
diset tpcc mysql_storage_engine innodb
diset tpcc mysql_user `basename $DEBUG_REAL_HOME`
diset tpcc mysql_pass phoronix
print dict
buildschema
waittocomplete" > schemabuild.tcl
./hammerdbcli auto schemabuild.tcl

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>Vuser 1:TEST RESULT : System achieved #_RESULT_# NOPM from 16917 MySQL TPM</OutputTemplate>
    <LineHint>System achieved</LineHint>
    <ResultScale>New Orders Per Minute</ResultScale>
  </ResultsParser>
  <ResultsParser>
    <OutputTemplate>Vuser 1:TEST RESULT : System achieved 555 NOPM from #_RESULT_# MySQL TPM</OutputTemplate>
    <LineHint>System achieved</LineHint>
    <ResultScale>Transactions Per Minute</ResultScale>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>HammerDB - MariaDB</Title>
    <AppVersion>10.9.3</AppVersion>
    <Description>This is a MariaDB MySQL database server benchmark making use of the HammerDB benchmarking / load testing tool.</Description>
    <ResultScale>New Orders Per Minute</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>1</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.1.0</Version>
    <SupportedPlatforms>Linux, MacOSX, BSD</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <SupportedArchitectures>x86_64</SupportedArchitectures>
    <ExternalDependencies>build-utilities, cmake, libevent, ncurses-development, bison, flex, openssl-development, zlib-development</ExternalDependencies>
    <EnvironmentSize>10000</EnvironmentSize>
    <ProjectURL>https://mariadb.com/</ProjectURL>
    <RepositoryURL>https://github.com/TPC-Council/HammerDB</RepositoryURL>
    <InternalTags>SMP</InternalTags>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Virtual Users</DisplayName>
      <Identifier>virtual-users</Identifier>
      <Menu>
        <Entry>
          <Name>8</Name>
          <Value>8</Value>
        </Entry>
        <Entry>
          <Name>16</Name>
          <Value>16</Value>
        </Entry>
        <Entry>
          <Name>32</Name>
          <Value>32</Value>
        </Entry>
        <Entry>
          <Name>64</Name>
          <Value>64</Value>
        </Entry>
        <Entry>
          <Name>128</Name>
          <Value>128</Value>
        </Entry>
        <Entry>
          <Name>256</Name>
          <Value>256</Value>
        </Entry>
        <Entry>
          <Name>512</Name>
          <Value>512</Value>
        </Entry>
      </Menu>
    </Option>
    <Option>
      <DisplayName>Warehouses</DisplayName>
      <Identifier>warehouses</Identifier>
      <Menu>
        <Entry>
          <Name>100</Name>
          <Value>100</Value>
        </Entry>
        <Entry>
          <Name>250</Name>
          <Value>250</Value>
        </Entry>
        <Entry>
          <Name>500</Name>
          <Value>500</Value>
        </Entry>
        <Entry>
          <Name>1000</Name>
          <Value>1000</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>