728x90
Property | Value |
---|---|
System Variable | table_open_cache |
Scope | Global |
Dynamic | Yes |
Type | integer |
Default Value | 2000 |
Minimum Value | 1 |
Maximum Value | 524288 |
The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can check whether you need to increase the table cache by checking the Opened_tables
status variable. See Section 5.1.7, “Server Status Variables”. If the value of Opened_tables
is large and you do not use FLUSH TABLES
often (which just forces all tables to be closed and reopened), then you should increase the value of the table_open_cache
variable. For more information about the table cache, see Section 8.4.3.1, “How MySQL Opens and Closes Tables”.
'DB TUNE' 카테고리의 다른 글
[MySQLD] Tunner (0) | 2018.04.19 |
---|---|
[MySQLD] innodb_file_per_table (0) | 2018.04.19 |
MySQL 튜닝 값을 탐지해주는 유용한 툴 (0) | 2018.04.19 |
[MySQLD] join_buffer_size (0) | 2018.04.19 |
MySQLD DataBase tune (0) | 2018.04.19 |