Which three statements are true about memory buffer allocation by a MySQL Server?

Which three statements are true about memory buffer allocation by a MySQL Server?

Which three statements are true about memory buffer allocation by a MySQL Server?

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.

D.
User buffers are allocated at server startup and freed when the user is dropped.

E.
All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated
globally, and are never freed.

Explanation:

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

mutex

mutex

A: true
B: true, but thread_cache may not deallocate memory
C: true
D: false, there are no user buffers
E: false, 5.6 doesn’t have persistent dynamic buffers. 5.7 allows resizing innodb_buffer_pool_size

Reply