Which two statements are true about setting the per-thread buffers higher than required?
A.
More memory per thread is beneficial in all scenarios.
B.
It causes increased overhead due to initial memory allocation.
C.
It can affect system stability during peak load times, due to swapping.
D.
It requires increasing the thread_cache_size variable.
Explanation:
B and C.
B, C
A- false. you can end your memory and end in OOM or paging.
B- true, if `initial` means at thread creation and not at mysqld startup.
C- true
D- false. the thread_cache_size should be increased independently of per-thread buffers.