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
  • Correct Answer - Option(D)
  • Views: 129
  • Filed under category MySQL
Explanation by: Nitin Gupta
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.

Question analytics