We need to modify the Query Response Time plugin dashboard to consume histogram information.
How is Histogram enabled in PERFORMANCE_SCHEMA - is it on by default?
Should Histogram be disabled based on any criteria? # of tables or something else?
How to test
None
How to document
None
Activity
Collin Matthews November 22, 2023 at 3:49 PM
+1 It has been years now that this has been a known issue, It seems like someone could implement this and it would be highly beneficial.
This was a popular graph for multiple teams in my organization as a spot check that no new systems started hammering MySQL with poor performing queries.
Johannes Wegener July 25, 2023 at 9:52 AM
What is the state of this? Seems like the performance schema event tables might be of interest. But `mysqld_exporter` doesn't seem to export these.
Glyn Astill August 30, 2022 at 11:19 AM
+1 for this feature. A simple dashboard to see queries by latency percentile would be very advantageous.
In PS 8 we retired support for QRT plugin:
https://www.percona.com/doc/percona-server/8.0/changed_in_version.html#features-removed-from-percona-server-version
We need to modify the Query Response Time plugin dashboard to consume histogram information.
How is Histogram enabled in PERFORMANCE_SCHEMA - is it on by default?
Should Histogram be disabled based on any criteria? # of tables or something else?