MySQL 1.0.0

system/mysql-1.0.0 - 16 October 2021 - Pull system MySQL version from https://github.com/phoronix-test-suite/test-profiles/pull/208 It seems to be a hot mess, made some improvements, but likely will fail for most so mark as status "Broken" so at least won't show by default.

downloads.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.6.1-->
<PhoronixTestSuite>
  <Downloads>
    <Package>
      <URL>https://github.com/akopytov/sysbench/archive/1.0.20/sysbench-1.0.20.tar.gz</URL>
      <MD5>756381c6fc4e16af1e0831b5e6a3dcb3</MD5>
      <SHA256>e8ee79b1f399b2d167e6a90de52ccc90e52408f7ade1b9b7135727efe181347f</SHA256>
      <FileName>sysbench-1.0.20.tar.gz</FileName>
      <FileSize>1509630</FileSize>
      <PlatformSpecific>Linux</PlatformSpecific>
    </Package>
  </Downloads>
</PhoronixTestSuite>

install.sh

#!/bin/sh
if which mysqld>/dev/null 2>&1 ;
then
	echo 0 > ~/install-exit-status
else
	echo "ERROR: mysql server is not found on the system!"
	echo 2 > ~/install-exit-status
fi

echo "diff --git a/tests/test_run.sh b/tests/test_run.sh
index 669ed751..17ef0fac 100755
--- a/tests/test_run.sh
+++ b/tests/test_run.sh
@@ -86,6 +86,9 @@ export LUA_PATH
 if \$(command -v python >/dev/null 2>&1)
 then
     PYTHON=python
+elif \$(command -v python3 >/dev/null 2>&1)
+then
+    PYTHON=python3
 elif \$(command -v python2 >/dev/null 2>&1)
 then
     PYTHON=python2
" > sysbench-1.0.20-python3.patch

tar -xzf sysbench-1.0.20.tar.gz
cd sysbench-1.0.20
patch -p1 < ../sysbench-1.0.20-python3.patch
autoreconf -vif
./configure --with-mysql --without-gcc-arch
make -j
echo $? > ~/install-exit-status

cd $HOME

echo "#!/bin/sh
table_num=30
table_size=600000
db_pswd=hellomysql123
CORE_NUMS=\$[\$NUM_CPU_CORES * 5]
if [\$CORE_NUMS -ge 100]; then
    CORE_NUMS=\$NUM_CPU_CORES
fi
cd sysbench-1.0.20
./src/sysbench \$HOME/sysbench-1.0.20/src/lua/oltp_read_write.lua \\
                        --mysql-host=127.0.0.1 \\
                        --mysql-port=3306 \\
                        --mysql-user=test \\
                        --mysql-password=\$db_pswd \\
                        --mysql-db=test \\
                        --db-driver=mysql \\
                        --tables=\$table_num \\
                        --table-size=\$table_size \\
                        --report-interval=10 \\
                        --threads=\$NUM_CPU_CORES \\
                        prepare
echo 3 > /proc/sys/vm/drop_caches
./src/sysbench \$HOME/sysbench-1.0.20/src/lua/oltp_read_write.lua \\
                        --mysql-host=127.0.0.1 \\
                        --mysql-port=3306 \\
                        --mysql-user=test \\
                        --mysql-password=\$db_pswd \\
                        --mysql-db=test \\
                        --db-driver=mysql \\
                        --tables=\$table_num \\
                        --table-size=\$table_size \\
                        --report-interval=10 \\
                        --threads=\$CORE_NUMS \\
                        --time=120 \\
                        run > \$LOG_FILE 2>&1
./src/sysbench \$HOME/sysbench-1.0.20/src/lua/oltp_read_write.lua \\
                        --mysql-host=127.0.0.1 \\
                        --mysql-port=3306 \\
                        --mysql-user=test \\
                        --mysql-password=\$db_pswd \\
                        --mysql-db=test \\
                        --db-driver=mysql \\
                        --tables=\$table_num \\
                        --table-size=\$table_size \\
                        --report-interval=10 \\
                        --threads=\$NUM_CPU_CORES \\
                        cleanup
echo 3 > /proc/sys/vm/drop_caches

mysqld --version > ~/pts-footnote 2>/dev/null
" > mysql
chmod +x mysql

post.sh

#!/bin/sh
set -x
# create random password
# PASSWDDB="$(openssl rand -base64 12)"
PASSWDDB="hellomysql123"

# replace "-" with "_" for database username
# MAINDB=${USER_NAME//[^a-zA-Z0-9]/_}
MAINDB="test"

mysql -u root <<MYSQL_SCRIPT
DROP DATABASE IF EXISTS ${MAINDB} /*\!40100 DEFAULT CHARACTER SET utf8 */;
MYSQL_SCRIPT

ps cax | grep mysqld
if [ $? -eq 0 ]; then
    echo "mysql server is running."
    systemctl stop mysqld.service
else
    echo "mysql server is not running."
fi
rm -rf /var/lib/mysql/*

pre.sh

#!/bin/sh
set -x
ps cax | grep mysqld
if [ $? -eq 0 ]; then
    echo "mysql server is running."
else
    echo "mysql server is not running."
    systemctl start mysqld.service
fi
# create random password
# PASSWDDB="$(openssl rand -base64 12)"
PASSWDDB="hellomysql123"

# replace "-" with "_" for database username
# MAINDB=${USER_NAME//[^a-zA-Z0-9]/_}
MAINDB="test"

mysql -u root <<MYSQL_SCRIPT
use mysql;
set global time_zone = '+8:00';
set time_zone = '+8:00';
set global max_connect_errors = 655350;
set global max_prepared_stmt_count=1000000;
SET GLOBAL max_connections = 10000;
CREATE DATABASE IF NOT EXISTS ${MAINDB} /*\!40100 DEFAULT CHARACTER SET utf8 */;
CREATE USER IF NOT EXISTS ${MAINDB}@localhost IDENTIFIED BY '${PASSWDDB}';
GRANT ALL PRIVILEGES ON ${MAINDB}.* TO '${MAINDB}'@'localhost';
FLUSH PRIVILEGES;
MYSQL_SCRIPT

results-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.6.1-->
<PhoronixTestSuite>
  <ResultsParser>
    <OutputTemplate>transactions:                        12853  (#_RESULT_# per sec.)</OutputTemplate>
    <LineHint>transactions</LineHint>
    <ResultScale>Transactions Per Second</ResultScale>
    <ResultProportion>HIB</ResultProportion>
  </ResultsParser>
</PhoronixTestSuite>

test-definition.xml

<?xml version="1.0"?>
<!--Phoronix Test Suite v10.6.1-->
<PhoronixTestSuite>
  <TestInformation>
    <Title>MySQL</Title>
    <Description>This is a benchmark of the system's built-in MySQL/MariaDB server. MySQL must be accessible in order for this test profile to work.</Description>
    <ResultScale>Transactions Per Second</ResultScale>
    <Proportion>HIB</Proportion>
    <TimesToRun>3</TimesToRun>
  </TestInformation>
  <TestProfile>
    <Version>1.0.0</Version>
    <SupportedPlatforms>Linux</SupportedPlatforms>
    <SoftwareType>Utility</SoftwareType>
    <TestType>System</TestType>
    <License>Free</License>
    <Status>Broken</Status>
    <ExternalDependencies>build-utilities, libtool, libaio-development, python</ExternalDependencies>
    <RequiresRoot>TRUE</RequiresRoot>
    <EnvironmentSize>30</EnvironmentSize>
    <ProjectURL>https://github.com/akopytov/sysbench</ProjectURL>
    <SystemDependencies>mysqld, mysql, sysbench</SystemDependencies>
  </TestProfile>
</PhoronixTestSuite>