Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
7-Zip Compression
SVT-AV1
FFmpeg
PostgreSQL
Stockfish
Newest Tests
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
GROMACS
Recently Updated Tests
Apache CouchDB
PostgreSQL
NAMD
Apache Cassandra
Opus Codec Encoding
ParaView
New & Recently Updated Tests
Recently Updated Suites
Database Test Suite
Machine Learning
Steam
New & Recently Updated Suites
Component Benchmarks
CPUs / Processors
GPUs / Graphics
OpenGL
Disks / Storage
Motherboards
File-Systems
Operating Systems
OpenBenchmarking.org
Corporate / Organization Info
Bug Reports / Feature Requests
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>