[MDEV-33559] matched_rec::block should be allocated from the buffer pool - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
Fix Version/s: 10.5.25, 10.6.18, 10.11.8, 11.0.6, 11.1.5, 11.2.4, 11.4.2
Component/s: GIS, Storage Engine - InnoDB
Labels:
- memory
- performance

Description

Related to SPATIAL INDEX search (see ~~MDEV-14059~~), InnoDB is allocating additional blocks to store some results. These blocks look like buffer pool blocks, but they are in fact allocated outside the buffer pool for no good reason, potentially causing memory fragmentation. It would be cleaner to make matched_rec::block a pointer to something that is returned by buf_block_alloc(). This would allow us in MDEV-29445 to remove the frame pointer from the block descriptor.

Attachments

Issue Links

blocks

MDEV-29445 reorganise innodb buffer pool (and remove buffer pool chunks)

Stalled

relates to

MDEV-18746 Reduce the amount of mem_heap_create() or malloc()

Open

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2024-02-28 14:42

Updated:: 2024-08-02 07:22

Resolved:: 2024-04-15 06:37

Git Integration

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