Tests
Suites
Latest Results
Search
Register
Login
Popular Tests
Timed Linux Kernel Compilation
Hashcat
SVT-AV1
7-Zip Compression
OpenFOAM
GLmark2
Newest Tests
MariaDB
FurMark
Counter-Strike 2
Quicksilver
GpuOwl
ProjectPhysX OpenCL-Benchmark
Recently Updated Tests
PyTorch
TensorFlow
Blender
Timed Mesa Compilation
MariaDB mariadb-slap
BRL-CAD
New & Recently Updated Tests
Recently Updated Suites
Steam
HPC - High Performance Computing
Machine Learning
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
MySQL Sysbench 1.0.0
tag3r1s/sysbench-1.0.0
- 16 May 2018 -
Initial commit
downloads.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v7.8.0--> <PhoronixTestSuite> <Downloads> <Package> <URL>http://93.115.27.250/drivers/sysbench-1.0.14.tar.gz</URL> <MD5>90828e98e2b809aaee0fd35434330afe</MD5> <SHA256>81669cee6e0d5fccd5543dbcefec18826db43abba580de06cecf5b54483f6079</SHA256> <FileSize>1507008</FileSize> <PlatformSpecific>Linux</PlatformSpecific> </Package> <Package> <URL>http://93.115.27.250/drivers/server-mariadb-10.3.6.tar.gz</URL> <MD5>697479e74bfa12123fb4b646a95d3db4</MD5> <SHA256>6744c458551cb935ba6df03b693da4d26e286b0104661b0fc29339753bc053a1</SHA256> <FileSize>64012192</FileSize> <PlatformSpecific>Linux</PlatformSpecific> </Package> <Package> <URL>http://93.115.27.250/drivers/mariadb-connector-c-3.0.4.tar.gz</URL> <MD5>df2791e5687035d6550954a8e366b9cf</MD5> <SHA256>49721e5aaff6107e84badc64f524d2b3606049ce6141003f19b89057d6d12040</SHA256> <FileSize>665075</FileSize> <PlatformSpecific>Linux</PlatformSpecific> </Package> </Downloads> </PhoronixTestSuite>
install.sh
#!/bin/sh mysqlversion=10.3.6 version=1.0.14 mysqlconnectorversion=3.0.4 tar -zxvf server-mariadb-${mysqlversion}.tar.gz tar -zxvf mariadb-connector-c-${mysqlconnectorversion}.tar.gz mv mariadb-connector-c-${mysqlconnectorversion}/* server-mariadb-${mysqlversion}/libmariadb/ sed -i 's/INCLUDE(\${CMAKE_SOURCE_DIR}\/plugins\/CMakeLists.txt)/INCLUDE(\${CMAKE_SOURCE_DIR}\/libmariadb\/plugins\/CMakeLists.txt)/g' $HOME/server-mariadb-${mysqlversion}/libmariadb/CMakeLists.txt rm -rf $HOME/mysql_ mkdir -p $HOME/mysql_ cd $HOME/server-mariadb-${mysqlversion} ./BUILD/autorun.sh ./configure --prefix=$HOME/mysql_ make -j $NUM_CPU_JOBS echo $? > ~/install-exit-status make install cd $HOME/mysql_ scripts/mysql_install_db --user=root cd $HOME $HOME/mysql_/bin/mysqld --user=root --bind-address=127.0.0.1 & sleep 10 $HOME/mysql_/bin/mysqladmin shutdown sleep 5 tar -xzf sysbench-${version}.tar.gz rm -rf $HOME/sysbench_ mkdir -p $HOME/sysbench_ cd $HOME/sysbench-${version} ./autogen.sh ./configure --prefix=$HOME/sysbench_ make -j $NUM_CPU_JOBS echo $? > ~/install-exit-status make install cd $HOME rm -rf $HOME/mariadb-connector-c-${mysqlconnectorversion} $HOME/server-mariadb-${mysqlversion} $HOME/sysbench-${version} echo "#!/bin/sh # start server $HOME/mysql_/bin/mysqld --user=root --bind-address=127.0.0.1 & # wait for server to start sleep 10 # create test db $HOME/mysql_/bin/mysql -u root -e \"create database sbtest\" # prepare sysbench $HOME/sysbench_/bin/sysbench --mysql-user=root --mysql-socket=/tmp/mysql.sock --table-size=2000000 --time=300 --max-requests=0 --db-driver=mysql --mysql-storage-engine=innodb \$@ prepare # run the test $HOME/sysbench_/bin/sysbench --mysql-user=root --mysql-socket=/tmp/mysql.sock --table-size=2000000 --time=300 --max-requests=0 --db-driver=mysql --mysql-storage-engine=innodb \$@ run > \$LOG_FILE 2>&1 # cleanup the test $HOME/sysbench_/bin/sysbench --mysql-user=root --mysql-socket=/tmp/mysql.sock --table-size=2000000 --time=300 --max-requests=0 --db-driver=mysql --mysql-storage-engine=innodb \$@ cleanup # drop test db $HOME/mysql_/bin/mysql -u root -e \"drop database sbtest\" # stop server $HOME/mysql_/bin/mysqladmin shutdown" > sysbench chmod +x sysbench
results-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v7.8.0--> <PhoronixTestSuite> <ResultsParser> <OutputTemplate>sysbench 1.0.14 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 32 Initializing random number generator from current time Initializing worker threads... Threads started! SQL statistics: queries performed: read: 744674 write: 205247 other: 103869 total: 1053790 transactions: 50678 (#_RESULT_# per sec.) queries: 1053790 (105306.91 per sec.) ignored errors: 2513 (251.13 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 10.0055s total number of events: 50678 </OutputTemplate> </ResultsParser> </PhoronixTestSuite>
test-definition.xml
<?xml version="1.0"?> <!--Phoronix Test Suite v7.8.0--> <PhoronixTestSuite> <TestInformation> <Title>MySQL Sysbench</Title> <AppVersion>1.0.14</AppVersion> <Description>Sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT. It is most frequently used for database benchmarks, but can also be used to create arbitrarily complex workloads that do not involve a database server. This test profile is only made to do MySQL database server benchmarks.</Description> <ResultScale>TPS</ResultScale> <Proportion>HIB</Proportion> <Executable>sysbench</Executable> <TimesToRun>3</TimesToRun> </TestInformation> <TestProfile> <Version>1.0.0</Version> <SupportedPlatforms>Linux</SupportedPlatforms> <SoftwareType>Benchmark</SoftwareType> <TestType>System</TestType> <License>Free</License> <Status>Unverified</Status> <ExternalDependencies>build-utilities, openssl-development, bison, ncurses-development, cmake, libaio-development, libtool, autoconf </ExternalDependencies> <ProjectURL>https://github.com/akopytov/sysbench/</ProjectURL> <Maintainer>Mazvydas Aukscionis</Maintainer> </TestProfile> <TestSettings> <Option> <DisplayName>Type</DisplayName> <Identifier>type</Identifier> <ArgumentPrefix>$HOME/sysbench_/share/sysbench/</ArgumentPrefix> <ArgumentPostfix></ArgumentPostfix> <DefaultEntry>0</DefaultEntry> <Menu> <Entry> <Name>Bulk Insert</Name> <Value>bulk_insert.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Delete</Name> <Value>oltp_delete.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Insert</Name> <Value>oltp_insert.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Point Select</Name> <Value>oltp_point_select.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Read Only</Name> <Value>oltp_read_only.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Read Write</Name> <Value>oltp_read_write.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Update Index</Name> <Value>oltp_update_index.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Update Non Index</Name> <Value>oltp_update_non_index.lua</Value> <Message></Message> </Entry> <Entry> <Name>Oltp Write Only</Name> <Value>oltp_write_only.lua</Value> <Message></Message> </Entry> <Entry> <Name>Select Random Points</Name> <Value>select_random_points.lua</Value> <Message></Message> </Entry> <Entry> <Name>Select Random Ranges</Name> <Value>select_random_ranges.lua</Value> <Message></Message> </Entry> </Menu> </Option> <Option> <DisplayName>Threads</DisplayName> <Identifier>threads</Identifier> <ArgumentPrefix>--threads=</ArgumentPrefix> <ArgumentPostfix></ArgumentPostfix> <DefaultEntry>0</DefaultEntry> <Menu> <Entry> <Name>1</Name> <Value>1</Value> <Message></Message> </Entry> <Entry> <Name>4</Name> <Value>4</Value> <Message></Message> </Entry> <Entry> <Name>8</Name> <Value>8</Value> <Message></Message> </Entry> <Entry> <Name>16</Name> <Value>16</Value> <Message></Message> </Entry> <Entry> <Name>32</Name> <Value>32</Value> <Message></Message> </Entry> <Entry> <Name>64</Name> <Value>64</Value> <Message></Message> </Entry> <Entry> <Name>128</Name> <Value>128</Value> <Message></Message> </Entry> </Menu> </Option> </TestSettings> </PhoronixTestSuite>