===== MysqlSlowQueries (#)=====

**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