setting enable_query_response_time_stats in my.cnf is not error prone

Bug #861834 reported by Kenny Gryp
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Won't Fix
Medium
Unassigned
5.5
Invalid
Medium
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Invalid
Undecided
Unassigned

Bug Description

When you want to set 'enable_query_response_time_stats' you need to use:

[mysqld]
enable_query_response_time_stats=1

It does not work when you set it to:
enable_query_response_time_stats=ON
Or when you set it to:
enable_query_response_time_stats

This is not a behavior I would expect.
The documentation also mentions:
Type Boolean
Default Value OFF
Range ON/OFF

Revision history for this message
Kenny Gryp (gryp) wrote :

- Note that percona server also does not give any warning or fail to start. It silently ignores the setting and leaves it off-
- tested under version 5.1.57 - 12.8

summary: - enable_query_response_time_stats in my.cnf
+ setting enable_query_response_time_stats in my.cnf is not error prone
Stewart Smith (stewart)
Changed in percona-server:
importance: Undecided → Medium
Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Also, the documentation for 5.1 is incorrect. http://www.percona.com/doc/percona-server/5.1/diagnostics/response_time_distribution.html

It is still enable_query_response_time_stats in latest PS 5.1

tags: added: query-response-time
Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Current 5.5 query_response_time_stats is a bool variable, thus it should work correctly. Please re-open if it's not the case.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2693

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.