MySQL5.7 OCP每日一题--Question: 8

Question: 8

Which two options describe how MySQL Server allocates memory? 
A. Each connection may have its own per-thread memory allocations. 
B. Thread memory is pre-allocated up to thread_cache_size for performance. 
C. Each thread allocates memory from a global pool. 
D. Global memory resources are allocated at server startup. 
复制

答案：AD
解析：thread_cache是用于缓存客户端连接断开后的线程；Thread memory是动态分配；mysql直接从system分配内存给线程。