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
Triage: D5 (Feature request)

[21 Jun 2005 11:01] Martin Friebe
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
[6 Oct 2008 15:15] Valeriy Kravchuk
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....
[7 Nov 2008 0:00] Bugs System
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".