List:General Discussion« Previous MessageNext Message »
From:Keith Murphy Date:April 20 2010 1:49pm
Subject:Re: tcpdump mysql ?
View as plain text  
You should look at www.hackmysql.com. He has a sniffed program strictly for
Mysql. Should do what you want.

HTH

Keith

On Apr 20, 2010 5:48 AM, "Brent Clark" <brentgclarklist@stripped> wrote:

Hiya

I tried getting the following command running from the following youtube
clip.

http://www.youtube.com/watch?v=Zofzid6xIZ4
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.

Kind Regards
Brent Clark

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
tcpdump mysql ?Brent Clark20 Apr
  • Re: tcpdump mysql ?Keith Murphy20 Apr
    • Re: tcpdump mysql ?Prabhat Kumar20 Apr