Another trick is to reverse the domain when you store it. For example instead
of storing www.facebook.com, store it as com.facebook.www. That way you write
a query like:
WHERE domain LIKE 'com.facebook%'
This will use the index, since you're not using a wildcard at the beginning of
the stri
Getting the slow query data in the database was a breeze with
mk-query-digest, but now does anyone happen to know of scripts out
there that will generate an html page to view the output? This is
probably a better question for the maatkit mailing list but figure
someone here might have a link.
Th
