Running Sysbench on MySQL

The following script is used to run sysbench on MySQL

#!/bin/bash

# Database connection details
DB_USER="your_username"
DB_PASSWORD="your_password"
DB_NAME="your_database"

# Number of threads to use for the benchmark
NUM_THREADS=4

# Number of requests to perform
NUM_REQUESTS=10000

# Cleanup any previous test data
sysbench --db-driver=mysql --mysql-user=$DB_USER --mysql-password=$DB_PASSWORD --mysql-db=$DB_NAME oltp_read_write cleanup

# Prepare the test environment
sysbench --db-driver=mysql --mysql-user=$DB_USER --mysql-password=$DB_PASSWORD --mysql-db=$DB_NAME oltp_read_write prepare

# Run the benchmark
sysbench --db-driver=mysql --mysql-user=$DB_USER --mysql-password=$DB_PASSWORD --mysql-db=$DB_NAME --threads=$NUM_THREADS --time=60 --report-interval=10 oltp_read_write run

# Cleanup test data
sysbench --db-driver=mysql --mysql-user=$DB_USER --mysql-password=$DB_PASSWORD --mysql-db=$DB_NAME oltp_read_write cleanup