How To Kill Long Running Queries At A Time
(Doc ID 2739437.1)
Last updated on MARCH 24, 2021
Applies to:
MySQL Server - Version 8.0 and laterInformation in this document applies to any platform.
Goal
In some cases, many queries stuck at running state for very long time, and they eat up computer resources such as CPU, and memory, and the server may slow down as a result. In such case, you might want to terminate long running queries to get back server performance. If so many long running queries exist, killing queries can be a troublesome task.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |