Top MySQL Slow Queries from log
From James Dooley's Wiki
Contents
Overview
Sort the slow query log based on the query time and display the lines after it
Script
Display 2 lines before/after Query_time
[bash,n]
for i in $(grep -n Query_time /home/mysql/slow.log | sort -k3 -nr | head | cut -d: -f1); do line=`sed -n \`echo $i\`p /home/mysql/slow.log`; grep -B2 -A2 "$line" /home/mysql/slow.log;done
Display 2 lines before and 3 lines after Query_time | less
[bash,n]
for i in $(grep -n Query_time /home/mysql/slow.log | sort -k3 -nr | head | cut -d: -f1); do line=`sed -n \`echo $i\`p /home/mysql/slow.log`; grep -B2 -A3 "$line" /home/mysql/slow.log;done | less
