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

C.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 then a CRITICAL status results.

FieldValue
Username* 
Password 
MySQL Port3306
Database*mysql
Timeout15

Table C-32. MySQL::Database Accessibility settings

C.7.2. MySQL::Opened Tables

The MySQL::Opened Tables probe monitors the MySQL server and collects the following metric:

FieldValue
Username 
Password 
MySQL Port*3306
Timeout15
Critical Maximum Opened Objects 
Warning Maximum Opened Objects 
Warning Minimum Opened Objects 
Critical Minimum Opened Objects 

Table C-33. MySQL::Opened Tables settings

C.7.3. MySQL::Open Tables

The MySQL::Open Tables probe monitors the MySQL server and collects the following metric:

FieldValue
Username 
Password 
MySQL Port*3306
Timeout15
Critical Maximum Open Objects 
Warning Maximum Open Objects 
Warning Minimum Open Objects 
Critical Minimum Open Objects 

Table C-34. MySQL::Open Tables settings

C.7.4. MySQL::Query Rate

The MySQL::Query Rate probe monitors the MySQL server and collects the following metric:

FieldValue
Username 
Password 
MySQL Port*3306
Timeout15
Critical Maximum Query Rate 
Warning Maximum Query Rate 
Warning Minimum Query Rate 
Critical Minimum Query Rate 

Table C-35. MySQL::Query Rate settings

C.7.5. MySQL::Threads Running

The MySQL::Threads Running probe monitors the MySQL server and collects the following metric:

FieldValue
Username 
Password 
MySQL Port*3306
Timeout15
Critical Maximum Threads Running 
Warning Maximum Threads Running 
Warning Minimum Threads Running 
Critical Minimum Threads Running 

Table C-36. MySQL::Threads Running settings