# MySQL Query Performance Troubleshooting doesn't show queries **URL:** \ **Category:** PMM 2.x\ **Tags:** pmm, percona\ **Created:** [December 18, 2023, 7:45pm UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229 "2023-12-18T19:45:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Ani\_Ghoghoberidze](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ani_ghoghoberidze/32/7681_2.png) [@Ani\_Ghoghoberidze](https://forums.percona.com/u/Ani_Ghoghoberidze)\ **Post date:** [December 18, 2023, 7:45pm UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/1 "2023-12-18T19:45:49Z")
Hello. I have imported MySQL Query Performance Troubleshooting dashboard - for PMM2, which was working well - I had all the data. ```auto 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](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/8/87adbb391fc693befb4a6b3bf4346b3c195ad057.png) ![Screenshot 2023-12-18 at 23.42.43](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/cae3764e385d729acd24924217710794a0c48d80.png) ![Screenshot 2023-12-18 at 23.42.54](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/06aa08bd98c1475e3a11140ca82e33b6250d27e2.png) when trying to edit the graph, it’s the error : ```auto 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 ? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [December 18, 2023, 8:22pm UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/2 "2023-12-18T20:22:23Z")
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. ---
**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\ **Post date:** [December 19, 2023, 4:19am UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/3 "2023-12-19T04:19:00Z")
@Ani_Ghoghoberidze It might be due to the below change; please modify your queries accordingly. > **[Percona Monitoring and Management - PMM 2.38.0](https://docs.percona.com/percona-monitoring-and-management/release-notes/2.38.0.html#important-security-updates)** > > Percona Monitoring and Management (PMM) is an open-source database monitoring, management, and observability solution for MySQL, PostgreSQL, and MongoDB. ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/6/6b1816837c161f5bf3bf419a4a2855f19b73b64e.png) ---
**Author:** ![Ani\_Ghoghoberidze](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ani_ghoghoberidze/32/7681_2.png) [@Ani\_Ghoghoberidze](https://forums.percona.com/u/Ani_Ghoghoberidze)\ **Post date:** [December 19, 2023, 10:44am UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/4 "2023-12-19T10:44:16Z")
@Naresh9999 thank you very much, this fixed my issue. ---
**Author:** ![Ofir\_Granot](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ofir_granot/32/2585_2.png) [@Ofir\_Granot](https://forums.percona.com/u/Ofir_Granot)\ **Post date:** [October 7, 2024, 10:57am UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/5 "2024-10-07T10:57:04Z")
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? ---
**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\ **Post date:** [October 8, 2024, 5:14pm UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/6 "2024-10-08T17:14:29Z")
Hi @Ofir_Granot What and where is the problem that you are experiencing? The given solution is only for the custom dashboards. ---
**Author:** ![Ofir\_Granot](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ofir_granot/32/2585_2.png) [@Ofir\_Granot](https://forums.percona.com/u/Ofir_Granot)\ **Post date:** [October 9, 2024, 2:53pm UTC](https://forums.percona.com/t/mysql-query-performance-troubleshooting-doesnt-show-queries/27229/7 "2024-10-09T14:53:30Z")
Thank you for your reply 🙂 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