MariaDB mariadb-slap 1.5.0

pts/mysqlslap-1.5.0 - 24 March 2024 - Update against MariaDB 11.5 plus other fixes/improvements.

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>
    <Package>
      <URL>http://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2</URL>
      <MD5>dc44092ed3cfadfcf19bbab32b0ff887</MD5>
      <SHA256>9be9b830a185e947758581cb06f529d1e8b675b29cde13a2860b1319b7e1cb7d</SHA256>
      <FileName>employees_db-full-1.0.6.tar.bz2</FileName>
      <FileSize>26715056</FileSize>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/bash
rm -rf mysql_
# BUILD
tar -xf mariadb-11.5.0.tar.gz
mkdir ~/mysql_
cd mariadb-11.5.0/BUILD/
cmake -DCMAKE_INSTALL_PREFIX=$HOME/mysql_ -DCMAKE_BUILD_TYPE=Release -DWITHOUT_ROCKSDB=1 ..
if [ "$OS_TYPE" = "BSD" ]
then
	gmake -j $NUM_CPU_CORES
else
	make -j $NUM_CPU_CORES
fi
make install
echo $? > ~/install-exit-status
# SETUP
cd ~/mysql_
rm -rf mariadb-11.5.0
RAM8P="$(($SYS_MEMORY * 75 / 100))"
./scripts/mysql_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/mysql_ --ldata=$HOME/mysql_/.data
chmod -R 777 .data
cd ~
echo "#!/bin/sh
cd mysql_
./bin/mysqlslap --user=`basename $DEBUG_REAL_HOME` -pphoronix --host=localhost --verbose \$@ > \$LOG_FILE 2>&1
echo \$? > ~/test-exit-status" > mysqlslap
chmod +x mysqlslap

post.sh

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

pre.sh

#!/bin/bash
# START SERVER
cd $HOME/mysql_
RAM8P="$(($SYS_MEMORY * 75 / 100))"
if [ "$(whoami)" == "root" ] ; then
    $HOME/mysql_/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/mysql_/.data &
else
    $HOME/mysql_/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/mysql_/.data &
fi
sleep 5
$HOME/mysql_/bin/mariadb-admin -u `basename $DEBUG_REAL_HOME` password 'phoronix'
cd $HOME
tar -xf employees_db-full-1.0.6.tar.bz2
cd employees_db
../mysql_/bin/mariadb -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix -t < employees.sql

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>	Average number of seconds to run all queries: #_RESULT_# seconds</OutputTemplate>
    <DivideResultDivisor>1000</DivideResultDivisor>
    <ResultPrecision>0</ResultPrecision>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>MariaDB mariadb-slap</Title>
    <AppVersion>11.5</AppVersion>
    <Description>This is a MariaDB MySQL database server benchmark making use of mysqlslap (mariadb-slap).</Description>
    <ResultScale>Queries Per Second</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.5.0</Version>
    <SupportedPlatforms>Linux, MacOSX, BSD</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>2200</EnvironmentSize>
    <ProjectURL>https://mariadb.org/</ProjectURL>
    <RepositoryURL>https://github.com/MariaDB/server</RepositoryURL>
    <RequiresCoreVersionMin>8111</RequiresCoreVersionMin>
    <InternalTags>SMP</InternalTags>
    <Maintainer>Michael Larabel</Maintainer>
  </TestProfile>
  <TestSettings>
    <Default>
      <Arguments>--auto-generate-sql -e innodb --iterations=100 --number-int-cols=4 --number-char-cols=4 --auto-generate-sql-add-autoincrement --auto-generate-sql-execute-number=1000</Arguments>
    </Default>
    <Option>
      <DisplayName>Clients</DisplayName>
      <Identifier>clients</Identifier>
      <ArgumentPrefix>--concurrency=</ArgumentPrefix>
      <Menu>
        <Entry>
          <Name>1</Name>
          <Value>1</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>1024</Name>
          <Value>1024</Value>
        </Entry>
        <Entry>
          <Name>2048</Name>
          <Value>2048</Value>
        </Entry>
        <Entry>
          <Name>4096</Name>
          <Value>4096</Value>
        </Entry>
        <Entry>
          <Name>8192</Name>
          <Value>8192</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>