D.7. MySQL 3.23

D.7. MySQL 3.23 - 3.33

The probes in this section monitor aspects of the MySQL database using the mysqladmin binary. No specific user privileges are needed for these probes.

Note that the mysql-server package must be installed on the system conducting the monitoring for these probes to complete. Refer to the MySQL Installation section of the RHN Satellite Installation Guide for instructions.

D.7.1. MySQL::Database Accessibility

The MySQL::Database Accessibility probe tests connectivity through a database account that has no database privileges. If no connection is made, a CRITICAL status results.

Field	Value
Username*
Password
MySQL Port	3306
Database*	mysql
Timeout	15

Table D.32. MySQL::Database Accessibility settings

D.7.2. MySQL::Opened Tables

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.

Field	Value
Username
Password
MySQL Port*	3306
Timeout	15
Critical Maximum Opened Objects
Warning Maximum Opened Objects
Warning Minimum Opened Objects
Critical Minimum Opened Objects

Table D.33. MySQL::Opened Tables settings

D.7.3. MySQL::Open Tables

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.

Field	Value
Username
Password
MySQL Port*	3306
Timeout	15
Critical Maximum Open Objects
Warning Maximum Open Objects
Warning Minimum Open Objects
Critical Minimum Open Objects

Table D.34. MySQL::Open Tables settings

D.7.4. MySQL::Query Rate

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.

Field	Value
Username
Password
MySQL Port*	3306
Timeout	15
Critical Maximum Query Rate
Warning Maximum Query Rate
Warning Minimum Query Rate
Critical Minimum Query Rate

Table D.35. MySQL::Query Rate settings

D.7.5. MySQL::Threads Running

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.

Field	Value
Username
Password
MySQL Port*	3306
Timeout	15
Critical Maximum Threads Running
Warning Maximum Threads Running
Warning Minimum Threads Running
Critical Minimum Threads Running