Skip to content

Instantly share code, notes, and snippets.

@adamrunner

adamrunner/slow_query.sh

Forked from dcampano/Mysql slow query log quick parse
Last active August 29, 2015 13:56
Show Gist options
  • Save adamrunner/9335339 to your computer and use it in GitHub Desktop.
Save adamrunner/9335339 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slow_query.sh
# Script used to quickly get a glance of how many queries since a certain time period were longer than X seconds
# Customize these 2 parameters
STARTDATE="140303" # 2 Digit Year, 2 Digit Month, 2 Digit Day
QUERYTIME=3.0
# Runs the commands and prints out Query_time lines
FIRST=`grep -n -m 1 "# Time: $STARTDATE" slow.log | cut -d : -f 1`; TOTAL=`wc -l slow.log | cut -d ' ' -f 1`; tail -n `echo "$TOTAL-$FIRST" | bc` slow.log | grep Query_time | awk -v time="$QUERYTIME" '$3 > time {print; }'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment