Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 131

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

    Correct Answer: A

    The InnoDB buffer pool should ideally be divided such that each instance is roughly 1 GiB in size. Given that the buffer pool size is 12 GiB, increasing the number of buffer pool instances to 16 ensures that each instance would be 0.75 GiB, which is closer to the recommended 1 GiB per pool than the currently configured 8 (each being 1.5 GiB). Increasing the number of instances to 32 would make each instance too small (0.375 GiB), and decreasing them would make each instance too large.

Discussion
marklvOption: B

"In general, when setting innodb_buffer_pool_instances, it's a good idea to match the maximum number of MySQL threads that will be running simultaneously." so 32, or B I think

marklvOption: D

I don't see clear documentation. 1 GB per pool is recommended, I think. so 12?

marklv

Ignore this statement. 32 threads so 32 is it.