http://www.mysqlperformanceblog.com/2008/11/07/poor-mans-query-logging/
On Tue, Apr 20, 2010 at 7:19 PM, Keith Murphy <bmur...@paragon-cs.com>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" <brentgclarkl...@gmail.com> 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=bmur...@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