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

Enabling idle flushing (possible regression from MDEV-23855)

    XMLWordPrintable

Details

    Description

      • Existing logic doesn't have idle flushing enabled. It got removed as part of the MDEV-23855 revamp.
      • Given the new/update flow of the page-cleaner idle flushing logic will be enabled if
      • page cleaner is idle
      • there are dirty pages (<srv_max_dirty_pages_pct_lwm)
      • server is not performing any activity.

      Attachments

        1. idle-flushing (patched (enabled) vs baseline (disabled))_NvME SSD.png
          idle-flushing (patched (enabled) vs baseline (disabled))_NvME SSD.png
          22 kB
        2. idle-flushing (patched (enabled) vs baseline (disabled))_sas-ssd (350MB_sec).png
          idle-flushing (patched (enabled) vs baseline (disabled))_sas-ssd (350MB_sec).png
          24 kB
        3. mdb.nvme.cnf
          2 kB
        4. mdb.sasssd.cnf
          2 kB
        5. oltp_ts_16.png
          oltp_ts_16.png
          22 kB
        6. oltp_ts_16B.png
          oltp_ts_16B.png
          29 kB
        7. oltp.png
          oltp.png
          24 kB
        8. oltpB.png
          oltpB.png
          22 kB
        9. run.sh
          1 kB
        10. Screenshot from 2021-02-23 19-15-04.png
          Screenshot from 2021-02-23 19-15-04.png
          53 kB

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-25113 Reduce effect of parallel background flush on select workload

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27295 MariaDB 10.5 does not do idle checkpoint (regression). Marked as fixed on 10.5.13 but it is not

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23855 InnoDB log checkpointing causes regression for write-heavy OLTP

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24537 innodb_max_dirty_pages_pct_lwm=0 lost its special meaning

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25093 Adaptive flushing fails to kick in even if innodb_adaptive_flushing_lwm is hit. (possible regression)

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30000 make mariadb-backup to force an innodb checkpoint

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              marko Marko Mäkelä
              krunalbauskar Krunal Bauskar
              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.