Bug #17889 log_queries_not_using_indexes not shown in SHOW VARIABLES output
Submitted: 3 Mar 2006 9:21 Modified: 9 Mar 2006 10:52
Reporter: Hartmut Holzgraefe Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 and later OS:Any (*)
Assigned to: CPU Architecture:Any

[3 Mar 2006 9:21] Hartmut Holzgraefe
Starting with 4.1 there is a command line option --log-queries-not-using-indexes and an option file directive log_queries_not_using_indexes which needs to be set to request logging of queries that need to perform table scans due to missing indexes (before 4.1 this was just part of --log-long-format).

This works fine, but it is impossible to tell whether this feature is enabled or not from looking at SHOW VARIABLES output as log_queries_not_using_indexes is not part of its output.

How to repeat:
check SHOW VARIABLES output for log_queries_not_using_indexes

Suggested fix:
add this variable to SHOW VARIABLES
[9 Mar 2006 10:52] Hartmut Holzgraefe
duplicate of  bug #17738