Difference between revisions of "/usr/lib/nagios/plugins/check mysql"

From wikieduonline
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
  
  
 +
/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;;;
  
−
  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
 +
<pre>
 +
check_mysql v2.2 (monitoring-plugins 2.2)
 +
Copyright (c) 1999-2011 Monitoring Plugins Development Team
 +
 +
 
 +
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
 +
 +
</pre>
  
 
== Related ==
 
== Related ==

Latest revision as of 08:06, 21 December 2023


/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]

Retrieved from "https://www.wikieduonline.com/index.php?title=/usr/lib/nagios/plugins/check_mysql&oldid=283382"

Advertising: