http://simonwillison.net/2009-08-19T11:42:28+00:00Simon Willison2009-08-19T11:42:28+00:002009-08-19T11:42:28+00:00https://simonwillison.net/2009/Aug/19/tcpdump/#atom-tag

<p><strong><a href="http://www.xaprb.com/blog/2009/08/18/how-to-find-un-indexed-queries-in-mysql-without-using-the-log/">How to find un-indexed queries in MySQL, without using the log</a></strong></p> Use tcpdump(!) to sniff the MySQL protocol and dump out queries that had the “no index used” bit set. <p><small></small>Via <a href="http://delicious.com/mattb/maatkit+mysql+query+sql+tcpdump">Matt Biddulph</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/mysql">mysql</a>, <a href="https://simonwillison.net/tags/profiling">profiling</a>, <a href="https://simonwillison.net/tags/tcpdump">tcpdump</a></p>