MySQL Query Performance Troubleshooting doesn't show queries

Percona Monitoring and Management (PMM) PMM 2.x
,
1

Hello.

I have imported MySQL Query Performance Troubleshooting dashboard - for PMM2, which was working well - I had all the data.

https://grafana.com/grafana/dashboards/12630-mysql-query-performance-troubleshooting/?tab=revisions

Now I spotted that it’s not giving data for queries. As I checked, no new version is uploaded since 12-07-2020.

Screenshot 2023-12-18 at 23.07.27
Screenshot 2023-12-18 at 23.07.273308×1748 391 KB

Screenshot 2023-12-18 at 23.42.43
Screenshot 2023-12-18 at 23.42.433316×782 63.5 KB

Screenshot 2023-12-18 at 23.42.54
Screenshot 2023-12-18 at 23.42.543318×776 64.5 KB

when trying to edit the graph, it’s the error :

error unmarshaling query JSON the Query Model: json: cannot unmarshal string into Go struct field Query.format of type sqlds.FormatQueryOption

Current version: 2.39.0

Any ideas how it can be solved ?

2

Hello @Ani_Ghoghoberidze,
Since this dashboard is not provided as part of the standard PMM deployment, there is no guarantee it will work with PMM. I see the creator of the dashboard is “perconalabs” which is a playground for our engineering team.
Looking at the source of this dashboard, the ‘CPU Intensive Queries’ formula has many statically defined hostnames and timestamps. Unless your servers are also named exactly the same, and you are looking at the same time period, you won’t see any metrics.
Additionally, I see the dashboard uses Prometheus which PMM has not used since version 1.

1 Like
3

@Ani_Ghoghoberidze It might be due to the below change; please modify your queries accordingly.

image
image1044×750 85.7 KB

2 Likes
4

@Naresh9999 thank you very much, this fixed my issue.

1 Like
5

Hello,
I need your help please as I have that same issue after upgraded PMM2 (now I run PMM2 version 2.41.2), can you please explain to me shortly where/how exactly do I modify the query from the Altinity ClickHouse datasource SQL to the Grafana ClickHouse datasource in order to resolve this issue?

6

Hi @Ofir_Granot

What and where is the problem that you are experiencing?
The given solution is only for the custom dashboards.

7

Thank you for your reply :slight_smile:
I have the same issue as the issue on this thread, I am facing an issue with the dashboard “MySQL Query Performance Troubleshooting” on PMM2 version 2.41.2, the issue is that it stopped showing the queries for each of the categories since I patched the PMM2 server at the past