Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created February 13, 2023 19:07
Show Gist options
  • Save mdcallag/b5374e24ad480a1a6bd6d6e81211c560 to your computer and use it in GitHub Desktop.
Save mdcallag/b5374e24ad480a1a6bd6d6e81211c560 to your computer and use it in GitHub Desktop.
ntabs=$1
nrows=$2
nsecs=$3
basedir=$4
sysbdir=$5
datadir=$6
devname=$7
usepk=$8
prepstmt=$9
# Remaining args are numbers of threads for which to run benchmarks, "1 2 4"
shift 9
function dbms_up() {
bdir=$1
cnf=$2
# /media/ephemeral1 or /home/mdcallag/d or ???
cdir=$PWD
cd $bdir; bash ini.sh $cnf >& o.ini; sleep 10; cd $cdir
}
function dbms_down() {
bdir=$1
cnf=$2
cdir=$PWD
cd $bdir; bash down.sh $cnf >& o.down; cd $cdir
}
dbcreds=mysql,root,pw,127.0.0.1,test,innodb
#for dcnf in my8031.y9_128gram_64kiops ; do
for dcnf in my8031.y9_128gram_64kiops my8031_archnative.y9_128gram_64kiops my8032.y9_128gram_64kiops my8032_archnative.y9_128gram_64kiops ; do
dbms=$( echo $dcnf | tr '.' ' ' | awk '{ print $1 }' )
cnf=$( echo $dcnf | tr '.' ' ' | awk '{ print $2 }' )
dbdir=$basedir/$dbms
client=$dbdir/bin/mysql
echo Run for $dbms with $cnf config from $dbdir
dbms_up $dbdir $cnf
bash all_small.sh $ntabs $nrows $nsecs $nsecs $nsecs $dbcreds 1 0 $client none $sysbdir $datadir $devname $usepk $prepstmt $@
mkdir x.$dcnf.pk${usepk}; mv sb.* x.$dcnf.pk${usepk}; cp $dbdir/etc/my.cnf $dbdir/o.ini* x.$dcnf.pk${usepk}
dbms_down $dbdir $cnf
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment