MySQL max connections 설정

1 확인

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+
1 row in set (0.00 sec)

mysql> show status like 'Max_used_connections';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Max_used_connections | 152   |
+----------------------+-------+
1 row in set (0.00 sec)

2 온라인 설정

• 즉시 적용됨

mysql> set global max_connections=500;
Query OK, 0 rows affected (0.00 sec)

3 영구 설정

• my.cnf에 max_connections 설정 추가
• mysqld 재시작시에 적용됨

[root@zetadb ~]# vi /etc/my.cnf

[mysqld]
max_connections = 500

4 확인 2

mysql> show variables like 'max_connections';
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 500   |
+-----------------+-------+
1 row in set (0.00 sec)