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

reduce InnoDB buffer pool load time

    XMLWordPrintable

Details

    Description

      When InnoDB starts up, it can be limited by innodb_io_capacity (or innodb_io_capacity_max). Currently, users can increase these temporarily at startup, but this is not ideal, and neither should be left elevated.

      Based on the discussion at https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/InnoDB.20tuning/near/234486913, this task is to add a new parameter for use in buffer pool load (and read-ahead).

      Attachments

        1. ssd_32_thd.png
          ssd_32_thd.png
          17 kB
        2. ssd_1_thd.png
          ssd_1_thd.png
          12 kB
        3. hdd_32_thd.png
          hdd_32_thd.png
          23 kB
        4. hdd_1_thd.png
          hdd_1_thd.png
          15 kB

        Issue Links

          Activity

            People

              danblack Daniel Black
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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