Description
This template monitors metrics like aborted clients, maximum connections, internal connection errors, active transactions, SSL client connects, etc.
Prerequisites
The database you want to monitor should connect from the Gateway. Gateway Management profile should be added to the device. Database type credentials should be added against the device in the portal. While applying the template, the database port, Database Name, connection timeout need to be specified.
Metric Parameters
| Parameter | Description |
|---|---|
| Frequency | Warning Threshold | If the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user. |
| Critical Threshold | If the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user. |
| Alert | The alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user. |
Metrics
mysql.aborted.clients
Metric Details
| Applicable for | Device |
| Description | The number of connections that were aborted because the client died without closing the connection properly. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.max.connections
Metric Details
| Applicable for | Device |
| Description | Maximum Limit of Connections. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.max.connections.connection_errors
Metric Details
| Applicable for | Device |
| Description | The number of connections refused due to internal server errors. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.aborted.connects
Metric Details
| Applicable for | Device |
| Description | The number of failed attempts to connect to the MySQL server. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.internal.connection.errors
Metric Details
| Applicable for | Device |
| Description | The number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.ssl.client.connects
Metric Details
| Applicable for | Device |
| Description | The number of SSL connection attempts to an SSL-enabled master. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.active.transactions
Metric Details
| Applicable for | Device |
| Description | Number of active transactions. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph
mysql.server.connections
Metric Details
| Applicable for | Device |
| Description | The number of connection attempts (successful or not) to the MySQL server. |
| Category | Application |
| Collector Type | Gateway |
| Monitor Name | G2 MySQL Database Connection Monitor |
| Unit | count |
Possible Inputs
| Metric | Input Value | Range of Values |
|---|---|---|
| Frequency | 5 | 1 – 1440 (mins) |
| Filter | ||
| Warning Operator | ||
| Warning Threshold | ||
| Warning Repeat Count | ||
| Critical Operator | ||
| Critical Threshold | ||
| Critical Repeat Count | ||
| Alert | No | Yes/No |
| Graph (Yes/No) | Yes | Yes/No |
Sample Output
No graph