If you are missing a feature or
have any idea to make
MonitoringExchange better
than now, please let us know.
check_mysql_stats (Visit this link)
5 from 2 votesPlugin that checks for various performance stats from MySQL
check_mysql_stats was designed to monitor various InnoDB and general mysql stats. At the time, I could not find a plugin that specifically did what I wanted.
It has one odd requirement that was designed to minimize the additional overhead of the frequent queries to the database server.
All of the output from \'SHOW GLOBAL VARIABLES\' is stored in a shared memory cache with a lifetime of 10 minutes. Some of these values (such as max_connections) are slow changing so there\'s no need to continually ask for this information.
Here are a few examples:
**Thread Cache Hit Ratio**
``check_mysql_stats -H localhost -U nagios -P nagios -w 80 -c 75 -t``
**OUTPUT**
OK: Thread cache hit ratio is 92.86% | hit_ratio=92.86;80;75;0;100
It has one odd requirement that was designed to minimize the additional overhead of the frequent queries to the database server.
All of the output from \'SHOW GLOBAL VARIABLES\' is stored in a shared memory cache with a lifetime of 10 minutes. Some of these values (such as max_connections) are slow changing so there\'s no need to continually ask for this information.
Here are a few examples:
**Thread Cache Hit Ratio**
``check_mysql_stats -H localhost -U nagios -P nagios -w 80 -c 75 -t``
**OUTPUT**
OK: Thread cache hit ratio is 92.86% | hit_ratio=92.86;80;75;0;100
Submitted by: lusis
Hits: 1818
Overall downloads: 348
Added: 2008-03-12 00:00:00
Last Modified: 2009-12-16 16:43:13
| Filename | Preview | Size | Description | DL |
|---|---|---|---|---|
| check_mysql_stats |  |
11 kb | check_mysql_stats script | 1574 |
Comments
Leave a reply
If you just want to rate the project leave the other field empty.
Even though it would be nice if you would drop a line.
-
check_mysql
from 0 votesCheck connection an check show status values. Some plugins for checking predefined values and one generic for checking the values given on the commandline. -
check_mysql_perf
from 0 votesPlugin written in C which allows to monitor various performance-related characteristics of a MySQL database. -
check_mysqld
from 0 votesReplacement for check_mysql that allows to set thresholds for any variables in SHOW STATUS or for similar SQL queries. Data is also made available for graphing or other use (graphing templates enclosed) -
check_mysql_health
from 0 votescheck_mysql_health is a plugin for Nagios that allows you to monitor a MySQL database. Among the list of metrics are time to login, index usage, bufferpool hit rate, query cache hit rate, slow queries, temp tables on disk, table cache hit rate, connected threads, and many more. Requirements are either a DBD::mysql Perl module or a MySQL client package. -
simple mysql checker
from 0 votessimple mysql checker.
-
NDB node monitoring
from 0 votesPlugin to check the number of active nodes that aren't in a down or disconnected state from your NDB cluster. Has fully customizable prefixing, commands, and thresholds from the command-line or nagios command definitions. Uses the 'ndb_mgm -e show' command to gather the data. -
MySQL ISAM Table Size
from 0 votesChecks MyISAM tables aren't getting too big. -
check_mysql-replication.pl
from 0 votesYet another plugin to check your mysql replication threads and your lag synchronisation -
check_mysql_db_integrity
from 0 votesA script to remotely check MySQL database integrity of given database on a specified MySQL Server -
Check Mysql status
from 0 votesRetrieves mysql informations with 'SHOW STATUS' command. Possibility to get values by check (Req/sec)