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.

+3


source to share


1 answer


max_user_connections

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.

max_connections

The maximum number of concurrent client connections allowed. From default, it's 151




dagon's comment :

max_connections

= total communication
max_user_connections

limit = user limit




Hence, the value max_user_connections

should never exceed the value max_connections

.

+6


source







All Articles