svfes_localbench.sh

svfes_localbench.sh

#!/bin/bash

set -e

echo "## RUN BENCH"
echo `date`

service mysql restart
sleep 2
service mysql stop
cd ~
echo `date`

echo "3" > /proc/sys/vm/drop_caches

rm -rf /fioa/mysql
cp -a  /fioa/mysql.orig /fioa/mysql
echo `date`

sync
echo "3" > /proc/sys/vm/drop_caches

service mysql start
echo `date`

cd ~/tpcc-mysql
cat /etc/my.cnf.d/server.cnf
time ./tpcc_start -h 127.0.0.1 -d tpcc -u root -p "" -w 1000 -c 30 -l 900 -i 60 -r 0
echo `date`