MySQL max_user_connections vs max_connections

时间:2022-03-17 07:36:43

SADLY i could not find any straight-forward explanation to this query anywhere, not even in MySQL documentations.

SADLY我无法在任何地方找到对此查询的任何直接解释,甚至在MySQL文档中都没有。

Some people in various forums said 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 the max_connections must be at least above 3+15 = 18.

各种论坛中的一些人说max_user_connections永远不会超过max_connections?例如:如果一个用户有3个max_user_connections而另一个用户有15个max_user_connections,那么他们说max_connections必须至少高于3 + 15 = 18。

However, mysql doc says, max allowed value of max_user_connections is 4294967295 which is MUCH LARGER THAN the max allowed value of max_connections is 100000.

但是,mysql doc说,max_user_connections的最大允许值是4294967295,这比max_connections的最大允许值为100000要大得多。

Can somebody please explain how do these two options in MySQL impact one another.

有人可以解释一下MySQL中的这两个选项如何相互影响。

1 个解决方案

#1


max_user_connections

One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. In addition, setting max_user_connections does not enable management of individual accounts. Both types of control are of interest to MySQL administrators.

限制客户端使用MySQL服务器资源的一种方法是将全局max_user_connections系统变量设置为非零值。这限制了任何给定帐户可以同时进行的连接数,但对连接后客户端可以执行的操作没有限制。此外,设置max_user_connections不会启用个人帐户的管理。 MySQL管理员都对这两种控件都很感兴趣。

max_connections

The maximum permitted number of simultaneous client connections. By default, this is 151

允许的最大同时客户端连接数。默认情况下,这是151


comment by dagon :

dagon的评论:

max_connections = the total connection limit
max_user_connections = the per user limit

max_connections =总连接限制max_user_connections =每个用户限制


Hence, the value of max_user_connections must never exceed the value of max_connections.

因此,max_user_connections的值绝不能超过max_connections的值。

#1


max_user_connections

One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no limits on what a client can do once connected. In addition, setting max_user_connections does not enable management of individual accounts. Both types of control are of interest to MySQL administrators.

限制客户端使用MySQL服务器资源的一种方法是将全局max_user_connections系统变量设置为非零值。这限制了任何给定帐户可以同时进行的连接数,但对连接后客户端可以执行的操作没有限制。此外,设置max_user_connections不会启用个人帐户的管理。 MySQL管理员都对这两种控件都很感兴趣。

max_connections

The maximum permitted number of simultaneous client connections. By default, this is 151

允许的最大同时客户端连接数。默认情况下,这是151


comment by dagon :

dagon的评论:

max_connections = the total connection limit
max_user_connections = the per user limit

max_connections =总连接限制max_user_connections =每个用户限制


Hence, the value of max_user_connections must never exceed the value of max_connections.

因此,max_user_connections的值绝不能超过max_connections的值。