Automatic sql performance recommendations

[mailsathere]

Description:

[Availability of performance tuning recommendations]

Hi
We are exploring the Percona PMM 2.x tool for providing performance insights for our application. From the documentation I see that the dashboards shows the query’s count of executions, load usage etc. However, is there a way we can get the tool to provide us quick recommendations such as index, data fragmentation etc?

[Naresh9999]

Hi @mailsathere

Yes, you can explain your query plan on the QAN dashboard.

and you check the Table data fragmentation on the MySQL Table Details Dashboard.