max_concurrent_* session settings

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

max_concurrent_queries_for_all_users

Throw exception if the current number of simultaneously processed queries reaches or exceeds this setting’s value.

Example: max_concurrent_queries_for_all_users can be set to 99 for all users and database administrator can set it to 100 for themselves to run queries for investigation even when the server is overloaded.

Modifying the setting for one query or user does not affect other queries.

Possible values:

• Positive integer.
• 0 — No limit.

Example

<max_concurrent_queries_for_all_users>99</max_concurrent_queries_for_all_users>

See Also

• max_concurrent_queries

Cloud default value: 1000.

max_concurrent_queries_for_user

The maximum number of simultaneously processed queries per user.

Possible values:

• Positive integer.
• 0 — No limit.

Example

<max_concurrent_queries_for_user>5</max_concurrent_queries_for_user>