Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.5
-
Fix Version/s: 10.5.9
-
Component/s: Storage Engine - InnoDB
-
Labels:
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
- is caused by
-
MDEV-24278 InnoDB page cleaner keeps waking up on idle server
-
- Closed
-
- relates to
-
MDEV-24917 Flushing starts only when 90% (srv_max_buf_pool_modified_pct) pages are modified
-
- Closed
-