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';

原文地址:https://www.cnblogs.com/wokofo/p/8125654.html