MariaDB 1.0.0

pts/mariadb-1.0.0 - 24 March 2024 - Add a MariaDB test using sysbench rather than pts/mysqlslap.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://archive.mariadb.org/mariadb-11.5.0/source/mariadb-11.5.0.tar.gz</URL>
      <MD5>0d9575206d03936588f2a23189465259</MD5>
      <SHA256>977fcaac855cd432bcabe2775e24bca9d80732c34db8757657521eda95a74bd0</SHA256>
      <FileName>mariadb-11.5.0.tar.gz</FileName>
      <FileSize>107108790</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh
rm -rf mariadb_
tar -xf mariadb-11.5.0.tar.gz
mkdir ~/mariadb_
cd mariadb-11.5.0/BUILD/
cmake -DCMAKE_INSTALL_PREFIX=$HOME/mariadb_ -DCMAKE_BUILD_TYPE=Release -DWITHOUT_ROCKSDB=1 ..
if [ "$OS_TYPE" = "BSD" ]
then
	gmake -j $NUM_CPU_CORES
else
	make -j $NUM_CPU_CORES
fi
export PATH=$HOME/mariadb_/bin/:$HOME/mariadb-11.5.0/BUILD/extra/:$PATH
make install
echo $? > ~/install-exit-status

cd ~/mariadb_
mkdir .data
chmod -R 777 .data
RAM8P="$(($SYS_MEMORY * 75 / 100))"
./scripts/mariadb-install-db --no-defaults --user=`basename $DEBUG_REAL_HOME` --innodb-log-file-size=1G --innodb-buffer-pool-size=${RAM8P}M --query-cache-size=64M --max-heap-table-size=512M --tmp-table-size=2G --basedir=$HOME/mariadb_ --ldata=$HOME/mariadb_/.data
if [ "$(whoami)" == "root" ] ; then
    ./bin/mariadbd-safe --no-defaults --innodb-log-file-size=1G --innodb-buffer-pool-size=${RAM8P}M --query-cache-size=64M --max_connections=8200 --max-heap-table-size=512M --tmp-table-size=2G --user=root --datadir=$HOME/mariadb_/.data &
else
   ./bin/mariadbd-safe --no-defaults --innodb-log-file-size=1G --innodb-buffer-pool-size=${RAM8P}M --query-cache-size=64M --max_connections=8200 --max-heap-table-size=512M --tmp-table-size=2G --datadir=$HOME/mariadb_/.data &
fi
sleep 5
./bin/mariadb-admin -u `basename $DEBUG_REAL_HOME` password 'phoronix'
sleep 1
echo "DROP DATABASE sbtest;" | ./bin/mariadb -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix --comments
echo "CREATE DATABASE sbtest;" |  ./bin/mariadb -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix --comments
sysbench oltp_common --threads=$NUM_CPU_CORES --rand-type=uniform --db-driver=mysql --mysql-db=sbtest --mysql-host=localhost --mysql-port=3306 --mysql-user=`basename $DEBUG_REAL_HOME` --mysql-socket=/tmp/mysql.sock --mysql-password=phoronix prepare --tables=16 --table-size=1000000
./bin/mariadb-dump -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix --comments sbtest > ~/mysql-dumped
echo $? > ~/install-exit-status
echo "DROP DATABASE sbtest;" |  ./bin/mariadb -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix --comments

./bin/mariadb-admin -u `basename $DEBUG_REAL_HOME` -pphoronix shutdown
sleep 3
cd ~
echo "#!/bin/sh
cd mariadb_
echo \"DROP DATABASE sbtest;\" |  ./bin/mariadb --comments -h localhost -u \`basename $DEBUG_REAL_HOME\` -pphoronix
echo \"CREATE DATABASE sbtest;\" |  ./bin/mariadb --comments -h localhost -u \`basename $DEBUG_REAL_HOME\` -pphoronix
./bin/mariadb --comments -h localhost -u \`basename $DEBUG_REAL_HOME\` -pphoronix sbtest < ~/mysql-dumped 
sleep 3
sysbench \$1 --threads=\$2 --time=200 --rand-type=uniform --db-driver=mysql --mysql-db=sbtest --mysql-host=localhost --mysql-user=\`basename $DEBUG_REAL_HOME\` --mysql-password=phoronix  --mysql-socket=/tmp/mysql.sock run --tables=16 --table-size=1000000 > \$LOG_FILE 2>&1
echo \$? > ~/test-exit-status
echo \"DROP DATABASE sbtest;\" | ./bin/mariadb --comments -h localhost -u \`basename $DEBUG_REAL_HOME\` -pphoronix" > mariadb
chmod +x mariadb

post.sh

#!/bin/sh
# STOP SERVER
cd mariadb_
./bin/mariadb-admin -u `basename $DEBUG_REAL_HOME` -pphoronix shutdown
sleep 5

pre.sh

#!/bin/bash
# START SERVER
cd $HOME/mariadb_
RAM8P="$(($SYS_MEMORY * 75 / 100))"
if [ "$(whoami)" == "root" ] ; then
    $HOME/mariadb_/bin/mariadbd-safe --no-defaults --innodb-log-file-size=1G --innodb-buffer-pool-size=${RAM8P}M --query-cache-size=64M --max_connections=800 --max-heap-table-size=512M --tmp-table-size=2G --user=root --datadir=$HOME/mariadb_/.data --max_prepared_stmt_count=90000 &
else
    $HOME/mariadb_/bin/mariadbd-safe --no-defaults --innodb-log-file-size=1G --innodb-buffer-pool-size=${RAM8P}M --query-cache-size=64M --max_connections=800 --max-heap-table-size=512M --tmp-table-size=2G --max_prepared_stmt_count=90000 --datadir=$HOME/mariadb_/.data &
fi
sleep 5
$HOME/mariadb_/bin/mariadb-admin -u `basename $DEBUG_REAL_HOME` password 'phoronix'

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>    queries:                             10276880 #_RESULT_# per sec.)</OutputTemplate>
    <StripFromResult>(</StripFromResult>
    <ResultPrecision>0</ResultPrecision>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>MariaDB</Title>
    <AppVersion>11.5</AppVersion>
    <Description>This is a MariaDB MySQL database server benchmark making use of sysbench rather than the existing pts/mysqlslap test profile that uses MariaDB with mysqlslap/mariadb-slap as the benchmark driver.</Description>
    <ResultScale>Queries Per Second</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.0.0</Version>
    <SupportedPlatforms>Linux</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <ExternalDependencies>build-utilities, cmake, libevent, ncurses-development, bison, flex, openssl-development, zlib-development</ExternalDependencies>
    <EnvironmentSize>6900</EnvironmentSize>
    <ProjectURL>https://mariadb.org/</ProjectURL>
    <RepositoryURL>https://github.com/MariaDB/server</RepositoryURL>
    <Maintainer>Michael Larabel</Maintainer>
    <SystemDependencies>sysbench</SystemDependencies>
  </TestProfile>
  <TestSettings>
    <Option>
      <DisplayName>Test</DisplayName>
      <Identifier>Test</Identifier>
      <Menu>
        <Entry>
          <Name>oltp_read_write</Name>
          <Value>oltp_read_write</Value>
        </Entry>
        <Entry>
          <Name>oltp_read_only</Name>
          <Value>oltp_read_only</Value>
        </Entry>
        <Entry>
          <Name>oltp_write_only</Name>
          <Value>oltp_write_only</Value>
        </Entry>
        <Entry>
          <Name>oltp_point_select</Name>
          <Value>oltp_point_select</Value>
        </Entry>
        <Entry>
          <Name>oltp_update_non_index</Name>
          <Value>oltp_update_non_index</Value>
        </Entry>
        <Entry>
          <Name>oltp_update_index</Name>
          <Value>oltp_update_index</Value>
        </Entry>
      </Menu>
    </Option>
    <Option>
      <DisplayName>Threads</DisplayName>
      <Identifier>threads</Identifier>
      <Menu>
        <Entry>
          <Name>1</Name>
          <Value>1</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>
        <Entry>
          <Name>768</Name>
          <Value>768</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>