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


Usage: pmp-check-mysql-ts-count [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.


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.


This plugin executes the following commands against MySQL:

  • SELECT from the supplied table.

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


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

Table Of Contents

Previous topic


Next topic