MySQL

How to Change innodb_buffer_pool_size Online

If you’d like to raise innodb_buffer_pool_size without restarting myqld, you can set the variable at run-time. The unit is bytes.
mysql> set global innodb_buffer_pool_size = 5368709120;
Query OK, 0 rows affected (0.01 sec)

mysql> show variables like 'innodb_buffer_pool_size';
+-------------------------+------------+
| Variable_name           | Value      |
+-------------------------+------------+
| innodb_buffer_pool_size | 5368709120 |
+-------------------------+------------+
1 row in set (0.00 sec)

Please note that, you can’t set the value less than the current one at run-time.

Leave a Reply

Your email address will not be published. Required fields are marked *