📊 MySQL
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
💬 Discuss
✅ Correct Answer: (D) table_cache

Explanation: 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.

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.

💬 Discussion

📊 Question Analytics

👁️
176
Total Visits
📽️
4 y ago
Published
🎖️
Nitin Gupta
Publisher
📈
92%
Success Rate