Difference between revisions of "Top MySQL Slow Queries from log"
From James Dooley's Wiki
(Created page with "==Overview== Sort the slow query log based on the query time and display the lines after it ==Script== ===Display 2 lines after Query_time=== <code>[bash,n] for i in $(grep -n Q...") |
(No difference)
|
Revision as of 13:02, 15 September 2011
Contents
Overview
Sort the slow query log based on the query time and display the lines after it
Script
Display 2 lines 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 -A2 "$line" slow.log;done
Display 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 -A3 "$line" slow.log;done | less
