MySQL5.7 在线调整Innodb_Buffer_Pool_size不用重启mysql进程(二)

2014-11-24 17:12:07 · 作者: · 浏览: 1
967296 to 134217728. (unit=134217728)


[Note] InnoDB: disabled adaptive hash index.


[Note] InnoDB: buffer pool 0 : start to withdraw the last 253952 blocks.


[Note] InnoDB: buffer pool 0 : withdrew 253952 blocks from free list. tried to relocate 0 pages. (253952/253952)


[Note] InnoDB: buffer pool 0 : withdrawn target 253952 blocks.


[Note] InnoDB: buffer pool 0 : 31 chunks (253952 blocks) was freed.


[Note] InnoDB: buffer pool 0 : hash tables were resized.


[Note] InnoDB: Resized hash tables at lock_sys, adaptive hash index, dictionary.


[Note] InnoDB: completed to resize buffer pool from 4294967296 to 134217728.


[Note] InnoDB: re-enabled adaptive hash index.


--------------------------------------分割线 --------------------------------------


--------------------------------------分割线 --------------------------------------