query_response_time_stats ignores query_response_time_range_base on startup

Bug #1056855 reported by Alexey Kopytov
12
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Triaged
Medium
Unassigned
5.1
Triaged
Medium
Unassigned
5.5
Triaged
Medium
Unassigned

Bug Description

If query_response_time_range_base is specified in my.cnf or on the mysqld command line, its value is ignored on startup and the I_S table is initialized with the default value of 10:

$ ./mysqld --gdb --query_response_time_stats=1 --query_response_time_range_base=2

mysql> select * from INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
----------------+-------+----------------+
| time | count | total |
+----------------+-------+----------------+
| 0.000001 | 0 | 0.000000 |
| 0.000010 | 0 | 0.000000 |
| 0.000100 | 0 | 0.000000 |
| 0.001000 | 0 | 0.000000 |
| 0.010000 | 0 | 0.000000 |
| 0.100000 | 0 | 0.000000 |
| 1.000000 | 0 | 0.000000 |
| 10.000000 | 0 | 0.000000 |
| 100.000000 | 0 | 0.000000 |
| 1000.000000 | 0 | 0.000000 |
| 10000.000000 | 0 | 0.000000 |
| 100000.000000 | 0 | 0.000000 |
| 1000000.000000 | 0 | 0.000000 |
| TOO LONG | 0 | TOO LONG |
+----------------+-------+----------------+
14 rows in set (0.01 sec)

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

Fixed in bug 1453277, marking as its duplicate.

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.