MySQL Bugs: #11477: -log-queries-not-using-indexes as variable instead of command-line-option

Bug #11477	-log-queries-not-using-indexes as variable instead of command-line-option
Submitted:	21 Jun 2005 11:01	Modified:	6 Nov 2008 15:15
Reporter:	Martin Friebe (Gold Quality Contributor) (OCA)	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	4.1.*	OS:	Any (*)
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
It would be helpfull, if "--log-queries-not-using-indexes" could be a server variable and if it could be controlled via "set local log-queries-not-using-indexes="OFF"/"ON".

Background:

I have one process frequently reading all entries of a table (about 10 entries, not a problem). As I am reading the all entries, the server always prefer a table read, over index.

This makes the above option completly useless, as the logfile is flooded with completly harmless entries, making it impossible for me to spot any of the queries, that I culd change to use indexes.

with a per thread variable, I could have that process setting it to off, and the problem was solved

How to repeat:
-

Suggested fix:
thanks for considering it

Thank you for a reasonable feature request.

Are you satisfied with current implementation (dynamic variable, but GLOBAL)? See http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_log-queries-not-u....

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".