WL#8317: Enable InnoDB Buffer Pool dumps by default in 5.7
Status: Complete
This work changes the server to use the buffer pool dump by default and changes the default percentage to 25%. New defaults becomes: - innodb_buffer_pool_dump_at_shutdown to "TRUE" (was: FALSE) - innodb_buffer_pool_dump_pct to "25" (was: 100) - innodb_buffer_pool_load_at_startup to "TRUE" (was: FALSE) This gives a good balance between a hot working set and shutdown and startup times. The previous value of innodb_buffer_pool_dump_pct in 5.6 was 100 and now we are changing it to 25 in 5.7 via this WL. This means that users that are using this feature in 5.6 or 5.7 by using one or more of * innodb_buffer_pool_dump_at_shutdown * innodb_buffer_pool_load_at_startup * innodb_buffer_pool_dump_now * innodb_buffer_pool_load_now BUT without modifying innodb_buffer_pool_dump_pct because the default of 100 suits them will get a behavioral change. To get the old behavior of dumping the whole buffer pool they must explicitly set innodb_buffer_pool_dump_pct to 100 in their config.
Copyright (c) 2000, 2024, Oracle Corporation and/or its affiliates. All rights reserved.