Level: Critical

Purpose: To notify about long running queries which can negatively affect database performance. Some of these queries might not finish executing for days.

Scenario: A query can be executed, usually by the user, which requires too many resources to process in a feasible amount of time. This also happens often for reports that use too wide of a date range, or in heavy reports that are usually scheduled.

Resolution: This watchdog will resolve itself most of the time and it is important to let it resolve if it happens within a few hours. A resolution will occur when the process that exists for the extended period of time disappears.

Manual Action Steps: Allow a few hours for the query to finish executing. If this does not happen:

show processlist;

- Look for the longest running query and investigate if the origin of the query, if it can be killed and if it needs changing.

Auto Clear: Yes