#!/bin/bash
# mysql settings
USER=benchmark
PASS=
HOST=
DB=benchmark
# number of rows to insert in test table
ROWS=1000000

function doPrepare {
sysbench --test=oltp \
--oltp-table-size=$ROWS \
--mysql-user=$USER \
--mysql-password=$PASS \
--mysql-db=$DB \
--mysql-host=$HOST \
--db-driver=mysql \
prepare
}

function doRun {
sysbench --test=oltp \
--oltp-table-size=$ROWS \
--num-threads=$1 \
--mysql-user=$USER \
--mysql-password=$PASS \
--mysql-db=$DB \
--mysql-host=$HOST \
--db-driver=mysql \
run
}

function doCleanup {
sysbench --test=oltp \
--mysql-user=$USER \
--mysql-password=$PASS \
--mysql-db=$DB \
--mysql-host=$HOST \
--db-driver=mysql \
cleanup
}

echo "Running through test sequences. "

# loop the work
for i in 6 8 10 24 32 64 128; do
    echo "sysbench prepare. Creating $ROWS rows. "
    doPrepare
    echo "sysbench run. Running $i threads. "
    doRun $i
    echo "sysbench cleanup. "
    doCleanup
done
echo "Completed execution. "