External documentation: http://nagiosplugins.org/man/check_mysql
Note: This check appears to work fine with MariaDB, also.
- GOOD - If the MySQL server is up, accepting connections.
- WARN - If the server has some long running transactions.
- BAD - If the server cannot be connected to.
Normally, no additional options are needed, just define the nagios check_mysql command and off you go!
As the command example above does not take any options, the following service definition will work;
If your server requires authentication, then you can simply add -u and -p to the check_mysql command, like this;