Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
innodb_buffer_pool_pct drives how much of the bp is dumped to disk during a gracefull shutdown.
innodb_old_blocks_pct drives the size of the old & young pages sub list size inside the BP
can we add a new value to innodb_buffer_pool_pct parameter that would automatically dump only young pages during shutdown, like innodb_buffer_pool_pct = 'young' ?
and add a new status var :
innodb_buffer_pool_young_pages_total_size that give the actual size of all the pages listed as young ? (kinda easy calculation : number of young pages x size of page )
i think it would create a super easy way to setup and use this feature while optimizing automatically the size vs performance side of things and also giving a way to monitor the size of the dump in order to adjust if necessary.
Attachments
Issue Links
- relates to
-
MDEV-30645 CREATE TRIGGER FOR { STARTUP | SHUTDOWN }
-
- In Progress
-