adamrunner · August 29, 2015 13:56
diff --git a/slow_query.sh b/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; }'
	# 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; }'