And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote:
> Questions Folks:
> (1) What do you about un-index searches. How can one report and monitor them?
> (2) What do you do with the slow-query log. Are there any utilities or
> s
See
log-queries-not-using-indexes
option in my.cnf, used with the slow log.
http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html
Regards,
Gavin Towey
-Original Message-
From: Brown, Charles [mailto:cbr...@bmi.com]
Sent: Monday, October 05, 2009 12:59 PM
To: Mysql List
Cc: John M