Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

max_concurrent_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

max_concurrent_queries_for_all_users

Type
UInt64
Default
0

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

Cloud default value: 1000.

max_concurrent_queries_for_user

Type
UInt64
Default
0

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>
Navigation