v.1.1.54380Improvement

Simple SELECT Queries from system.processes Exempt from max_concurrent_queries Limit

Official CH changelog text
Simple SELECT queries from the system.processes table are not included in the max_concurrent_queries limit.
Simple SELECT queries on the system.processes table are now excluded from the max_concurrent_queries limit enforcement.

Why it matters

This feature prevents simple monitoring queries on system.processes from counting towards the limit on concurrent queries, thus avoiding unintended blocking or limiting of these lightweight system inspection queries. It improves usability by allowing uninterrupted access to system information even when the query concurrency limit is reached.

How to use it

No explicit action is required from users. This behavior is applied automatically for simple SELECT statements on the system.processes table.
PreviousNext