v.24.3New Feature

Separate Limits for Waiting and Executing Queries in Server Settings

Official CH changelog text
Separate limits on number of waiting and executing queries. Added new server setting max_waiting_queries that limits the number of queries waiting due to async_load_databases. Existing limits on number of executing queries no longer count waiting queries. #61053 (Sergei Trifonov).
Introduced a new server setting max_waiting_queries to separately limit the number of queries waiting due to async_load_databases, decoupling waiting queries from executing query limits.

Why it matters

This feature addresses the issue of waiting queries blocking the count towards executing queries limits, allowing finer control and better resource management by distinguishing between queries that are waiting for asynchronous database loading and those actively executing.

How to use it

Configure the max_waiting_queries server setting to specify the maximum number of queries allowed to wait due to async_load_databases. The existing limits on executing queries remain unaffected by waiting queries.

Related resources

PreviousNext