MariaDB open_files_limit 변경

MariaDB open_files_limit 변경

1 확인

MariaDB [(none)]> SHOW VARIABLES LIKE 'open_files_limit';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 1024  |
+------------------+-------+
1 row in set (0.00 sec)

2 변경

• cnf 파일의 [mysqld] 영역에 내용 추가

vi /etc/mysql/mariadb.conf.d/50-server.cnf

[mysqld]
open_files_limit = 3072

• MariaDB 재시작

root@zetawiki:~# /etc/init.d/mysql restart
[ ok ] Restarting mysql (via systemctl): mysql.service.

3 확인 2

MariaDB [(none)]> SHOW VARIABLES LIKE 'open_files_limit';
+------------------+-------+
| Variable_name    | Value |
+------------------+-------+
| open_files_limit | 3072 |
+------------------+-------+
1 row in set (0.00 sec)

4 참고

• http://minsql.com/mysql/mysql-open_files_limit-변경하기/