连接测试环境mysql时报错:
连接只有两个ERROR 1203 (42000): User tiger already has more than 'max_user_connections' active connections
step 1 、先查看当前链接数
show variables like '%connect%';
输出,说明max_user_connections 设置是500,而我的测试环境不会有500个user连接
+-----------------------------------------------+--------------------+
| Variable_name | Value |
+-----------------------------------------------+--------------------+
| character_set_connection | utf8mb4 |
| collation_connection | utf8mb4_0900_ai_ci |
| connect_timeout | 10 |
| disconnect_on_expired_password | ON |
| init_connect | |
| max_connect_errors | 100 |
| max_connections | 1000 |
| max_user_connections | 500 |
| mysqlx_connect_timeout | 30 |
| mysqlx_max_connections | 100 |
| performance_schema_session_connect_attrs_size | 512 |
+-----------------------------------------------+--------------------+
如果是max_user_connections 的设置值比较小,可以通过
set max_user_connections=1000设置 用户链接数
或者修改/etc/mysql/mysql.conf.d/mysqld.cnf
max_user_connections:1000 设置上限
select * from information_schema.processlist order by time desc;
# 或
show processlist;
查看发现有很多sleep的链接,在创建mysql的时候使用默认配置,wait_timeout时间太长了,调试的时候反复突然中断,很多链接没有关闭。
解决:
/etc/mysql/mysql.conf.d/mysqld.cnf
增加
wait_timeout=100