用了某山云服务的RDS服务,其实就是MySQL服务。扩容时碰到连接超限的错误。
[code]
User xxx already has more than 'max_user_connections' active connections
[/code]
查到的结果是总连接限制数是200,单用户限制为20
[code]
mysql> select @@max_user_connections;
+------------------------+
| @@max_user_connections |
+------------------------+
| 20 |
+------------------------+
1 row in set (0.00 sec)
mysql> select @@max_connections;
+-------------------+
| @@max_connections |
+-------------------+
| 200 |
+-------------------+
1 row in set (0.00 sec)
[/code]
用show processlist;查到的当前用户连接数已经超出了20,所以受限了。
- 阅读剩余部分 -