vmalert

Rule: MySQLDeadlocksHighok

Expr

mysql:ins:deadlocks > 0

For

300 seconds

Labels

category=mysql level=1 severity=WARN

Annotations

description:

{{ $labels.ins }} reports {{ $value | printf "%.3f" }} deadlocks per second. /ui/d/mysql-instance?var-ins={{ $labels.ins }}

summary:

WARN MySQLDeadlocks {{ $labels.ins }}

Debug

false

Group

8421186766958095244

Warning: some of updates have "Series fetched" equal to 0.
It might be that either this data is missing in the datasource or there is a typo in rule's expression. For example, foo{label="bar"} > 0 could never trigger because foo{label="bar"} metric doesn't exist.
Rule's expressions without time series selector, like expr: 42 or expr: time() aren't fetching time series from datasource, so they could have "Series fetched" equal to 0 and this won't be a problem.
See more details about this detection here.

Last 20/20 updates:

Updated at	Duration	Execution timestamp	cURL
2026-10-16T07:08:13-07:00	0.000s	2026-10-16T07:07:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A07%3A30-07%3A00'
2026-10-16T07:07:43-07:00	0.000s	2026-10-16T07:07:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A07%3A00-07%3A00'
2026-10-16T07:07:13-07:00	0.000s	2026-10-16T07:06:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A06%3A30-07%3A00'
2026-10-16T07:06:43-07:00	0.000s	2026-10-16T07:06:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A06%3A00-07%3A00'
2026-10-16T07:06:13-07:00	0.000s	2026-10-16T07:05:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A05%3A30-07%3A00'
2026-10-16T07:05:43-07:00	0.001s	2026-10-16T07:05:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A05%3A00-07%3A00'
2026-10-16T07:05:13-07:00	0.000s	2026-10-16T07:04:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A04%3A30-07%3A00'
2026-10-16T07:04:43-07:00	0.000s	2026-10-16T07:04:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A04%3A00-07%3A00'
2026-10-16T07:04:13-07:00	0.000s	2026-10-16T07:03:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A03%3A30-07%3A00'
2026-10-16T07:03:43-07:00	0.000s	2026-10-16T07:03:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A03%3A00-07%3A00'
2026-10-16T07:03:13-07:00	0.000s	2026-10-16T07:02:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A02%3A30-07%3A00'
2026-10-16T07:02:43-07:00	0.000s	2026-10-16T07:02:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A02%3A00-07%3A00'
2026-10-16T07:02:13-07:00	0.000s	2026-10-16T07:01:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A01%3A30-07%3A00'
2026-10-16T07:01:43-07:00	0.000s	2026-10-16T07:01:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A01%3A00-07%3A00'
2026-10-16T07:01:13-07:00	0.001s	2026-10-16T07:00:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A00%3A30-07%3A00'
2026-10-16T07:00:43-07:00	0.000s	2026-10-16T07:00:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T07%3A00%3A00-07%3A00'
2026-10-16T07:00:13-07:00	0.000s	2026-10-16T06:59:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T06%3A59%3A30-07%3A00'
2026-10-16T06:59:43-07:00	0.000s	2026-10-16T06:59:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T06%3A59%3A00-07%3A00'
2026-10-16T06:59:13-07:00	0.000s	2026-10-16T06:58:30-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T06%3A58%3A30-07%3A00'
2026-10-16T06:58:43-07:00	0.000s	2026-10-16T06:58:00-07:00	curl -X POST -H 'Content-Type: application/json' 'http://127.0.0.1:8428/api/v1/query?query=mysql%3Ains%3Adeadlocks+%3E+0&step=300s&time=2026-10-16T06%3A58%3A00-07%3A00'