Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.11, 11.1(EOL), 11.2, 11.0(EOL), 11.3(EOL)
-
GNU/Linux, various multi socket Intel CPU systems (NUMA)
Description
In MDEV-25341 (MariaDB Server 10.11.0), some calls to madvise() with MADV_FREE were added.
If the call in buf_LRU_block_free_non_file_page() is committed out, the throughput in an I/O bound HammerDB benchmark would improve by 6% to 18%, depending on the CPU microarchitecture.
It could be best to revert this code for now. A better solution might be doable as part of a larger refactoring (MDEV-25340, MDEV-29445). Instead of invoking madvise(MADV_FREE) on individual buffer pages, we might invoke it on larger chunks at a time. There could also be an explicit SQL statement for defragmenting or freeing the buffer pool.
Attachments
Issue Links
- is blocked by
-
MDEV-24670 avoid OOM by linux kernel co-operative memory management
- Closed
- is caused by
-
MDEV-25341 innodb buffer pool soft decommit of memory
- Closed
- relates to
-
MDEV-34863 RAM Usage Changed Significantly Between 10.11 Releases
- Open