Bug #17738 --log-queries-not-using-indexes can not be seen in SHOW VARIABLES
Submitted: 27 Feb 2006 13:20 Modified: 5 Dec 2007 18:55
Reporter: Geert Vanderkelen Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0.18 OS:Any (*)
Assigned to: CPU Architecture:Any

[27 Feb 2006 13:20] Geert Vanderkelen

The option --log-queries-not-using-indexes, when turned on, is not visible in the SHOW VARIABLES output. So we currently can't figure out whether the running server has it turned on or off.

How to repeat:

Run the server with the option --log-queries-not-using-indexes=1 and check SHOW VARIABLES..
[27 Feb 2006 13:21] Geert Vanderkelen
Verified in 5.0.18 and same behaviour is seen in 4.1.