Bug #32565 log_slow_queries throws an error when set dynamically
Submitted: 21 Nov 2007 10:54 Modified: 9 Jan 2008 17:13
Reporter: Giles McArdell Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.27 OS:Linux
Assigned to: Peter Lavin CPU Architecture:Any
Tags: log_slow_queries, variables

[21 Nov 2007 10:54] Giles McArdell 
Description:
Issuing:

set log_slow_queries = ON;

Gives:

Error Code : 1193
Unknown system variable 'log_slow_queries'
(0 ms taken)

Section "5.2.2. Command Options" of the reference manual for MySQL 5.0 specifies this option as dynamic.

Given that it can only be set at MySQL start-up it is also probably GLOBAL only.

How to repeat:
run this command:

set log_slow_queries = ON;

Suggested fix:
Correct documentation or make this variable dynamic.
[21 Nov 2007 13:05] MySQL Verification Team 
Thank you for the bug report.
[5 Dec 2007 12:38] Konstantin Osipov 
This is a bug in the manual, the variable works fine in 5.1, in 5.0 it's not dynamic, and that should be reflected in the manual.
[9 Jan 2008 17:13] Peter Lavin 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.