Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.1.32
-
Development
Description
Upgrading from 10.0 to 10.1.32 the default value for innodb_empty_free_list_algorithm is set to BACKOFF when documentation shows >=10.1.24 it should default to LEGACY.
May be contributing to error log entries
[Warning] InnoDB: Difficult to find free blocks in the buffer pool
Attachments
Issue Links
- relates to
-
MDEV-14776 InnoDB Monitor output generated by specific error is flooding error logs
-
- Closed
-
-
MDEV-16617 After upgrading from 5.5.52 to 10.1.32 getting [Warning] InnoDB: Difficult to find free blocks in the buffer pool
-
- Closed
-
-
MDEV-16526 Overhaul the InnoDB page flushing
-
- Closed
-
As Sergei Golubchik found out, XtraDB modifies the value without telling the server, and it does so conditionally. So, for big buffer pools it's still BACKOFF, while for small ones it's LEGACY, and we have a discrepancy in SYSTEM_VARIABLES:
At what size of a buffer pool will it choose LEGACY?