Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37488

Adapting innodb_buffer_pool_dump_pct from innodb_old_blocks_pct

    XMLWordPrintable

Details

    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

          Activity

            People

              Unassigned Unassigned
              SylvainArbaudie Sylvain ARBAUDIE
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.