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)TT610
15MySQL 기본키와 유일키, 외래키 (primary key, unique key and foreign key)TT900
14Anysign4pc안녕880
13리눅스 CPU정보 확인TT1000
12How to set up MySQL max connectionsTT1200
11How to check HTTPS active connections on linuxTT1040
10AWS 비용계산기TT1110
9[MySQL] reducing memory usage on cloud serverTT1450
8crontab usageTT1440
7SQL NULL검색TT1300
6안드로이드 스튜디오 vs 이클립스TT1440
530년 경력 개발자의 조언.jpgTT1370
4MySQL 쿼리문 메모TT1650
3자바 SDK설치하기TT1650
2안드로이드 스튜디오 설치하고 앱개발하기 2TT1920


One Line Message