Q77
Which system variable controls the size of the table cache?
A.
table_cache
AnswerB.
cache_table
C.
open_cache
D.
cache_open
Answer: Option A
Solution
Answer: Option A
Solution:
table_cache: This is the correct option. The table_cache system variable in MySQL controls the size of the table cache. It determines the maximum number of open tables that MySQL keeps cached in memory for quick access.cache_table: This option is incorrect. "cache_table" is not a recognized system variable in MySQL for controlling the size of the table cache.
open_cache: This option is incorrect. "open_cache" is not a recognized system variable in MySQL for controlling the size of the table cache.
cache_open: This option is incorrect. "cache_open" is not a recognized system variable in MySQL for controlling the size of the table cache.
Therefore, the system variable that controls the size of the table cache in MySQL is Option A: table_cache.