mariadb(mysql) open_files_limit 설정값

https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_open_files_limit

 

open_files_limit 값은 my.cnf에 설정을 하거나 –open-files-limit 지정을 해도 global variables 값이 다를 수 있습니다.

해당 값은 아래 3가지 조건중에 큰값으로 된다고 합니다.

1) 10 + max_connections + (table_open_cache * 2)
2) max_connections * 5
3) open_files_limit value specified at startup, 5000 if none

 

mariadb는 아래와 같이 설명되어 있습니다.

If set to 0, then mysqld will reserve max_connections*5 or max_connections + table_open_cache*2 (whichever is larger) number of files.

https://mariadb.com/kb/en/mariadb/server-system-variables/#open_files_limit

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s