Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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} ..."
- (time mysql --user=$user --password=$password $default_database -e "$query") 2>$tmp_file >/dev/null
- [ $? -ne 0 ] && 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 "$@"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement