Buy Percona SupportEmergency? Get 24/7 Help Now!

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.
  -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 (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.0.5

Table Of Contents

Previous topic

pmp-check-lvm-snapshots

Next topic

pmp-check-mysql-deleted-files

This documentation is developed in Launchpad as part of the Percona Monitoring Plugins 1.0.
If you spotted inaccuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.


General Inquiries

For general inquiries, please send us your question and someone will contact you.