-- set innodb_buffer_pool_size = 10G
SET GLOBAL innodb_buffer_pool_size=(10 * 1024 * 1024 * 1024);
-- show global status
SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool_resize_status';
+----------------------------------+----------------------------------------------------+
| Variable_name | Value |
+----------------------------------+----------------------------------------------------+
| Innodb_buffer_pool_resize_status | Completed resizing buffer pool at 210727 16:30:38. |
+----------------------------------+----------------------------------------------------+