Skip to main content
Sumo Logic

MySQL Alerts

See the alerts provided by the Sumo Logic MySQL App.

This page describes the monitors provided with the MySQL app. These monitors are built based on logs and metrics datasets and have preset thresholds based on industry best practices and recommendations.

Monitor name Monitor description  Alert Condition Recovery Condition
MySQL - Connection refused This alert fires when connections are refused when the limit of maximum connections is reached within 5 minute time interval. <= 1


 
> 1
MySQL - High average query run time This alert fires when the average run time of SQL queries for a given schema is greater than or equal to one second within a time interval of 5 minutes. >= 1 < 1
MySQL - High Innodb buffer pool utilization This alert fires when we detect that the InnoDB buffer pool utilization is high (>=90%) within a 5 minute time interval. >= 90 < 90
MySQL - Large number of aborted connections This alert fires when we detect that there are 5 or more aborted connections identified within a time interval of 5 minutes. >= 5 < 5
MySQL - Large number of internal connection errors This alert fires when we detect that there are 5 or more internal connection errors within a time interval of 5 minutes. >= 5

 
< 5
MySQL - Large number of slow queries This alert fires when we detect that there are 5 or more slow queries within a 5 minute time interval. >= 5 < 5
MySQL - Large number of statement errors  This alert fires when we detect that there are 5 or more statement errors within a 5 minute time interval. >= 5 < 5
MySQL - Large number of statement warnings This alert fires when we detect that there are 20 or more statement warnings within a 5 minute time interval. >= 20 < 20
MySQL - No index used in the SQL statements This alert fires when we detect that there are 5 or more statements not using an index in the sql query within a 5 minute time interval. >= 5 < 5
MySQL - Excessive Slow Query Detected  This alert fires when we detect the average time to execute a query is more than 5 seconds over a 24 hour time-period >=1 < 1
MySQL - Follower replication lag detected This alert fires when we detect that the average replication lag is greater than or equal to 900 seconds within a 5 minute time interval. >= 900 < 900 
MySQL - Instance down This alert fires when we detect that a MySQL instance is down within last 5 minutes interval. >=1 < 1