How to find un-indexed queries in MySQL, without using the log
Let’s use tcpdump to capture queries, consume the output with mk-query-digest, and filter out all but ones that don’t use an index or use no good index
How to find un-indexed queries in MySQL, without using the log
Let’s use tcpdump to capture queries, consume the output with mk-query-digest, and filter out all but ones that don’t use an index or use no good index