[SQL] MySQL DB Connection 확인

 

MySQL을 사용하다 보면 Too many connections 에러가 발생하면서 접속이 불가할 때가 있다. DB에 설정된 최대 허용 커넥션 개수를 초과해서 나타난 오류이다.

1. DB Connection(상태)

SHOW PROCESSLIST;

2. DB Connection(최대 접속 가능한 수)

SHOW VARIABLES LIKE '%max_connect%';

3. DB Connection(현재 접속 수)

SHOW STATUS LIKE 'Threads_connected';

4. DB Connection(동작중인 Connection 수)

SHOW STATUS LIKE 'Threads_running';