51ak.blogs

Mysql5.7动态修改innodb_buffer_pool_size

SELECT @@innodb_buffer_pool_size,@@innodb_buffer_pool_chunk_size,@@innodb_buffer_pool_instances;
SET GLOBAL innodb_buffer_pool_size=92341796864;
SHOW STATUS WHERE Variable_name='InnoDB_buffer_pool_resize_status';

posted on 2017-12-27 14:41  51ak  阅读(382)  评论(0编辑  收藏  举报

导航