- C-a == Ctrl-a
- M-a == Alt-a
:q close
:w write/saves
:wa[!] write/save all windows [force]
:wq write/save and close
# 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; }' |