I can set up an alert when the replication lag is getting bigger.But can’t create an alert for replication error.
Can you please give some query examples?
I can set up an alert when the replication lag is getting bigger.But can’t create an alert for replication error.
Can you please give some query examples?
Hi jiucai
I have created alerts for IO and SQL threads, as the mysqld_exporter automatically coverts these to integer values which you can then alert on. Here’s an example:
[URL]https://pmmdemo.percona.com/graph/d/000000035/_alerting?refresh=10s&panelId=25&fullscreen&orgId=1[/URL]
First you identify the metric series against the instance you want to track:
And the alert definition:
Hope this helps!
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.