I tried getting the following command running from the following youtube
Look at 19:25
I know I can use tcpdump, with maatkit (Im not always able to install
maatkit on clients machines). But based on whats above in the clip, Did
Mr Callaghan make a typo or leave something out.
This is the command as I understand it.
tcpdump -c 1000000 -s 1000 -A -n -p port 3306 | grep SELECT | sed
's/\/\*.*\*\///g' | sed 's/.*\(SELECT.*\)/\1/gI' | sort | uniq -c | sort
-r -n -k 1,1 | head -5
Other question is. What commnds do you use to help debuging and testing.