This shows current max connections for mysql.

mysql> show variables like 'max_connections';

 

This shows current used connections for now.

mysql> show status like 'Max_used_connections';

 

To check how many connections were aborted. If you see aborted connection, you might need to increase max connection settings.

mysql> show status like 'Aborted%';

 

To change max connections:

mysql> set global max_connections=300;

 

If you want permanent settings:

# vi /etc/my.cnf
[mysqld]
max_connections = 300

 

You need to restart to make the change of /etc/my.cnf to be effective.

service mysqld restart

 

and check it again:

mysql> show variables like 'max_connections';






TitleNickname
16리눅스 압축 및 압축풀기 (tar, gz, bz2)TT270
15MySQL 기본키와 유일키, 외래키 (primary key, unique key and foreign key)TT620
14Anysign4pc안녕550
13리눅스 CPU정보 확인TT660
12How to set up MySQL max connectionsTT890
11How to check HTTPS active connections on linuxTT720
10AWS 비용계산기TT900
9[MySQL] reducing memory usage on cloud serverTT1050
8crontab usageTT1110
7SQL NULL검색TT960
6안드로이드 스튜디오 vs 이클립스TT1090
530년 경력 개발자의 조언.jpgTT1130
4MySQL 쿼리문 메모TT1340
3자바 SDK설치하기TT1300
2안드로이드 스튜디오 설치하고 앱개발하기 2TT1510


One Line Message