Managing Runaway Queries (v8.5+)

Lab Description

In this lab, we show you how to identify and manage queries that consume more resources than expected (runaway queries), as well as monitor potential runaway queries. TiDB provides the capability to manage the runaway queries in the resource control feature. You can set criteria for a resource group to identify runaway queries and automatically take actions to prevent them from exhausting resources and affecting other queries. Furthermore, you can also use runaway watches to quickly identify runaway queries for a given SQL statement or digest.