Query reponse time and Query time histogram not graphing
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Monitoring Plugins |
Fix Released
|
Medium
|
Baron Schwartz |
Bug Description
In our setup the Query Response Time and Query Time Histogram are not graphing.
It took me a whle to pinpoint the problem, but I'm happy to say I finally found it:
In the ss_get_
SELECT `count`, total * 1000000 AS total FROM INFORMATION_
This results in a thirteen row result, which then gets assigned to the $status[
However at line 757 the script will check if the value is set. As Query_time_count_13 and Query_time_total_13 will not be set and the returned value at line 760 is -1.
Since templates are only allowed to contain values ranging from 0 to 184467440737095
The fix could be any of the following three options:
1. Change templates to allow -1 value
2. Change templates to only contain 13 data points instead of 14
3. Change the query in the ss_get_
We fixed our instance by patching the ss_get_
Related branches
- Baron Schwartz (community): Approve
- Diff: 0 lines
Changed in percona-monitoring-plugins: | |
milestone: | none → 1.0.0 |
Changed in percona-monitoring-plugins: | |
status: | Confirmed → Fix Committed |
Changed in percona-monitoring-plugins: | |
status: | Fix Committed → New |
status: | New → Fix Released |
Thanks. I was unaware that a single -1 would make the whole measurement be ignored!