#!/bin/bash

run="run6-mariadb-again";
MYSQL_SOCK="--socket=/tmp/mysql.sock"

for engine in innodb rocksdb ; do 

mysql $MYSQL_SOCK -uroot -A -e "drop database if exists sbtest;"
mysql $MYSQL_SOCK -uroot -A -e "flush binary logs;"
mysql $MYSQL_SOCK -uroot -A -e "purge binary logs before now();"
mysql $MYSQL_SOCK -uroot -A -e "create database sbtest;"
echo "Preparing for engine $engine"
sysbench /usr/share/sysbench/oltp_point_select.lua --table-size=5000000 --threads=1 --rand-type=uniform --db-driver=mysql --mysql-socket=/tmp/mysql.sock --mysql-user=root --mysql_storage_engine=$engine    prepare

mysql $MYSQL_SOCK -uroot -A sbtest -e "show table status like 'sbtest1'\G"
mysql $MYSQL_SOCK -uroot -A sbtest -e "show variables like '${engine}%'"
mysql $MYSQL_SOCK -uroot -A sbtest -e "show variables like 'log_bin%'"
mysql $MYSQL_SOCK -uroot -A sbtest -e "show variables like 'sync_binlog'"

for threads in 100 150 200 ; do 

sysbench /usr/share/sysbench/oltp_point_select.lua --table-size=5000000 --threads=$threads --time=180 --rand-type=uniform --db-driver=mysql --mysql-socket=/tmp/mysql.sock --mysql-user=root run | tee ${run}_${engine}_${threads}.txt

sleep 10;
done
done