How to kill queries in TiDB?

[sykp241095]

Original author: prateekrckstr
Original time: 2025-02-18 13:00:59.220478
Original ID/Slug: 10430 / how-to-kill-queries-in-tidb

How can we identify and manage long-running queries in TiDB v4.0.14 that cause high CPU usage and I/O operations, leading to potential bottlenecks in the TiDB cluster? Is there a way to find these queries and terminate them efficiently?

[sykp241095]

Original author: Hazel
Original time: 2025-02-18 15:14:52.688357

Hi @prateekrckstr , maybe ‘show process list’ works. Btw, you can also check the solution in this post: TiDB long running queries