[MDEV-30216] Read-ahead unnecessarily allocates and frees pages when a page is in the buffer pool - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
Fix Version/s: 11.0.1
Component/s: Storage Engine - InnoDB
Labels:
- performance

Description

While testing ~~MDEV-29986~~ and some other changes, wlad noted that the function buf_read_page_low() is allocating and freeing a block in buf_pool.LRU when the requested page exists in the buffer pool.

The code has been refactored in 10.5 and 10.6, but this does not look like a regression: the logic always seems to have been like that.

Thanks to the refactored buf_pool.page_hash in 10.5 (~~MDEV-22871~~) and the lock elision (~~MDEV-26769~~), it could be faster to perform extra lookups to avoid unnecessary allocation and some contention on buf_pool.mutex.

Attachments

Issue Links

causes

MDEV-30911 Multi-batch recovery of ROW_FORMAT=COMPRESSED table hangs

Closed

includes

MDEV-26662 buf_read_page_background() is blocking on LRU eviction

Closed

relates to

MDEV-29694 Remove the InnoDB change buffer

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2022-12-13 07:44

Updated:: 2024-01-05 13:06

Resolved:: 2023-01-24 13:25

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.