Tests
Suites
Latest Results
Register
Login
Popular Tests
Timed Linux Kernel Compilation
Flexible IO Tester
Blender
John The Ripper
x264
GROMACS
Newest Tests
ONNX Runtime
Google SynthMark
Timed Godot Game Engine Compilation
RELION
OpenFOAM
Quantum ESPRESSO
Recently Updated Tests
QMCPACK
CloverLeaf
rav1e
Mobile Neural Network
LAMMPS Molecular Dynamics Simulator
New & Recently Updated Tests
Recently Updated Suites
Machine Learning
Speech
Timed Code Compilation
New & Recently Updated Suites
Currently Trending Results
3900xt sun
3950X Sunday Afternoon
xeon-broadwell-2021
os bench
EPYC 7702 Sunny
5600X New 2021
Component Benchmarks
CPUs / Processors
GPUs / Graphics
OpenGL
Disks / Storage
Motherboards
File-Systems
Operating Systems
OpenBenchmarking.org
Corporate / Organization Info
Bug Reports / Feature Requests
Contact Us
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>