Not the answer you need?
Register and ask your own question!

Buffer Pool restore.

singhsingh EntrantCurrent User Role Beginner
HI

Just a question to ask about
innodb_buffer_pool_dump
Is there option for this to take the dump automatically on certain
percentage of the buffer page changes,instead of doing that only at
shutdowns. If in case mysql dies abruptly [OS signal 11 or 6) it won't get
a shutdown signal and dies with out the Buffer pool dump inspite of setting
this innodb_buffer_pool_dump_at_shutdown ON, and can't load the old one
that is months or days old when it starts up again after recovery.

At least didn't find anywhere mentioning about it here http://dev.mysql.com/doc/refman/5.6/en/innodb-preload-buffer-pool.html in a timely manner which was there in PS5.5
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.