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)TT860
15MySQL 기본키와 유일키, 외래키 (primary key, unique key and foreign key)TT1080
14Anysign4pc안녕1470
13리눅스 CPU정보 확인TT1240
12How to set up MySQL max connectionsTT1590
11How to check HTTPS active connections on linuxTT1350
10AWS 비용계산기TT1400
9[MySQL] reducing memory usage on cloud serverTT1740
8crontab usageTT1690
7SQL NULL검색TT1600
6안드로이드 스튜디오 vs 이클립스TT1730
530년 경력 개발자의 조언.jpgTT1580
4MySQL 쿼리문 메모TT1900
3자바 SDK설치하기TT1970
2안드로이드 스튜디오 설치하고 앱개발하기 2TT2250


One Line Message