… of mk-query-digest but I’ve been using it with processlist. Just yesterday I was exploring tcpdump and wondering how to use mk-query-digest with… of SF-MySQL meetup folks for a sudden interest in mk-query-digest. thanks & keep up the good work. erin
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… stopped both slaves at the same position again and used tcpdump and mk-query-digest to get sample read traffic from both master and… of samples for each query type – otherwise it can take a lot of time. Running mk-upgrade with these queries showed some results differences which turned out to be false positives too – thanks to TABLE CHECKSUM mk-upgrade…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… backup of the database and get query log (you can use mk-query-digest with tcpdump to sniff out queries if you can’t enable log… and set of queries which is representative enough you should set it up on 2 same boxes and use mk-upgrade tool to run comparison. The tool will run SELECT queries on both new and old…
Comment: Gathering queries from a server with Maatkit and tcpdump
August 30, 2009 By 23 Comments
… tcpdump host 192.168.84.22 and 192.168.84.146 -x -n -q -tttt > tcp.dmp I run a few querie on client(192.168.84.146), quit, and cancel tcpdump,Now I’ve got a file(tcp.dmp) and I’m ready to analyze it $ mk-query-digest –type=tcpdump –limit 1…
Comment: Gathering queries from a server with Maatkit and tcpdump
October 15, 2009 By 23 Comments
… 65535, 32767 and even 0, all with the same error. tcpdump: invalid snaplen 65535 # number being what was passed. Command used was. $ /usr/sbin/tcpdump -i eth1 port 3306 -s 65535 -x -n -q -tttt | /home/rbradfor/maatkit-4790/bin/mk-query-digest –type tcpdump
