The probes in this section monitor aspects of the MySQL database using the mysqladmin binary. No specific user privileges are needed for these probes.
The MySQL::Database Accessibility probe tests connectivity through a database account that has no database privileges. If no connection is made then a CRITICAL status results.
The MySQL::Opened Tables probe monitors the MySQL server and collects the following metric:
Opened Tables — The tables that have been opened since the server was started.
The MySQL::Open Tables probe monitors the MySQL server and collects the following metric:
Open Tables — The number of tables open when the probe runs.
The MySQL::Query Rate probe monitors the MySQL server and collects the following metric:
Query Rate — The average number of queries per second per database server.
The MySQL::Threads Running probe monitors the MySQL server and collects the following metric:
Threads Running — The total number of running threads within the database.