…. I used mk-query-digest (with some new features) to watch the traffic on the active master and replay SELECT queries against the passive… 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} =~ m…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…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-… different status in Show Processlist depending on if it processes query or simply waiting. By pooling processlist frequently (for example 10 …
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
… processlist‘ > /root/tcpdumps/`date +%s`-innodbstatus pid=$! sleep 30 kill ${pid} fi If this captures anything, then you can simply run “mk-query-digest –type=tcpdump –no-report –print” on the resulting tcpdump file (after inspecting the captured SHOW INNODB STATUS and SHOW PROCESSLIST to…
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 with… of SF-MySQL meetup folks for a sudden interest in mk-query-digest. thanks & keep up the good work. erin
Post: Cache Miss Storm
September 10, 2010 By 29 Comments
… Same query was taking large portion of slots in PROCESSLIST. I do not just mean query with same fingerprint but literally the same query… miss. To find first one for memcached you can use mk-query-digest to analyze which items are requested frequently, it can decode… starting populating it. For MySQL Query Cache the solution should have been to make queries wait on first query started to complete. Unfortunately…
