How to Find and Kill Queries in MySQL

20 February 2023 · 1 min read · MySQL, Queries

Contents

Every once in a while I need to find and kill rogue queries in MySQL. First, list all running queries:

1

SHOW PROCESSLIST;

Once the correct query has been identified, kill it by ID:

1

KILL QUERY <ID>;