Which of the following are true regarding the table cache?

Question

Options

• AIt is used to cache row data in open tables.
• BIt holds file descriptors for open tables.
• CThe size of the table cache may be set per-session
• DEach connection has its own table cache. They are of equal size, set globally.
• EThere is one table cache, shared among all sessions.
• FIncreasing the size of the variable table_cache allows mysqld to keep more tables open

• A
  14% (5)
• B
  73% (27)
• C
  8% (3)
• D
  5% (2)

Explanation

This section discusses server parameters for resources that affect server performance as a whole or that are shared among clients. The table cache that holds information about tables that storage engines have open. When the server opens a table, it maintains information about that table in the table cache, which is used to avoid reopening tables when possible. Against this goal you must balance the fact that with a larger table cache the server requires more file descriptors. Operating systems place a limit on the number of file descriptors allowed to each process, so the table cache cannot be made arbitrarily large. However, some operating systems do allow the per-process file descriptor limit to be reconfigured.

No community discussion yet for this question.