Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_mysql_perf
101146
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
Usage:check_mysql_perf -m mode -w warn -c crit
-d database -H host -P port -u user -p password
-a -i interval
Options:
-h, --help
Print detailed help screen
-V, --version
Print version information
-m, --mode=STRING
where STRING is one of:
slave-lag (Check 'Seconds behind master')
slave-io-running (Check for 'Slave io running: Yes')
slave-sql-running (Check for 'Slave sql running: Yes')
threads-connected (Check 'Threads connected')
threadcache-hitrate (Check 'Thread cache hitrate')
querycache-hitrate (Check 'Query cache hitrate')
keycache-hitrate (Check 'MyISAM Key cache hitrate')
bufferpool-hitrate (Check 'InnoDB Buffer pool hitrate')
tablecache-hitrate (Check 'Table cache hitrate')
table-lock-contention (Check 'Table lock contention')
temp-disk-tables (Check 'Percent of temp tables created on disk')
connection-time (Check 'Seconds to get a connection')
slow-queries (Check 'Slow queries'*)
qcache-lowmem-prunes (Check 'Query cache entries pruned because of low memory'*)
bufferpool-wait-free (Check 'InnoDB Buffer pool waits for clean page available'*)
log-waits (Check 'InnoDB log waits because of a too small log buffer'*)
-w, --warning=RANGE
Warning range (format: start:end). Alert if outside this range
-c, --critical=RANGE
Critical range
-H, --hostname=ADDRESS
Host name, IP Address, or unix socket (must be an absolute path)
-P, --port=INTEGER
Port number (default: 3306)
-i, --interval=INTEGER
The window (in seconds) where rising values are measured
-a, --absolute
Output the absolute difference of the two measurements instead of
the change rate where the absolute difference is divided by time
-d, --database=STRING
Database to check
-u, --username=STRING
Username to login with
-p, --password=STRING
Password to login with
==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==
For extra security, create a user with minimal access.
Temporary files will be saved in /var/tmp
-d database -H host -P port -u user -p password
-a -i interval
Options:
-h, --help
Print detailed help screen
-V, --version
Print version information
-m, --mode=STRING
where STRING is one of:
slave-lag (Check 'Seconds behind master')
slave-io-running (Check for 'Slave io running: Yes')
slave-sql-running (Check for 'Slave sql running: Yes')
threads-connected (Check 'Threads connected')
threadcache-hitrate (Check 'Thread cache hitrate')
querycache-hitrate (Check 'Query cache hitrate')
keycache-hitrate (Check 'MyISAM Key cache hitrate')
bufferpool-hitrate (Check 'InnoDB Buffer pool hitrate')
tablecache-hitrate (Check 'Table cache hitrate')
table-lock-contention (Check 'Table lock contention')
temp-disk-tables (Check 'Percent of temp tables created on disk')
connection-time (Check 'Seconds to get a connection')
slow-queries (Check 'Slow queries'*)
qcache-lowmem-prunes (Check 'Query cache entries pruned because of low memory'*)
bufferpool-wait-free (Check 'InnoDB Buffer pool waits for clean page available'*)
log-waits (Check 'InnoDB log waits because of a too small log buffer'*)
-w, --warning=RANGE
Warning range (format: start:end). Alert if outside this range
-c, --critical=RANGE
Critical range
-H, --hostname=ADDRESS
Host name, IP Address, or unix socket (must be an absolute path)
-P, --port=INTEGER
Port number (default: 3306)
-i, --interval=INTEGER
The window (in seconds) where rising values are measured
-a, --absolute
Output the absolute difference of the two measurements instead of
the change rate where the absolute difference is divided by time
-d, --database=STRING
Database to check
-u, --username=STRING
Username to login with
-p, --password=STRING
Password to login with
==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <==
For extra security, create a user with minimal access.
Temporary files will be saved in /var/tmp
Reviews (0)
Be the first to review this listing!