Top MySQL Slow Queries from log - Revision history

Smsldoo at 14:29, 25 March 2014

2014-03-25T14:29:10Z

Smsldoo at 17:40, 17 February 2012

2012-02-17T17:40:00Z

Smsldoo: /* Display 2 lines before and 3 lines after Query_time | less */

2011-09-15T14:35:25Z

‎Display 2 lines before and 3 lines after Query_time | less

Smsldoo: /* Display 2 lines before/after Query_time */

2011-09-15T14:34:11Z

‎Display 2 lines before/after Query_time

Smsldoo: /* Script */

2011-09-15T14:23:25Z

‎Script

Smsldoo: 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=== `[bash,n] for i in $(grep -n Q..."`


2011-09-15T13:02:47Z
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..."
New page
==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 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

</code>



===Display 3 lines after Query_time | less===

<code>[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

</code>

@@ Line 5: / Line 5: @@
 ==Script==
 ===Display 2 lines before/after Query_time===
-<code>[bash,n]
+<source lang='bash'>
 slowlog=`grep log-slow-queries /etc/my.cnf | cut -d'=' -f2`; \
 if [ -e "$slowlog" ]; then \
 for i in $(grep -n Query_time $slowlog | sort -k3 -nr | head | cut -d: -f1); do line=`sed -n \`echo $i\`p $slowlog`; grep -B2 -A2 "$line" $slowlog;done; \
 fi
-</code>
+</source>
 ===Display 2 lines before and 3 lines after Query_time | less===
-<code>[bash,n]
+<source lang='bash'>
 slowlog=`grep log-slow-queries /etc/my.cnf | cut -d'=' -f2`; \
 if [ -e "$slowlog" ]; then \
 for i in $(grep -n Query_time $slowlog | sort -k3 -nr | head | cut -d: -f1); do line=`sed -n \`echo $i\`p $slowlog`; grep -B2 -A3 "$line" $slowlog;done \
 fi | less
-</code>
+</source>

← Older revision		Revision as of 17:40, 17 February 2012
Line 1:		Line 1:
		+	[[Category:One Liners]]
	==Overview==		==Overview==
	Sort the slow query log based on the query time and display the lines after it		Sort the slow query log based on the query time and display the lines after it

@@ Line 13: / Line 13: @@
 ===Display 2 lines before and 3 lines after Query_time | less===
 <code>[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
+slowlog=`grep log-slow-queries /etc/my.cnf | cut -d'=' -f2`; \
 </code>

@@ Line 5: / Line 5: @@
 ===Display 2 lines before/after Query_time===
 <code>[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
+slowlog=`grep log-slow-queries /etc/my.cnf | cut -d'=' -f2`; \
 </code>