v.1.1.54289New Feature

Added max_network_bandwidth_for_user Setting to Limit User Bandwidth Usage

Added the max_network_bandwidth_for_user setting to restrict the overall bandwidth use for queries per user.
Introduces the max_network_bandwidth_for_user setting to limit the total network bandwidth used by queries from a single user in ClickHouse.

Why it matters

This feature was created to address scenarios where individual users may consume excessive network bandwidth running queries, potentially impacting the overall system performance and fairness among users. By limiting bandwidth usage per user, it ensures more predictable resource allocation and better control over network load in multi-user environments.

How to use it

Set the max_network_bandwidth_for_user setting in the user profile or session configuration to a desired bandwidth limit (in bytes per second). This restricts the cumulative network usage of queries executed by that user. For example:

SET max_network_bandwidth_for_user = 10485760; -- limits user bandwidth to 10 MB/s


Alternatively, configure it in the users.xml profile definition to apply the limit persistently for that user.