Simon Willison’s Weblog

How to find un-indexed queries in MySQL, without using the log (via) Use tcpdump(!) to sniff the MySQL protocol and dump out queries that had the “no index used” bit set.

# 19th August 2009, 11:42 am / mysql, profiling, tcpdump