Post

MySQL Too Many Connections 에러

Posted Updated
By dejavuhyo 1 min read

1. 오류 메시지

1

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Too many connections

2. 설정확인

1) 현재 max_connections 확인

1

mysql> show variables like 'max_connections';

2) Max_used_connections 확인

1

mysql> show status like 'Max_used_connections';

3) 클라이언트 차단, 커넥션 차단 확인

1

mysql> show status like 'Aborted%';

3. 해결방법

1) 온라인 설정

즉시 적용된다.

1

mysql> set global max_connections=500;

2) 영구 설정

  • 편집
1

[root@localhost ~]# vi /etc/my.cnf
  • 추가
1
2

[mysqld]
max_connections = 500
  • 재시작
1

[root@localhost ~]# service mysqld restart

[출처 및 참고]

Database, MySQL
mysql-too-many-connections too-many-connections mysql-max-connections mysql-connections max-connections connections
This post is licensed under CC BY 4.0 by the author.