Mysql Kill Long Running Queries Jun 2026

MySQL provides two ways to stop a runaway process, depending on whether you want to keep the user's connection alive. Recommended Use

Use when an application needs to remain connected but needs a specific heavy query stopped. mysql kill long running queries

A simple bash script to find and kill queries older than a certain threshold: MySQL provides two ways to stop a runaway

: Run SHOW FULL PROCESSLIST; in the MySQL command line. mysql kill long running queries

To find long-running queries, you can use the following methods:

for id in $(mysql -e "SHOW PROCESSLIST" -sN | awk -F ' ' '$9 "'" > $THRESHOLD "'" print $1' | grep -v Id) do mysql -e "KILL $id" echo "Killed query $id" done