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.8
Contact Us
For free technical help, visit the Percona Community Forum.To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or professional services, contact Percona Sales.