Aborted connects alert
Job details
| Name: |
Aborted connects alert |
| Platform: |
Mariadb |
| Category: |
Availability |
| Description: |
Collects uptime statistics for the MariaDB instance. |
| Long description: |
|
| Version: |
1.2 |
| Default schedule: |
10m |
| Requires engine install: |
No |
| Compatibility tag: |
.[type=‘instance’ & is_mariadb_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 for aborted connections in MariaDB instances and alert administrators if the count of new aborted connections since the last check exceeds a preset threshold.
- Why:
- This job is essential to ensure the smooth operation and availability of MariaDB instances by promptly identifying frequent aborted connections, which could indicate larger issues such as network problems, authentication failures, or potential attacks. Early detection helps in minimizing downtime and troubleshooting time.
- Manual checking:
- You can manually check aborted connections in MariaDB using the following SQL command:
SHOW GLOBAL STATUS LIKE 'Aborted_connects';
Job Details
- Description: This monitoring job checks MariaDB instances for aborted connection attempts since the last monitoring interval. It triggers alerts based on a defined threshold to help in identifying and resolving issues that cause these aborted connections.
- Category: Availability
- Default Execution Schedule: Every 10 minutes
- Compatibility: The job is compatible only with MariaDB instances.
Aborted Connects Alert Logic
- The script calculates the number of new aborted connections since the last recorded check.
- If the count of new aborted connections since the last check exceeds the “min_aborted_connections” threshold, the status is set to either ALARM or WARNING based on the severity defined by the “return_status”.
- An alert message is generated, stating the total aborted connections since the server was last restarted and the number of new connections detected in the current check interval.
Output Details
- The output results are structured to provide a clear understanding of the status and the details:
- The status indicates if the check has passed or if an alert needs to be raised.
- The details describe the actual count of aborted connections detected and the total count of aborted connections recorded since the last server restart.
Relevant Tables and Presentation
| Column Name |
Data Type |
Description |
| Details |
Integer |
Number of new aborted connections detected. |
- Presentation Type: Table
- Details Displayed: Table showing the count of new aborted connections and total aborted connections since restart.
Additional Notes
- The job includes JavaScript logic that is specifically tailored to handle data retrieval and threshold checks, ensuring accurate and timely alerts.
- It utilizes dbWQL and JavaScript engine integrations to interface seamlessly with the MariaDB database, ensuring robust monitoring capability.