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