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

Page cleaner sleeps indefinitely despite innodb_max_dirty_pages_pct_lwm being exceeded

Details

    Description

      MDEV-24278 improved the page cleaner so that it will no longer wake up once per second on an idle server. However, with innodb_adaptive_flushing (the default) the function page_cleaner_flush_pages_recommendation() could initially return 0 even if there is work to do. The page cleaner should only remain sleeping indefinitely as long as the sharp innodb_max_dirty_pages_pct_lwm limit is not exceeded.

      Based on a source code comment, it appears that an initial intention of innodb_max_dirty_pages_pct_lwm=0.0 (the default value) was to disable something. That ceased to hold in MDEV-23855 and MDEV-24278: the value is a pure threshold; the page cleaner will not perform any work unless the threshold is exceeded.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26055 Adaptive flushing is still not getting invoked in 10.5.11

          • Major - Major loss of function.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24278 InnoDB page cleaner keeps waking up on idle server

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36149 UBSAN in X is outside the range of representable values of type 'unsigned long' | page_cleaner_flush_pages_recommendation

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24917 Flushing starts only when 90% (srv_max_buf_pool_modified_pct) pages are modified

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

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            marko Marko Mäkelä added a comment -

            Note: This bug was not part of any 10.5 release. It was introduced by MDEV-24278 after the 10.5.8 release, during the development of 10.5.9.

            marko Marko Mäkelä added a comment - Note: This bug was not part of any 10.5 release. It was introduced by MDEV-24278 after the 10.5.8 release, during the development of 10.5.9.
            marko Marko Mäkelä made changes -
            Fix Version/s 10.5.9 [ 25109 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 116653 ] MariaDB v4 [ 158665 ]
            marko Marko Mäkelä made changes -
            debarun Debarun Banerjee made changes -

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.