MySQL max_user_connections vs max_connections
SADLY I couldn't find any direct explanation for this query anywhere, not even in the MySQL docs.
Some people on different forums have stated that max_user_connections can never be greater than max_connections? For example: if one user has 3 max_user_connections
and another user has 15 max_user_connections
, then they say that max_connections should be at least higher 3+15 = 18
.
However, the mysql doc says the max allowed value for max_user_connections is 4294967295 , which is MUCH MORE than the maximum allowed value for max_connections is 100000 .
Can someone explain how these two parameters in MySQL affect each other.
source to share
One way to limit the use of MySQL server resources by clients is to set the global system variable
max_user_connections
to a nonzero value. This limits the number of concurrent connections that can be made by any account, but it does not limit what the client can do after connecting. Also, setting max_user_connections does not allow you to manage individual accounts. Both types of control interest in MySQL administrators.
The maximum number of concurrent client connections allowed. From default, it's 151
dagon's comment :
max_connections
= total communicationmax_user_connections
limit = user limit
Hence, the value max_user_connections
should never exceed the value max_connections
.
source to share