MariaDB Alerts
Sumo Logic has provided out-of-the-box alerts available through Sumo Logic monitors to help you quickly determine if the MariaDB Database are available and performing as expected. These alerts are built based on logs and metrics datasets and have preset thresholds based on industry best practices and recommendations.
Sumo Logic provides the following out-of-the-box alerts:
| Alert Type (Metrics/Logs) | Alert Name | Alert Description | Trigger Type (Critical / Warning) | Alert Condition | Recover Condition |
|---|---|---|---|---|---|
|
Logs |
MariaDB - Excessive Slow Query Detected |
This alert fires when the average time to execute a query is more than 15 seconds for a 5 minute time interval. |
Critical | >=1 | <1 |
|
Logs |
MariaDB - Instance down |
This alert fires when we detect that a MariaDB instance is down |
Critical | >=1 | <1 |
|
Metrics |
MariaDB - Connection refused |
This alert fires when connections are refused when the limit of maximum connections is reached. |
Critical | >=1 | <1 |
|
Metrics |
MariaDB - Follower replication lag detected |
This alert fires when we detect that the average replication lag within a 5 minute time interval is greater than or equal to 900 seconds . |
Critical | >=900 | <900 |
|
Metrics |
MariaDB - High average query run time |
This alert fires when the average run time of MariaDB queries within a 5 minute time interval for a given schema is greater than or equal to one second. |
Critical | >=1 | <1 |
|
Metrics |
MariaDB - High Innodb buffer pool utilization |
This alert fires when the InnoDB buffer pool utilization is high (>=90%) within a 5 minute time interval. |
Critical | >=90 | <90 |
|
Metrics |
MariaDB - Large number of aborted connections |
This alert fires when there are 5 or more aborted connections detected within a 5 minute time interval. |
Critical | >=5 | <5 |
|
Metrics |
MariaDB - Large number of internal connection errors |
This alert fires when there are 5 or more internal connection errors within a 5 minute time interval. |
Critical | >=5 | <5 |
|
Metrics |
MariaDB - Large number of slow queries |
This alert fires when there are 5 or more slow queries within a 5 minute time interval. |
Critical | >=5 | <5 |
|
Metrics |
MariaDB - Large number of statement errors |
This alert fires when there are 5 or more statement errors within a 5 minute time interval. |
Critical | >=5 | <5 |
|
Metrics |
MariaDB - Large number of statement warnings |
This alert fires when there are 20 or more statement warnings within a 5 minute time interval. |
Critical | >=20 | <20 |
|
Metrics |
MariaDB - No index used in the SQL statements |
This alert fires when there are 5 or more statements not using an index in the SQL query within a 5 minute time interval. |
Critical | >=5 | <5 |
|
Metrics |
MariaDB - Slave Server Error |
This alert fires when there are slave server errors within a 5 minute time interval. |
Critical | >0 | <=0 |