Update MySQL dashboards to fully support MySQL 8.4
General
Escalation
General
Escalation
Description
As we are updating the mysqld_exporter to the very latest upstream version (0.17.2), some metrics are being deprecated, and some others even dropped (see the changelog). Therefore, to ensure that PMM fully supports MySQL 8.4, we need to update MySQL dashboards in PMM.
Scope:
MySQL Replication Summary Dashboard:
IO Thread Running
SQL THread Running
Replication Delay
MySQL Replication Lag
Please note that support for MariaDB 11 has been scoped in a separate ticket -
How to test
Set up a MySQL 8.4 cluster with Asynchronous Replication and let it run for a while
Create a test database, the create a table and insert a few records into the table on the primary node
Go to MySQL/Replication Summary dashboard and verify that the panels reported below as broken (see screenshots) show actual data. No broken panels should be encountered.
How to document
MySQL Exporter has been upgraded to the very last upstream version 0.17.2. This upgrade makes it compatible with MySQL version 8.4. We have also updated the “MySQL Replication Summary Dashboard” to fully support this version of MySQL.
but from user point of view it’s both about supporting MySQL 8.4, right? I think should be closed as duplicate of this one or another one.
Alex Demidoff
March 24, 2025 at 1:41 PM
No, it’s not a duplicate. This ticket addresses a bug in the dashboard, and the other ticket is about upgrading the exporter to be compatible with MySQL 8.4+. This ticket is rather a duplicate of .
Alex Demidoff
March 23, 2025 at 1:28 PM
(edited)
I was able to fix the panels reported as broken below. Attached is a screenshot where a PS cluster’s replica is showing its replication-related metrics on the panels.
saikumar.vs
March 20, 2025 at 1:12 PM
(edited)
We can see in 8.4 ( based on PR on 12153), IO And SQL thread as well as replication lag metrics are missing.
but metrics exists, when we see in metrics explorer:
Here are the graphs for 5.7 , 8.0, which show metrics:
Naresh
March 18, 2025 at 6:22 PM
No problem and thanks for the considering the MariaDB changes as well.
As we are updating the
mysqld_exporterto the very latest upstream version (0.17.2), some metrics are being deprecated, and some others even dropped (see the changelog). Therefore, to ensure that PMM fully supports MySQL 8.4, we need to update MySQL dashboards in PMM.Scope:
MySQL Replication Summary Dashboard:
IO Thread Running
SQL THread Running
Replication Delay
MySQL Replication Lag
Please note that support for MariaDB 11 has been scoped in a separate ticket -