Bug #32574 log-queries-not-using-indexes log entries difficult to distinguish in log
Submitted: 21 Nov 2007 13:42
Reporter: Giles McArdell Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0 OS:Any (All)
Assigned to: CPU Architecture:Any
Tags: log-queries-not-using-indexes, slow log
Triage: D5 (Feature request)

[21 Nov 2007 13:42] Giles McArdell
Description:
Log entries created using log-queries-not-using-indexes cannot be distinguished from other entries in the slow query log.

This information is important as some queries may make correct use of indexes but still run slow because they access allot of data.

How to repeat:
Switch on log-slow-queries and log-queries-not-using-indexes (this has to be done at startup as per other bugs reported). I Also suggest setting long_query_time to some small value for testing.
Run some slow queries that use indexes, run some queries not using indexes, see if you can tell which is which in the slow log.

Suggested fix:
Add a 'Reason Logged' item to the log data.