MySQL5.7: 动态调整buffer pool size

  1. 云栖社区>
  2. 博客>
  3. 正文

MySQL5.7: 动态调整buffer pool size

zhaiwx_yinfeng 2016-05-10 15:09:00 浏览2035
展开阅读全文

在5.7.5中提供了一个新功能,能够动态的对buffer pool size进行调整。

对应的changelog entry:

InnoDB: The innodb_buffer_pool_size parameter is now dynamic, allowing you to resize the buffer pool without restarting the server. The resizing operation, which involves moving pages to a new location in memory, is performed chunks. Chunk size is configurable using the new innodb_buffer_pool_chunk_size con

网友评论

登录后评论
0/500
评论
zhaiwx_yinfeng
+ 关注