pmp-check-mysql-ts-count

pmp-check-mysql-ts-count - Generic alert based on pmp-check-mysql-deadlocks to count number of rows written in the last interval.

SYNOPSIS

Usage: pmp-check-mysql-ts-count [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 TIMESTAMP    The name of the timestamp column to be monitored; default ts.
  -T TABLE        The database.table to be monitored; default percona.deadlocks.
  -w WARN         Warning threshold; default 12.
  -x TARGET       Metric monitored; default deadlocks.
                  Other options: kills, fkerrors.
  --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 a table and counts the number of rows since the last interval, and alerts if this exceeds the threshold. This could be the table referenced by pt-deadlock-logger, pt-kill, pt-fk-error-logger, or a custom table supplied. Default behaviour is the same as pmp-check-mysql-deadlocks, can also specify target to be kills or fkerrors to monitor default tables created by pt-kill or pt-fk-error-logger respectively, or supply custom metric and table.

PRIVILEGES

This plugin executes the following commands against MySQL:

  • SELECT from the supplied table.

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

VERSION

Percona Monitoring Plugins pmp-check-mysql-ts-count 1.1.4

© Copyright 2012, Percona Inc.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
This documentation is developed in Launchpad as part of the Percona Monitoring Plugins source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.