MySQL :: MySQL 5.7 Reference Manual :: 8.9.1.1 Resizing the InnoDB Buffer Pool Online

Section Navigation [Toggle] 8.9.1 The InnoDB Buffer Pool8.9.1.1 Resizing the InnoDB Buffer Pool Online As of MySQL 5.7.5, the innodb_buffer_pool_size configuration option can be set dynamically, which allows you to resize the buffer pool without restarting the server. For example: mysql> SET GLOBAL innodb_buffer_pool_size=2147483648 The resizing operation is performed by a background thread.

[rrreeeyyy]

When initiating a resizing operation, the operation does not start until all active transactions are completed.