MySQL Sysbench 1.1.0

tag3r1s/sysbench-1.1.0 - 17 May 2018 - Test profile improvements

install.sh

#!/bin/sh

mysqlversion=mariadb-10.3.6
version=1.0.14

rm -rf $HOME/mysql_ $HOME/sysbench_ $HOME/server-${mysqlversion} $HOME/sysbench-${version}

git clone --branch ${mysqlversion} https://github.com/MariaDB/server.git server-${mysqlversion}

mkdir -p $HOME/mysql_
cd $HOME/server-${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

git clone --branch ${version} https://github.com/akopytov/sysbench.git sysbench-${version}

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/server-${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.1.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, git
    </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>