Buy Percona ServicesBuy Now!


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.8

Table Of Contents

Previous topic


Next topic


Visit Percona Store

General Inquiries

For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.