standalone_benchmark.sh

#!/bin/bash

echo 'Preparing the environement'
apt-get update
apt-get install mysql-server sysbench -y

echo 'Downloading and extract the Sakila database'
wget https://downloads.mysql.com/docs/sakila-db.tar.gz -O /home/ubuntu/sakila-db.tar.gz
tar -xvf /home/ubuntu/sakila-db.tar.gz -C /home/ubuntu/

echo 'Importing the Sakila database schema and data into MySQL'
mysql -u root -e "SOURCE /home/ubuntu/sakila-db/sakila-schema.sql;"
mysql -u root -e "SOURCE /home/ubuntu/sakila-db/sakila-data.sql;"

echo 'Preparing the database for the benchmark:'
sysbench oltp_read_write --table-size=100000 --mysql-db=sakila --mysql-user=root prepare

echo 'Running the OLTP benchmark:'
sysbench oltp_read_write --table-size=100000 --threads=6 --max-time=60 --max-requests=0 --mysql-db=sakila --mysql-user=root run > /home/ubuntu/standalone_results.txt

echo 'Clean up the database after the benchmark:'
sysbench oltp_read_write --mysql-db=sakila --mysql-user=root --my-sql-password=root cleanup