问题描述:
[多选]
Which three statements are true about memory buffer allocation by a MySQL Server?()关于MySQL服务器的内存缓冲区分配,哪三种说法是正确的
A.Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed. 全局缓冲区(如InnoDB缓冲池)是在服务器启动后分配的,不会被释放。
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.
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
上一篇:Consider typical High Availability()solutions that do not use shared storage.Which three HA solutions do not use shared storage?(考虑不使用共享的典型高可用性(HA)解决方案储藏室。哪个三个HA解决方案不使用共享存储?
下一篇:Which three methods will show the storage engine for the Country table?()哪三种方法将显示Country表的存储引擎
- 我要回答: 网友(216.73.216.168)
- 热门题目: 1.某医师随机抽取性别、病情严重 2.某糖尿病患者为了控制血糖,在 3.先天性舌系带附着异常或过短畸
