📊 MySQL
Q. Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?
  • (A) delayed_queue_size
  • (B) table_cache
  • (C) max_allowed_packet
  • (D) max_connect
💬 Discuss
✅ Correct Answer: (B) 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

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