tcpdump mysql ?

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=gcdmg-mysql-2@m.gmane.org

Re: tcpdump mysql ?

--000e0cd631844781720484ab58af
Content-Type: text/plain; charset=ISO-8859-1

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" 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=bmurphy@paragon-cs.com

--000e0cd631844781720484ab58af--

Re: tcpdump mysql ?

--00163630fd53b52d760484ab825a
Content-Type: text/plain; charset=ISO-8859-1

http://www.mysqlperformanceblog.com/2008/11/07/poor-mans-que ry-logging/

On Tue, Apr 20, 2010 at 7:19 PM, Keith Murphy wrote:

> 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" 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=bmurphy@paragon-cs.com
>



--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--00163630fd53b52d760484ab825a--