Differences

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

--- resolution_area:prometheus_resolutions:res-p1707 [2021/06/24 15:16] – btobin
+++ resolution_area:prometheus_resolutions:res-p1707 [2021/07/05 12:12] (current) – 10.91.120.28
@@ Line 1: / Line 1: @@
+===== 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

Internal Errigal Collaboration Wiki