Differences

This shows you the differences between two versions of the page.

--- resolution_area:prometheus_resolutions:res-p1707 [2021/06/25 10:09] – external edit 127.0.0.1
+++ resolution_area:prometheus_resolutions:res-p1707 [2021/07/05 12:12] (current) – 10.91.120.28
@@ Line 5: / Line 5: @@
 **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

Internal Errigal Collaboration Wiki