errorCode 1040, state 08004
java.sql.SQLNonTransientConnectionException:
Data source rejected establishment of connection, message from server: "Too many connections"
查看最大连接数
mysql> show status like 'Threads%';
| Threads_cached | 58 |
| Threads_connected | 57 | ###这个数值指的是打开的连接数
| Threads_created | 3676 |
| Threads_running | 4 | ###这个数值指的是激活的连接数,这个数值一般远低于connected数值
mysql> show variables like '%max_connections%';
| max_connections | 1000 |
设置最大连接数
临时修改重启后失效
set GLOBAL max_connections=2000;
set GLOBAL max_user_connections=1500;
永久修改,修改配置文件
max_connections=2000
max_user_connections=1500
查看当前正在执行的MySQL连接
show processlist
mysqladmin -u<user> -p<pwd> -h<host> status
mysqladmin -u<user> -p<pwd> -h<host> extended-status