Bug #3274 Slow query log and no index log
Submitted: 23 Mar 2004 14:03 Modified: 21 Dec 2005 12:35
Reporter: Donny Simonton Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.1.1 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[23 Mar 2004 14:03] Donny Simonton 
Description:
We are using the slow query log and we also have the option turned on to log all queries that don't use an index.  It would be nice if there was a way that we could either put them in different log files, or have them marked in the slow query log that they were because they didn't use an index.

How to repeat:
It's a feature request, not a bug.
[21 Dec 2005 12:35] Valeriy Kravchuk 
Thank you for a feature request. Why not just to run EXPLAIN for queries from the slow log? There are may be other reasons for queries to be slow, even when indexes are used (improper index usage, for example). And, by the way, some queries will not use indexes anyway, and are neither slow nor a problem to be written to any log. So, I think, current logs are enough to pinpoint problematic queries.