Level: Warning

Purpose: Reports when queries are running slow in the database.

Scenario: MySQL server has been having some slow queries for 5m.

Resolution: Log into MySQL as a root or writer account. Check the running queries by typing: select * from information_schema.PROCESSLIST p where p.COMMAND = 'query'; Kill any long running queries that are not required, like old EMS widget, by getting the process id from the above query and typing kill <id>; or for an AWS RDS database, CALL mysql.rds_kill_query(<id>);

Manual Action Steps: Kill any unnecessary long running queries.

Auto Clear: When all running queries are not running for long