aggregate-results

#!/bin/bash

set -u

usage()
{
cat << EOF
usage: $0 options

This script looks for result directories (results-0, result-1, result-2, etc) created by 
run-sysbench and aggregates their output into a CSV which is sent to stdout.


OPTIONS:
   -r	Directory containing results		[./results]
EOF
}

resultsdir=./results

while getopts r: name
do
	case $name in
		r) resultsdir="$OPTARG";;
		?) usage
		   exit;;
	esac
done

printf "result,threads,transactions,trns p/s,deadlocks,dls p/s,read/write requests,r/w reqs p/s,min,avg,max,99 percentile \n"

for result in $( ls -rt $resultsdir | grep result\- | tr "\n" " " ); do

	cat $resultsdir/$result/sysbench.* | \
		egrep " cat|threads:|transactions:|deadlocks|read/write|min:|avg:|max:|percentile:" | \
		gsed '1 s/Number of threads: //' | \
		tr -d "\n" | \
		gsed -e 's/Number of threads: /\n/g' \
		-e 's/[A-Za-z\/]\{1,\}://g' \
		-e 's/read\/write//g' \
		-e 's/approx\.  99//g' \
		-e 's/per sec.)//g' \
		-e 's/ms//g' \
		-e 's/(//g' \
		-e 's/  */,/g' | \
		gawk -v d=$result '{$0=d","$0}1'
	
done