Simple script to measure the time it takes to execute a series of MySQL queries

mysql-query-time-test.sh

#!/bin/bash

user='root'
password=''

function usage() {

    echo "usage: $0 <query-file> <default-database>"
    exit 1
}

function main() {

    query_file=$1
    default_database=$2

    if [ -z "$query_file" ]; then
        echo "A query file is required"
        exit 1
    fi

    echo "Index, Query Time"

    counter=0
    tmp_file=$(mktemp /tmp/mysqltest.XXXXXX)
    cat $query_file | while read query; do
        logerr -n "Executing query #${counter} ..."
        query="SET SESSION query_cache_type = OFF; $query"
        (time mysql --user=$user --password=$password $default_database -e "$query") 2>$tmp_file >/dev/null
        [ $? -ne 0 ] && logerr "failed" && exit 1
        query_time=$(cat $tmp_file | grep "real" | egrep -o "[0-9a-z\.]+$")
        logerr " completed in $query_time"
        echo "$counter, $query_time"
        ((counter++))
    done

}

function logerr() {
    if [ -z "$2" ]; then
        >&2 echo "$1"
    else
        >&2 echo "$1" "$2"
    fi
}

if [ -z $1 ] || [ "$1" == "-h" ]; then
    usage
fi

main "$@"