Home / Programming MCQs / MySQL MCQs / Question

N

Nitin Gupta • 1.72K Points
Master

Q. Which system variable enables mysqld to keep more tables open simultaneously?

(A) max_connect
(B) delayed_queue_size
(C) max_allowed_packet
(D) table_cache
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 file open and close operations.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.