Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

===== MysqlHighThreadsRunning =====

**Level:** Warning


**Purpose:**
This alert is to ensure that the applications aren't doing to much with the Database at the same time. If a thread is slow or stuck in a running state then we must investigate.

**Scenario:** More than 60% of MySQL connections have been in a running state on <server> for 5m.

**Resolution:**
Start investigating by connecting to the server and running the following query:

<code>
SHOW PROCESSLIST;
</code>

If there are many query that are trying to read from the database for the reporting manager or a search application then you may have to cancel some of these.
Generally, this isn't necessary unless there are other problems being caused because of this. If something was stuck, the you will likely be dealing with a long running query rather than pile of queries at once.

**Manual Action Steps:**
<code>
SHOW PROCESSLIST;
</code>

If there is an application that is erroniously hammering the database with queries and requests then you may have to ask operations and the dev team about stopping the application. 

**Auto Clear:**
This will clear once less than 60% of the connections to the server are active

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools