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';






제목별명
15MySQL 기본키와 유일키, 외래키 (primary key, unique key and foreign key)TT190
14Anysign4pc안녕200
13리눅스 CPU정보 확인TT310
12How to set up MySQL max connectionsTT350
11How to check HTTPS active connections on linuxTT320
10AWS 비용계산기TT500
9[MySQL] reducing memory usage on cloud serverTT590
8crontab usageTT820
7SQL NULL검색TT680
6안드로이드 스튜디오 vs 이클립스TT710
530년 경력 개발자의 조언.jpgTT790
4MySQL 쿼리문 메모TT940
3자바 SDK설치하기TT960
2안드로이드 스튜디오 설치하고 앱개발하기TT880


One Line Message