#!/bin/sh

DIR=/usr/BENCH
export PATH=${DIR}/bin:$PATH
OUT=/mnt/SHOOT_OUT/`uname`/`date +%Y-%m-%d-%T|tr ":" "_"`
mkdir -p ${OUT}
df > ${OUT}/df
ulimit -a > ${OUT}/ulimit
dmesg > ${OUT}/dmesg
uname -a > ${OUT}/uname
sysctl -a > ${OUT}/sysctl

echo "drop database sbtest;"|mysql
echo "create database sbtest;"|mysql
pkill -9 mysqld
${DIR}/bin/mysqld_safe &
sleep 10
sysbench --test=oltp --mysql-user=root --max-time=120 --max-requests=0 --oltp-read-only=on prepare
echo "Warming mysql up"
sysbench --test=oltp --num-threads=8 --mysql-user=root --max-time=120 --max-requests=0 --oltp-read-only=on run > /dev/null
echo "Running Mysql tests"
for threads in 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
do
echo "doing ${threads}"
sysbench --test=oltp --num-threads=${threads} --mysql-user=root --max-time=120 --max-requests=0 --oltp-read-only=on run > ${OUT}/sysbench_mysql_threads_${threads}
done