Convert QRT to use new MySQL 8 histogram

Description

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.

  1. How is Histogram enabled in PERFORMANCE_SCHEMA - is it on by default?

  2. 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.

Details

Assignee

Reporter

Priority

Components

Needs QA

Needs Doc

Planned Version/s

Created October 9, 2019 at 3:29 PM
Updated December 16, 2024 at 11:03 AM