Description:
5.7 now has a dynamically configurable buffer pool. That's really good news.
There's a status variable which you can use to see how the change went and it's output is as follows:
root@myhost [(none)]> show global status like 'Innodb_buffer_pool_resize_status';
+----------------------------------+----------------------------------------------------+
| Variable_name | Value |
+----------------------------------+----------------------------------------------------+
| Innodb_buffer_pool_resize_status | Completed resizing buffer pool at 150109 16:33:26. |
+----------------------------------+----------------------------------------------------+
1 row in set (0.00 sec)
Unfortunately this only tells you that the change has happened but it does not tell you the previous setting
which may be interesting to know. (was it increased? was it descreased? what was the previous setting?)
How to repeat:
See above:
Suggested fix:
If possible I'd like to see the status comment adjusted to provide the previous value.
Something like:
Completed resizing buffer pool at 150109 16:33:26, previous size: xxxxxxxxxx.
The current size can be queried by using the existing mechanisms:
root@myhost [(none)]> show global variables like 'innodb_buffer_pool_size';
+-------------------------+-------------+
| Variable_name | Value |
+-------------------------+-------------+
| innodb_buffer_pool_size | 40802189312 |
+-------------------------+-------------+
1 row in set (0.00 sec)
I notice that nothing is logged to the mysql log file. I would suggest that this change is logged there too:
2015-01-09T14:38:14.832854Z 5459381 [Info] innodb_buffer_pool_size modified from 2000000000 to 40802189312 bytes by user 'me@somewhere'
Changes of this type happen infrequently and are significant for many reasons, so having this information would be most useful.
