Add max_concurrent_select_queries and max_concurrent_insert_queries Settings

Why it matters

These settings allow database administrators to limit the concurrency of SELECT and INSERT queries independently. This helps in managing system resources more effectively, preventing overload caused by too many simultaneous queries of a particular type, thereby improving stability and performance.

How to use it

To enable these limits, configure the settings max_concurrent_select_queries and max_concurrent_insert_queries in your ClickHouse server configuration or at runtime, specifying the maximum allowed concurrent SELECT or INSERT queries respectively.