Q. Which system variable controls the size of the table cache?

  • (A) table_cache
  • (B) libmysqlb
  • (C) open_cache
  • (D) cache_open
💬 Discuss
✅ Correct Answer: (A) table_cache
Explanation: table_cache: This is the correct option. The table_cache system variable in MySQL controls the size of the table cache. It determines the maximum number of open tables that MySQL keeps cached in memory for quick access.

Published by Vinay ⭐ 28.75K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Vinay
table_cache: This is the correct option. The table_cache system variable in MySQL controls the size of the table cache. It determines the maximum number of open tables that MySQL keeps cached in memory for quick access.

💬 Discussion

📊 Question Analytics

👁️
126
Total Visits
📽️
1 y ago
Published
🎖️
Vinay
Publisher
📈
84%
Success Rate