I have multiple MariaDB instances that I monitor with mysql exporter on grafana. I have spotted some slow queries recently which took more than 300 seconds by looking at the process list of the instance. My monitoring dashboard did not detect it because it looks for the number of slow queries and not their time.
What should i monitor to detect those slow queries so i can fix them ? Is there any metrics i can use to plot it on grafana ?