Oracle
1Z0-883 · Question #46
Which three statements are true about memory buffer allocation by a MySQL Server?
The correct answer is A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed. B. Thread buffers are allocated when a client connects, and are freed when the client disconnects. C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends. See the full explanation below for the reasoning.
Question
Which three statements are true about memory buffer allocation by a MySQL Server?
Options
- AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
- BThread buffers are allocated when a client connects, and are freed when the client disconnects.
- CBuffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
- DUser buffers are allocated at server startup and freed when the user is dropped.
- EAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally,
How the community answered
(21 responses)- A76% (16)
- D10% (2)
- E14% (3)
Community Discussion
No community discussion yet for this question.