Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
Stockfish
7-Zip Compression
SVT-AV1
PostgreSQL
FFmpeg
Newest Tests
WarpX
Epoch
Valkey
Whisperfile
XNNPACK
GROMACS
Recently Updated Tests
CP2K Molecular Dynamics
Apache CouchDB
PostgreSQL
NAMD
Apache Cassandra
Opus Codec Encoding
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.1.0
pts/mysqlslap-1.1.0
- 09 May 2020 -
Update against upstream MariaDB 10.5.2.
downloads.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v9.6.0--> <PhoronixTestSuite> <Downloads> <Package> <URL>https://mirror.sobukus.de/files/src/mariadb/mariadb-10.5.2.tar.gz, https://downloads.mariadb.com/MariaDB/mariadb-10.5.2/source/mariadb-10.5.2.tar.gz</URL> <MD5>bdbf84af3358db640674b00e3b78b28c</MD5> <SHA256>4a70d8439fb196e97ef39556ddcc88769df042825dffdba668aed53ca7eec002</SHA256> <FileName>mariadb-10.5.2.tar.gz</FileName> <FileSize>78860858</FileSize> </Package> <Package> <URL>https://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/sh rm -rf mysql_ # BUILD tar -xf mariadb-10.5.2.tar.gz mkdir ~/mysql_ cd mariadb-10.5.2/BUILD/ cmake -DCMAKE_INSTALL_PREFIX=$HOME/mysql_ .. make -j $NUM_CPU_CORES echo $? > ~/install-exit-status make install # SETUP 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 ~ 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/mysqladmin -u `basename $DEBUG_REAL_HOME` -pphoronix shutdown sleep 5
pre.sh
#!/bin/sh # START SERVER cd $HOME/mysql_ if [ "$(whoami)" == "root" ] ; then $HOME/mysql_/bin/mysqld_safe --user=root --no-defaults --datadir=$HOME/mysql_/.data & else $HOME/mysql_/bin/mysqld_safe --no-defaults --datadir=$HOME/mysql_/.data & fi sleep 5 $HOME/mysql_/bin/mysqladmin -u `basename $DEBUG_REAL_HOME` password 'phoronix' cd $HOME tar -xf employees_db-full-1.0.6.tar.bz2 cd employees_db ../mysql_/bin/mysql -h localhost -u `basename $DEBUG_REAL_HOME` -pphoronix -t < employees.sql
results-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v9.6.0--> <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 v9.6.0--> <PhoronixTestSuite> <TestInformation> <Title>MariaDB</Title> <AppVersion>10.5.2</AppVersion> <Description>This is a MariaDB MySQL database server benchmark making use of mysqlslap.</Description> <ResultScale>Queries Per Second</ResultScale> <Proportion>HIB</Proportion> <TimesToRun>3</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> <ExternalDependencies>build-utilities, cmake, libevent, ncurses-development, bison, flex, openssl-development, zlib-development</ExternalDependencies> <EnvironmentSize>2200</EnvironmentSize> <ProjectURL>https://mariadb.com/</ProjectURL> <RequiresCoreVersionMin>8111</RequiresCoreVersionMin> <InternalTags>SMP</InternalTags> <Maintainer>Michael Larabel</Maintainer> </TestProfile> <TestSettings> <Default> <Arguments>--auto-generate-sql --iterations=200 --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>4</Name> <Value>4</Value> </Entry> <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> </TestSettings> </PhoronixTestSuite>