My Oracle Support Banner

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 later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.