I have written a custom queries for monitoring the MySQL performance and placed the custom queries into medium-resolution directory. The custom queries are executing frequently and stalled the DB. How can I control the query execution. I need to execute the query 5 minutes once.
Here is the link to documentation refer metrics resolution intervals.
Thank you for your reply @Vadim_Yalovets
Seems like this will set it for the whole dashboard. Can we set it for Specific dashboard or metrices? If I changed the metrics resolution value to 5 m, it will affect the entire dashboard.
Such values are global and affect all metrics.