Which system variable enables mysqld to keep more tables open simultaneously?
(a) table_cache
(b) max_connect
(c) delayed_queue_size
(d) max_allowed_packet
(a) table_cache
(b) max_connect
(c) delayed_queue_size
(d) max_allowed_packet
Correct choice is (a) table_cache
To explain I would say: The ‘table_cache’ stores the size of the table cache. Increasing the value enables ‘mysqld’ to keep more tables open simultaneously by reducing the number of files open and close operations.