TiDB Community Server 1.0.2

pts/tidb-1.0.2 - 07 September 2023 - Initial commit of TiDB database benchmark using sysbench.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.8.4-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://download.pingcap.org/tidb-community-server-v7.3.0-linux-amd64.tar.gz</URL>
      <MD5>51d222db90a8a1f5023b54db51d98fa2</MD5>
      <SHA256>6491d1269932e20d496a5020eb491eada9cb8b2e0493e2886ba58580cb856615</SHA256>
      <FileName>tidb-community-server-v7.3.0-linux-amd64.tar.gz</FileName>
      <FileSize>1421799028</FileSize>
      <ArchitectureSpecific>x86_64</ArchitectureSpecific>
    </Package>
    <Package>
      <URL>https://download.pingcap.org/tidb-community-server-v7.3.0-linux-arm64.tar.gz</URL>
      <MD5>bf1a75515fdaf473981c56d2a325be57</MD5>
      <SHA256>8a54f4feb85228816eda1cbef8195962269637655100ce64dc1db5319640b804</SHA256>
      <FileName>tidb-community-server-v7.3.0-linux-arm64.tar.gz</FileName>
      <FileSize>1376926349</FileSize>
      <ArchitectureSpecific>aarch64</ArchitectureSpecific>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh
rm -rf tidb-community-server
if [ $OS_ARCH = "aarch64" ]
then
	tar -xf tidb-community-server-v7.3.0-linux-arm64.tar.gz
	mv tidb-community-server-v7.3.0-linux-arm64/ tidb-community-server
elif [ $OS_ARCH = "x86_64" ]
then
	tar -xf tidb-community-server-v7.3.0-linux-amd64.tar.gz
	mv tidb-community-server-v7.3.0-linux-amd64/ tidb-community-server
else
	echo "ERROR: Not a supported platform..." > $LOG_FILE
	echo 2 > ~/install-exit-status
	exit 2
fi
cd tidb-community-server
./local_install.sh
source $HOME/.profile
export PATH=$HOME/.tiup/bin:$PATH
mkdir -p $DEBUG_REAL_HOME/.tiup/bin/
cp -f $HOME/.tiup/bin/root.json $DEBUG_REAL_HOME/.tiup/bin/
tiup install v7.3.0
tiup playground v7.3.0 &
TIUP_PID=$!
sleep 15
echo "DROP DATABASE sbtest;" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
echo "CREATE DATABASE sbtest;" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
sysbench oltp_common --threads=$NUM_CPU_CORES --rand-type=uniform --db-driver=mysql --mysql-db=sbtest --mysql-host=127.0.0.1 --mysql-port=4000 --mysql-user=root prepare --tables=16 --table-size=1000000
mysqldump sbtest --host 127.0.0.1 --port 4000 -u root > ~/mysql-dumped
echo $? > ~/install-exit-status
echo "DROP DATABASE sbtest;" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
kill -9 $TIUP_PID
killall -9 tidb-server
killall -9 tikv-server
killall -9 tiup-playground

cd ~
echo "#!/bin/sh
export PATH=\$HOME/.tiup/bin:\$PATH
tiup playground v7.3.0 &
TIUP_PID=\$!
sleep 10

echo \"DROP DATABASE sbtest;\" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
echo \"CREATE DATABASE sbtest;\" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
mysql  --host 127.0.0.1 --port 4000 -u root sbtest < ~/mysql-dumped 
sleep 3

sysbench \$1 --threads=\$2 --time=300 --rand-type=uniform --db-driver=mysql --mysql-db=sbtest --mysql-host=127.0.0.1 --mysql-port=4000 --mysql-user=root run --tables=16 --table-size=1000000 > \$LOG_FILE 2>&1
echo \$? > ~/test-exit-status

echo \"DROP DATABASE sbtest;\" |  mysql --comments --host 127.0.0.1 --port 4000 -u root
kill -9 \$TIUP_PID
killall -9 tidb-server
killall -9 tikv-server
killall -9 tiup-playground" > tidb
chmod +x tidb

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>TiDB Community Server</Title>
    <AppVersion>7.3</AppVersion>
    <Description>This is a PingCAP TiDB Community Server benchmark facilitated using the sysbench OLTP database benchmarks.</Description>
    <ResultScale>Queries Per Second</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.0.2</Version>
    <SupportedPlatforms>Linux</SupportedPlatforms>
    <SoftwareType>Benchmark</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Verified</Status>
    <EnvironmentSize>6900</EnvironmentSize>
    <ProjectURL>https://www.pingcap.com/tidb/</ProjectURL>
    <RepositoryURL>https://github.com/pingcap/tidb</RepositoryURL>
    <Maintainer>Michael Larabel</Maintainer>
    <SystemDependencies>mysql, mysqldump, 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_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>1024</Name>
          <Value>1024</Value>
        </Entry>
      </Menu>
    </Option>
  </TestSettings>
</PhoronixTestSuite>