ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
来源:互联网 发布:网络与新媒体概论笔记 编辑:程序博客网 时间:2024/05/16 15:26
同事说MySQL测试服务器超出了最大连接数,要求调整max_connections。
mysql> show variables like '%connect%';
+--------------------------+-------------------+
| Variable_name | Value |
+--------------------------+-------------------+
| character_set_connection | latin1 |
| collation_connection | latin1_swedish_ci |
| connect_timeout | 10 |
| init_connect | |
| max_connect_errors | 10 |
| max_connections | 1000 |
| max_user_connections | 100 |
+--------------------------+-------------------+
7 rows in set (0.00 sec)
从列表中看到MySql中的最大连接数max_connections设置为1000。
经过查询show processlist看目前服务器的连接数量远没有达到1000.
再来看错误‘ User root already has more than 'max_user_connections' active connections’
是说超出了max_user_connections的限制。
于是修改了max_user_connections
mysql> set global max_user_connections=200;
Query OK, 0 rows affected (0.00 sec)
max_connections 是指MySQL服务器的最大连接数。即所有用户最大连接数的和。
max_user_connections 是指MySQL中单个用户的最大连接数。
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User ivr already has more than 'max_user_connections' active connections
- User perf_inventory already has more than 'max_user_connections' active connections
- SQLSTATE[HY000] [1203] User xxx already has more than 'max_user_connections' active co
- [MySQL]记录一次线上故障处理过程--> has more than 'max_user_connections' active connections
- [MySQL]记录一次线上故障处理过程--> has more than 'max_user_connections' active connections
- ERROR 1226 (42000):User 'root' has exceeded the 'max_questions' resource (current value: 2)
- lua has more than 60 upvalues 解决办法
- ERROR 1172 (42000): Result consisted of more than one row
- error: more than one device and emulator
- error: more than one device and emulator .
- error: more than one device and emulator
- error: more than one device and emulator
- error: more than one device and emulator .
- error: more than one device/emulator
- Adb error: more than one device/emulator
- SVM
- hdu_5672_Strings BestCoder Round #81 (div2)
- 如何克服录制回放模式的弊端
- 【小技巧】制作一个滑动过渡切换的导航条
- Codeforces #669 Div2 C. Little Artem and Matrix(模拟)
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- 【hiho一下-95】 扩展欧几里得算法
- WPF样式和行为
- CountDownLatch理解一:与join的区别 Done
- HTTP协议的状态码
- mysql 语句优化
- String.format()用法
- 阿里移动推荐-Markel
- Android 中AIDL的使用与理解