Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.11, 11.0(EOL), 11.1(EOL), 11.2(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
-
- Closed
-
Activity
Transition | Time In Source Status | Execution Times |
---|
|
17d 3h 27m | 1 |
|
48d 17h 34m | 1 |
|
3h 30m | 1 |
|
21d 7h 40m | 1 |
|
3d 15h 42m | 2 |
|
22h 54m | 1 |