Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Update MySQL dashboards to fully support MySQL 8.4

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 - https://perconadev.atlassian.net/browse/PMM-13883

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

https://perconadev.atlassian.net/browse/PMM-13873 fixes a bug where some of MySQL Replication Summary dashboard panels were reporting “No Data” or were broken instead of displaying actual data.

Attachments

5
  • 23 Mar 2025, 01:28 PM
  • 20 Mar 2025, 01:12 PM
  • 20 Mar 2025, 01:12 PM
  • 20 Mar 2025, 01:12 PM
  • 20 Mar 2025, 01:12 PM

Smart Checklist

hide

Activity

Show:

Nurlan Moldomurov last week

but from user point of view it’s both about supporting MySQL 8.4, right? I think https://perconadev.atlassian.net/browse/PMM-13638 should be closed as duplicate of this one or another one.

Alex Demidoff last week

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 https://perconadev.atlassian.net/browse/PMM-12153 .

Alex Demidoff last week
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.

Details

Assignee

Reporter

Priority

Components

Needs QA

Yes

Needs Doc

Yes

Planned Version/s

Fix versions

Story Points

Sprint

Smart Checklist Progress

Start date

Smart Checklist

Created March 18, 2025 at 7:49 AM
Updated 3 days ago