Get social


Search Exchange


Recently updated


Most downloaded


Check Mysql status

Last Changed
Views
1468
230
0
0 total
5
4
3
2
1

Description

Check_Mysql_status

This plugin retrieves mysql informations with 'SHOW STATUS' command. Possibility to get values by check (Req/sec).

Synopsis:


 ./check\_mysql\_status.sh -v  [-h ] [-u ] [-p ] [-n ] [-d ]

 -v, --variables STRING[^][:w[b]Value][:c[b]Value] [,STRING[^][w[b]:Value][c[b]:Value]] ...

Name of variables values to recover from the 'SHOW STATUS' command. Retrieves the value of the variable since the last check. Add the character '^' to get variable since the uptime.

Options:

-h, --host:port ADDRESS[:PORT] Hostname or IP Address to check (Default is 127.0.0.1:3306)
-u, --user STRING Connect using the indicated username (Default is nagios)
-p, --password STRING Password to use when connecting to database (Default is nagios)
-n, --RequestName STRING name of the request. WARNING : use this variable if you have different request on the same server !
-d, --Divisor INT To divide the values calculated since the last check (if check every 1 minute : divide by 60 to get values per second)

Example:


 ./check_mysql_status.sh -v questions:w150:c200,com_select^,com_insert

Explanation:


questions => Number of requests sent to the server
WARNING after 150
CRITICAL after 200
com_select => Number of select since the uptime
com_insert => Number of insert since the last check

RĂ©vision 29/03/2010 check_mysql_status - 1.0 - 16/03/2010 Plugin allowing the monitoring MySql by means of the command 'SHOW STATUS' Update exit status to WARNING or CRITICAL ()

by Maxime GUYOT (maxime.guyot@gmail.com)

Latest release

Release v1.0

Revision 29/03/2010

Files

Name Description Size Type Last Changed
check_mysql_status.sh check_mysql_status - 1.0 17.22 kB text/x-c++ Download

Review

Pleae rate the project