mysql 오픈파일 제한 갯수 설정값확인
mysql> show variables like 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 1185 |
+------------------+-------+
1 row in set (0.00 sec)
현재 오픈한 파일 갯수 확인
mysql> show status like 'open%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| Open_files | 47 |
| Open_streams | 0 |
| Open_table_definitions | 135 |
| Open_tables | 451 |
| Opened_files | 296198 |
| Opened_table_definitions | 0 |
| Opened_tables | 0 |
+--------------------------+--------+
7 rows in set (0.00 sec)