Simon Willison’s Weblog

19th August 2009 - Link Blog

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.

Posted 19th August 2009 at 11:42 am

Recent articles

Join us at PyCon US 2026 in Long Beach - we have new AI and security tracks this year - 17th April 2026
Qwen3.6-35B-A3B on my laptop drew me a better pelican than Claude Opus 4.7 - 16th April 2026
Meta's new model is Muse Spark, and meta.ai chat has some interesting tools - 8th April 2026

This is a link post by Simon Willison, posted on 19th August 2009.

mysql 81 profiling 13 tcpdump 1

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe