From: Prabhat Kumar Date: April 20 2010 2:01pm Subject: Re: tcpdump mysql ? List-Archive: http://lists.mysql.com/mysql/221318 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00163630fd53b52d760484ab825a --00163630fd53b52d760484ab825a Content-Type: text/plain; charset=ISO-8859-1 http://www.mysqlperformanceblog.com/2008/11/07/poor-mans-query-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@stripped > -- 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--