Learn to monitor MySQL server performance with Prometheus and sql_exporter. Visualize your metrics in Grafana/Hosted Grafana by MetricFire.
See this Grafana tutorial on how to automate all of your common actions. Use Hosted Grafana by MetricFire to make Grafana even easier.
Get to know Prometheus Pushgateways and how they can help you send metrics data from your short-lived scripts.
Learn how to use Prometheus's rate() function. See two example use cases for rate() used for alerting and for SLO calculation.
Take a look at the top 5 most common Prometheus Alertmanager issues, learn the causes of those issues, and fix or avoid them.