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

reduce InnoDB buffer pool load time

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. hdd_1_thd.png
          15 kB
          Axel Schwenke
        2. hdd_32_thd.png
          23 kB
          Axel Schwenke
        3. ssd_1_thd.png
          12 kB
          Axel Schwenke
        4. ssd_32_thd.png
          17 kB
          Axel Schwenke

        Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26547 Restoring InnoDB buffer pool dump is single-threaded for no reason

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29343 MariaDB 10.6.x slower mysqldump etc.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-9930 Allow to choose an aggressive InnoDB buffer pool load mode

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Daniel Black made transition -
            Open In Progress
            		579d 8h 38m 1
            Daniel Black made transition -
            Stalled In Progress
            		3d 15h 55m 1
            Daniel Black made transition -
            In Progress In Review
            		1m 26s 2
            Marko Mäkelä made transition -
            In Review Stalled
            		3d 16h 39m 2
            Marko Mäkelä made transition -
            Stalled Closed
            		6d 2h 35m 1

            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.