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

Enabling idle flushing (possible regression from MDEV-23855)

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

            Ascending order - Click to sort in descending order
            krunalbauskar Krunal Bauskar created issue -
            krunalbauskar Krunal Bauskar made changes -
            Attachment mdb.nvme.cnf [ 56403 ]
            krunalbauskar Krunal Bauskar made changes -
            Attachment mdb.sasssd.cnf [ 56404 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Affects Version/s 10.5.9 [ 25109 ]
            Affects Version/s 10.5.8 [ 25023 ]
            krunalbauskar Krunal Bauskar made changes -
            Attachment run.sh [ 56410 ]
            krunalbauskar Krunal Bauskar made changes -
            Attachment Screenshot from 2021-02-23 19-15-04.png [ 56422 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            axel Axel Schwenke made changes -
            Attachment oltp.png [ 56568 ]
            axel Axel Schwenke made changes -
            Attachment oltp_ts_16.png [ 56569 ]
            axel Axel Schwenke made changes -
            Attachment oltpB.png [ 56570 ]
            axel Axel Schwenke made changes -
            Attachment oltp_ts_16B.png [ 56571 ]
            axel Axel Schwenke made changes -
            Attachment oltp_ts_16B.png [ 56571 ]
            axel Axel Schwenke made changes -
            Attachment oltp_ts_16B.png [ 56572 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2021-03-11 06:15:07.0 2021-03-11 06:15:07.24
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.10 [ 25204 ]
            Fix Version/s 10.6.0 [ 24431 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 119403 ] MariaDB v4 [ 158937 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -

            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.