Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
SVT-AV1
7-Zip Compression
Stockfish
x265
FFmpeg
Newest Tests
LiteRT
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
Recently Updated Tests
ASTC Encoder
SVT-AV1
Unvanquished
Primesieve
XNNPACK
oneDNN
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 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>