…, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s… it. Let’s see: mk-query-digest –type=tcpdump –report-format=profile tcpdump.out # Rank Query ID Response time Calls R/Call… second? We can find out. mk-query-digest –type=tcpdump –limit 1 tcpdump.out # 460ms user time, 30ms system time, 8.88M…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
… the latest mk-query-digest Capture memcached network traffic with tcpdump Parse memcached network traffic with mk-query-digest Ponder the… 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 memc_tcpdump.txt…
Comment: Maatkit Now Supports Memcached
August 6, 2009 By 11 Comments
….com/p/maatkit/issues/detail?id=544 and that you fixed this by removing the -v option from tcpdump? Currently, the tcpdump output… need to tweak your tcpdump options to get the output correct. Any extra info will confuse the tcpdump parser and cause these…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
…, so you can analyze it easily with tools such as Maatkit‘s mk-query-digest. These tools can do a lot… with varying levels of accuracy and completeness; you can use tcpdump and some quick shell commands, for example. But with mk… easiest and best solution for most needs. Just use tcpdump and the “–type=tcpdump” option to mk-query-digest. You can even…
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…. $ /usr/sbin/tcpdump -i eth1 port 3306 -s 65535 -x -n -q -tttt | /home/rbradfor/maatkit-4790/bin/mk-query-digest –type tcpdump
Comment: Gathering queries from a server with Maatkit and tcpdump
July 2, 2009 By 23 Comments
… do with the reality of how this was developed. The Maatkit team (basically me, Daniel and Jeff Stoner, plus other occasional… know anything about the plans for Maatkit, I’ve spent literally days crafting roadmaps on the Maatkit wiki. Go look. I feel… the server start it afresh, and if you use the –tcpdump-errors option, the packets that led to the confusion will…
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… than upgrade from MySQL 5.0 to 5.1 Also, Maatkit is Awesome, though I believe you know already.
Post: Percona is hiring a consultant
December 16, 2009 By 7 Comments
… to be able to use tools such as gdb, strace, tcpdump, etc to solve weird problems. Expert with Apache, memcached, and… a variety of popular open-source server software. Proficient with Maatkit and MMM. Proven success working in a distributed environment where…
Comment: Tools
June 1, 2008 By 31 Comments
… processes memory usage, this is your tool – strace, ltrace, gdb, tcpdump, … for hard problems Also, I tend to prefer htop over… list of tables/indexes/… locked by those requests, etc. ps: maatkit may be useful, but lack some polish (ie. he tends…
