User Tools

Site Tools


resolution_area:watchdog_resolutions:res-w9804

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
resolution_area:watchdog_resolutions:res-w9804 [2021/12/23 18:18] 10.91.120.28resolution_area:watchdog_resolutions:res-w9804 [2023/03/23 14:34] (current) 10.91.110.100
Line 16: Line 16:
 Allow a few hours for the query to finish executing. If this does not happen: Allow a few hours for the query to finish executing. If this does not happen:
 <code>show processlist;</code> - Look for the longest running query and investigate if the origin of the query, if it can be killed and if it needs changing. <code>show processlist;</code> - Look for the longest running query and investigate if the origin of the query, if it can be killed and if it needs changing.
 +
 +To kill the process (get the process id from the process list):
 +<code>kill <insert processid here></code>
 +For Amazon RDS (get the process id from the process list):
 +<code>CALL mysql.rds_kill(<insert processid here>)</code>
  
 **Auto Clear:** **Auto Clear:**
 Yes Yes
resolution_area/watchdog_resolutions/res-w9804.1640283537.txt.gz · Last modified: 2021/12/23 18:18 by 10.91.120.28