#!/bin/bash

run="mariadb-10.3";
MYSQL_SOCK="--socket=/tmp/mysql20.sock"
MYSQL=/home/ubuntu//mariadb-10.3/client/mysql
engine=rocksdb
#engine=innodb

#for engine in rocksdb innodb ; 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=/var/lib/mysql/mysql.sock --mysql-user=root --mysql_storage_engine=$engine    prepare
#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

threads=10

sysbench /usr/share/sysbench/oltp_update_non_index.lua --table-size=1000000 --threads=$threads --time=60 --rand-type=uniform --db-driver=mysql --mysql-socket=/tmp/mysql20.sock --mysql-user=root --mysql_storage_engine=$engine prepare

$MYSQL $MYSQL_SOCK -uroot -A sbtest -e "select version();"
$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 20 50 80 100 150 ; do 

sysbench /usr/share/sysbench/oltp_update_non_index.lua --table-size=1000000 --threads=$threads --time=60 --rand-type=uniform --db-driver=mysql --mysql-socket=/tmp/mysql20.sock --mysql-user=root --mysql_storage_engine=$engine run | tee out-${run}_${engine}_${threads}.txt

sleep 10;
done
# done