MySQL Bugs: #32574: log-queries-not-using-indexes log entries difficult to distinguish in log

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.