[MDEV-15618] Clarify max_user_connections documentation Created: 2018-03-21  Updated: 2020-08-25  Resolved: 2018-04-13

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Ben Stillman Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

https://mariadb.com/kb/en/library/server-system-variables/#max_user_connections

The description current says:

"Maximum simultaneous connections permitted for a user account. If set to 0, the default, there is no per-user limit. The session value is read-only and takes the global value unless there's a nonzero MAX_USER_CONNECTIONS value for the user. Previously having a minimum value of 0, from MariaDB 5.3, max_user_connections can be set to -1 to stop users from connecting to the server. The global max_user_connections variable does not affect users with the SUPER privilege."

This isn't very clear. Recommendation:

"Maximum simultaneous connections permitted for each user account. If set to 0, the default, global user connection limits are disabled and the variable is read-only. The session variable is always read-only, only privileged users can modify users' limits. The session variable is equal to the global max_user_connections value unless the specific user MAX_USER_CONNECTIONS (https://mariadb.com/kb/en/library/create-user/#max_user_connections) is a nonzero value. If both global max_user_connections and specific user MAX_USER_CONNECTIONS are set, the user specific MAX_USER_CONNECTIONS value is used. From MariaDB 5.3, max_user_connections can be set to -1 to stop users from connecting to the server. The global max_user_connections variable does not affect users with the SUPER privilege."

Additionally, the value for Dynamic should be changed or a note added. It isn't dynamic when max_user_connections = 0, which is the default.


Generated at Thu Feb 08 08:22:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.