pmp-check-mysql-processlist

pmp-check-mysql-processlist - Alert when MySQL processlist has dangerous patterns.

SYNOPSIS

Usage: pmp-check-mysql-processlist [OPTIONS]
Options:
  -c CRIT         Critical threshold; default 32.
  --defaults-file FILE Only read mysql options from the given file.
                  Defaults to /etc/nagios/mysql.cnf if it exists.
  -H HOST         MySQL hostname.
  -l USER         MySQL username.
  -p PASS         MySQL password.
  -P PORT         MySQL port.
  -S SOCKET       MySQL socket file.
  -w WARN         Warning threshold; default 16.
  --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 examines MySQL’s processlist and alerts when there are too many processes in various states. The list of checks is as follows:

Unauthenticated users

Unauthenticated users appear when DNS resolution is slow, and can be a warning sign of DNS performance problems that could cause a sudden denial of service to the server.

Locked processes

Locked processes are the signature of MyISAM tables, but can also appear for other reasons.

Copying to temporary tables

Too many processes copying to various kinds of temporary tables at one time is a typical symptom of a storm of poorly optimized queries.

Statistics

Too many processes in the “statistics” state is a signature of InnoDB concurrency problems causing query execution plan generation to take too long.

PRIVILEGES

This plugin executes the following commands against MySQL:

• SHOW PROCESSLIST.

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

VERSION

Percona Monitoring Plugins pmp-check-mysql-processlist 1.0.3