#!/bin/sh


#==============================================================================#

VERSION="v2021041400"           # universell umgebaut


if [ "x${2}" = x ] ; then
        echo "${0} [Hostname] [Port]"
        echo "${0} 127.0.0.1 3306"
        exit 10
else
        MYSQL_HOST="${1}"
        MYSQL_PORT="${2}"
fi

#==============================================================================#

#------------------------------------------------------------------------------#

MYSQL_USR=root                  # Voreinstellung: sbtest
MYSQL_PWD="$(echo Z2VoZWltCg== | base64 -d)"
MYSQL_DB=test                   # Voreinstellung: sbtest
MAX_REQUESTS=10000
MAX_TIME=120

DIE_TESTS="cpu memory threads mutex"
THREADS="2 4 6 8 16 32 64 128 256 512"

#------------------------------------------------------------------------------#

for TEST in ${DIE_TESTS}
do
        echo "================================================================================"
        for i in ${THREADS}
        do
                #AUSGABE="$(sysbench --num-threads=${i} --max-requests=${MAX_REQUESTS} --max-time=${MAX_TIME} --mysql-host=${MYSQL_HOST} --mysql-db=${MYSQL_DB} --mysql-port=${MYSQL_PORT} --mysql-user=${MYSQL_USR} --mysql-password=${MYSQL_PWD} --test=${TEST} run)"
                #echo "sysbench --threads=${i} --events=${MAX_REQUESTS} --time=${MAX_TIME} --mysql-host=${MYSQL_HOST} --mysql-db=${MYSQL_DB} --mysql-port=${MYSQL_PORT} --mysql-user=${MYSQL_USR} --mysql-password=${MYSQL_PWD} ${TEST} run"
                AUSGABE="$(sysbench --threads=${i} --events=${MAX_REQUESTS} --time=${MAX_TIME} --mysql-host=${MYSQL_HOST} --mysql-db=${MYSQL_DB} --mysql-port=${MYSQL_PORT} --mysql-user=${MYSQL_USR} --mysql-password=${MYSQL_PWD} ${TEST} run)"

                if [ "memory" = "${TEST}" ] ; then
                        echo "${AUSGABE}" | egrep '^### threads=| transferred ' | awk -F"[()]" -v threads=${i} -v test=${TEST} '{print test,"/",threads,"threads / transferred:",$2}'
                elif [ "threads" = "${TEST}" ] ; then
                        echo "${AUSGABE}" | egrep '^### threads=|execution time' | awk -v threads=${i} -v test=${TEST} '{gsub("/"," ");print test,"/",threads,"threads / execution time:",$(NF-1)}'
                else
                        #echo "${AUSGABE}" | egrep '^### threads=|approx.  95 percentile:' | awk -v threads=${i} -v test=${TEST} '{print test,"/",threads,"threads / Laufzeit von 95%:",$NF}'
                        echo "${AUSGABE}" | egrep '^### threads=|95th percentile:' | awk -v threads=${i} -v test=${TEST} '{print test,"/",threads,"threads / Laufzeit von 95%:",$NF}'
                fi
        done
done