pmp-check-mysql-deadlocks

pmp-check-mysql-deadlocks

pmp-check-mysql-deadlocks - Alert when pt-deadlock-logger has recorded too many recent deadlocks.

SYNOPSIS

Usage: pmp-check-mysql-deadlocks [OPTIONS]
Options:
  -c CRIT         Critical threshold; default 60.
  --defaults-file FILE Only read mysql options from the given file.
                  Defaults to /etc/nagios/mysql.cnf if it exists.
  -H HOST         MySQL hostname.
  -i INTERVAL     Interval over which to count, in minutes; default 1.
  -l USER         MySQL username.
  -L LOGIN-PATH   Use login-path to access MySQL (with MySQL client 5.6).
  -p PASS         MySQL password.
  -P PORT         MySQL port.
  -S SOCKET       MySQL socket file.
  -T TABLE        The database.table that pt-deadlock-logger uses; default percona.deadlocks.
  -w WARN         Warning threshold; default 12.
  --help          Print help and exit.
  --version       Print version and exit.
Options must be given as --option value, not --option=value or -Ovalue.
Use perldoc to read embedded documentation with more details.

DESCRIPTION

This Nagios plugin looks at the table that pt-deadlock-logger (https://www.percona.com/doc/percona-toolkit/3.0/pt-deadlock-logger.html, the part of Percona Toolkit) maintains, and when there have been too many recent deadlocks, it alerts.

PRIVILEGES

This plugin executes the following commands against MySQL:

  • SELECT from the pt-deadlock-logger table.

This plugin executes no UNIX commands that may need special privileges.

VERSION

Percona Monitoring Plugins pmp-check-mysql-deadlocks 1.1.8

Download PDF Manual

Table Of Contents

Previous topic

pmp-check-mongo.py

Next topic

pmp-check-mysql-deleted-files

Percona Monitoring Plugins Series

Contact Us

For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.