MySQL 7 在线扩容 innodb_buffer_pool_size

 

mysql>  show variables like 'innodb_buffer_pool_instances';
+------------------------------+-------+
| Variable_name                | Value |
+------------------------------+-------+
| innodb_buffer_pool_instances | 2     |
+------------------------------+-------+

mysql> show variables like 'innodb_buffer_pool_size';
 

 

 mysql>  set global innodb_buffer_pool_size=8589934592;

 

2018-04-19T06:46:38.032553Z 0 [Note] InnoDB: Resizing buffer pool from 4294967296 to 8589934592 (unit=134217728).
2018-04-19T06:46:38.032601Z 0 [Note] InnoDB: Disabling adaptive hash index.
2018-04-19T06:46:38.059309Z 1001894 [Note] InnoDB: Resizing buffer pool from 4294967296 to 8589934592 (unit=134217728). (new size: 8589934592 bytes)
2018-04-19T06:46:38.090543Z 0 [Note] InnoDB: disabled adaptive hash index.
2018-04-19T06:46:38.090593Z 0 [Note] InnoDB: Withdrawing blocks to be shrunken.
2018-04-19T06:46:38.090609Z 0 [Note] InnoDB: Latching whole of buffer pool.
2018-04-19T06:46:38.090626Z 0 [Note] InnoDB: buffer pool 0 : resizing with chunks 16 to 32.
2018-04-19T06:46:38.267048Z 0 [Note] InnoDB: buffer pool 0 : 16 chunks (131072 blocks) were added.
2018-04-19T06:46:38.267082Z 0 [Note] InnoDB: buffer pool 1 : resizing with chunks 16 to 32.
2018-04-19T06:46:38.371513Z 0 [Note] InnoDB: buffer pool 1 : 16 chunks (131072 blocks) were added.
2018-04-19T06:46:38.371645Z 0 [Note] InnoDB: Completed to resize buffer pool from 4294967296 to 8589934592.
2018-04-19T06:46:38.371652Z 0 [Note] InnoDB: Re-enabled adaptive hash index.
2018-04-19T06:46:38.371665Z 0 [Note] InnoDB: Completed resizing buffer pool at 180419 14:46:38.