… mk-query-digest output was obviously bogus when compared to the host’s slow-query-log (for example, none of the top 5 slow queries…: use “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than the servers long-query-time…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
… with mk-query-digest Ponder the results, or consider a different –report option In code: wget http://maatkit.googlecode.com/svn/trunk/mk-query-digest/mk-query-digest sudo tcpdump -s 65535 -x -n -q -tttt -i eth0 port 11211 > memc_tcpdump.txt mk-query-digest –type memcached…
Comment: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
I have root@lb2:~# ./mk-query-digest –type memcached memc_tcpdump.txt # mk_query_digest:6381 6920 Use of uninitialized value in string eq at ./mk-query-digest line 5363, chunk 1. # # mk_query_digest:6381 6920 Use of uninitialized value in string eq at ./mk-query-digest line 5363, chunk 2. #
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… other interval of your choice. 2) Use full slow query log and mk-query-digest. This method is great for one time execution especially… include all queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…. I used mk-query-digest (with some new features) to watch the traffic on the active master and replay SELECT queries against the passive one. I timed the results and ran them through the analysis part of mk-query-digest. A simple… on the slave. Then I used mk-query-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg…
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… then sniff TCP traffic for a while, use mk-query-digest to convert this into a query log, and examine the log. In MySQL…} fi If this captures anything, then you can simply run “mk-query-digest –type=tcpdump –no-report –print” on the resulting tcpdump file… feature in mk-query-digest, which prints out a sequence of queries in an easy-to-view format, rather than aggregating the worst queries together…
Comment: Maatkit Now Supports Memcached
July 30, 2009 By 11 Comments
When I try to use it, it just gives lots of these lines: ./mk-query-digest –type memcached memc_tcpdump.txt # mk_query_digest:6758 5136 tell() on closed filehandle at ./mk-query-digest line 2019.
Comment: Gathering queries from a server with Maatkit and tcpdump
July 2, 2009 By 23 Comments
… 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… 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
… slaves at the same position again and used tcpdump and mk-query-digest to get sample read traffic from both master and slave… 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: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…, enabled full query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query-digest report: # Overall… more interesting to look at Per-query information from mk-query digest (I omit queries text for client privacy) # Query 1: 0 QPS, 0x concurrency, ID…
