/usr/lib/nagios/plugins/check mysql
(Redirected from Check mysql)
Jump to navigation
Jump to search
/usr/lib/nagios/plugins/check_mysql Uptime: 1133648 Threads: 14 Questions: 159793336 Slow queries: 1718223 Opens: 191 Flush tables: 1 Open tables: 184 Queries per second avg: 140.954|Connections=2757900c;;; Open_files=57;;; Open_tables=184;;; Qcache_free_memory=2423328;;; Qcache_hits=38449185c;;; Qcache_inserts=106590640c;;; Qcache_lowmem_prunes=105448285c;;; Qcache_not_cached=342783c;;; Qcache_queries_in_cache=3589;;; Queries=159793336c;;; Questions=159793336c;;; Table_locks_waited=0c;;; Threads_connected=1;;; Threads_running=6;;; Uptime=1133648c;;;
/usr/lib/nagios/plugins/check_mysql --help
check_mysql v2.2 (monitoring-plugins 2.2) Copyright (c) 1999-2011 Monitoring Plugins Development Team <[email protected]> This program tests connections to a MySQL server Usage: check_mysql [-d database] [-H host] [-P port] [-s socket] [-u user] [-p password] [-S] [-l] [-a cert] [-k key] [-C ca-cert] [-D ca-dir] [-L ciphers] [-f optfile] [-g group] Options: -h, --help Print detailed help screen -V, --version Print version information --extra-opts=[section][@file] Read options from an ini file. See https://www.monitoring-plugins.org/doc/extra-opts.html for usage and examples. -H, --hostname=ADDRESS Host name, IP Address, or unix socket (must be an absolute path) -P, --port=INTEGER Port number (default: 3306) -n, --ignore-auth Ignore authentication failure and check for mysql connectivity only -s, --socket=STRING Use the specified socket (has no effect if -H is used) -d, --database=STRING Check database with indicated name -f, --file=STRING Read from the specified client options file -g, --group=STRING Use a client options group -u, --username=STRING Connect using the indicated username -p, --password=STRING Use the indicated password to authenticate the connection ==> IMPORTANT: THIS FORM OF AUTHENTICATION IS NOT SECURE!!! <== Your clear-text password could be visible as a process table entry -S, --check-slave Check if the slave thread is running properly. -w, --warning Exit with WARNING status if slave server is more than INTEGER seconds behind master -c, --critical Exit with CRITICAL status if slave server is more then INTEGER seconds behind master -l, --ssl Use ssl encryptation -C, --ca-cert=STRING Path to CA signing the cert -a, --cert=STRING Path to SSL certificate -k, --key=STRING Path to private SSL key -D, --ca-dir=STRING Path to CA directory -L, --ciphers=STRING List of valid SSL ciphers There are no required arguments. By default, the local database is checked using the default unix socket. You can force TCP on localhost by using an IP address or FQDN ('localhost' will use the socket as well). Notes: You must specify -p with an empty string to force an empty password, overriding any my.cnf settings. Send email to [email protected] if you have questions regarding use of this software. To submit patches or suggest improvements, send email to [email protected]
Related[edit]
See also[edit]
Advertising: