Aborted connects alert
Job details
Name: | Aborted connects alert |
Platform: | Mysql |
Category: | Availability |
Description: | Collects uptime statistics for the MySQL instance. |
Long description: | |
Version: | 1.2 |
Default schedule: | 10m |
Requires engine install: | No |
Compatibility tag: | .[type=‘instance’ & is_mysql_branch=‘1′ & hasengine=‘NO’] |
Parameters
Name | Default value | Description |
---|---|---|
return_status | 1 | Return status value (ALARM – 2, WARNING – 1, or OK – 0) when the number of aborted connections registered since last checked is higher than min_aborted_connections parameter value. |
min_aborted_connections | 10 | A minimum number of aborted connections before an alert can be triggered. |
Job Summary
- Purpose: The purpose of this job is to monitor and alert for aborted connections on MySQL databases. It is specifically configured to watch for a minimum number of aborted connections, and will trigger an alert if this threshold is exceeded.
- Why: This job is critical for maintaining the availability and stability of the MySQL databases. It allows the administrator to proactively manage and troubleshoot any potential issues that might disrupt the smooth operation of the database.
- Manual checking: The job uses SQL queries to retrieve the number of aborted connections from the MySQL database. It then performs a calculation to determine the new aborted connections since the last check. Manual checking can be performed by issuing SQL command to check aborted connections in the database.
Job Details
- Name: This job is named “MySQL aborted connects.”
- Company: This monitoring job is developed by dbwatch.com.
- Description: The job’s main function is to check if there are many aborted connections. If there are, it will trigger an alert to the system or database administrator.
- Compatibility: This job is compatible with all MySQL instances.
- Default Schedule: It runs every 10 minutes to ensure continuous monitoring of aborted connections.
- Status: The status would be set depending on the return status value i.e., ALERT (2), WARNING (1), or OK (0) when the number of aborted connections registered since last check is higher than the set threshold.
- Report: The job also generates a report called “MySQL aborted connects” that details the number of new aborted connections found and the total number of aborted connections since the server restart.
Company Details
- Name: dbwatch.com
- Group: com.dbwatch.job
- Artifact ID: mysql_noschema_aborted_connects
- Version: 1.2