Bug #68833 Clarify documentation for Slow_queries
Submitted: 2 Apr 2013 12:07 Modified: 4 Apr 2013 15:34
Reporter: Raghavendra Prabhu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any
Tags: doc

[2 Apr 2013 12:07] Raghavendra Prabhu 
Description:
The documentation for slow_queries states 

" The number of queries that have taken more than long_query_time seconds. See Section 5.2.5, “The Slow Query Log”. "

The referred section talks about slow_query_log.

What needs to be made clear is that even if slow_query_log is 0, the accounting of slow queries can take place, ie. slow_queries can get incremented; as seen from log_slow_statement(THD* thd) which doesn't check opt_slow_log but only checks   (thd->enable_slow_log).

How to repeat:
None

Suggested fix:
Make the documentation clear.
[2 Apr 2013 23:01] MySQL Verification Team 
Thank you for the bug report.
[2 Apr 2013 23:02] MySQL Verification Team 
Thank you for the bug report.
[4 Apr 2013 15:34] Paul DuBois 
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.