… as the slow-query-log format, so you can analyze it easily with tools such as Maatkit’s mk-query-digest. These tools can… SQL to analyze the queries; but this is quite a bit harder, because similar queries need to be “fingerprinted,” which is impractical or… the “–type=tcpdump” option to mk-query-digest. You can even make it print out a “slow query log file” format with the “–print…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 9 Comments
… –report and –group-by, which is “fingerprint” just like for slow query logs. So the fingerprint for this event is “get TEST_KEY….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…
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…
