-
Which command controls the maximum number of tables that the cache can hold?
-
- open_files_limit
- read_buffer_size
- table_open_cache
- table_definition_cache
- None of these
Correct Option: C
The option for table cache is table_open_cache. It controls the maximum number of tables that the cache can hold, we set the variable equal to the total number of table, table_definition_cache is the lightweight partner to table cache.
