DB TUNE

[MySQLD] table_open_cache

Remoted remoted 2018. 4. 19. 18:36

table_open_cache

PropertyValue
System Variabletable_open_cache
ScopeGlobal
DynamicYes
Typeinteger
Default Value2000
Minimum Value1
Maximum Value524288

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] table_open_cache  (0) 2018.04.19
[MySQLD] join_buffer_size  (0) 2018.04.19
MySQLD DataBase tune  (0) 2018.04.19
1 ··· 4 5 6 7 8 9 10