[MDEV-28846] Poor performance when rowid filter contains no elements - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.4(EOL)
Fix Version/s: 10.4.27, 10.5.18, 10.6.11, 10.7.7, 10.8.6, 10.9.4, 10.10.2
Component/s: Optimizer
Labels:
- not-10.5

Description

See details in the attached test case. If we create the right spread of values in the key and pick the range just right, when rowid_filter optimizer switch is enabled, the optimizer will sacrifice a part of the key for the rowid_filter. As a result we use only the u_delete_user and end up examining 5K+ rows out of 10K in the table. If we disable rowid_filter, the user_name constraint is being used, and we examine only 1 row.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

rowid_filter_bug.test
750 kB
2022-06-14 19:22
optimizer-trace-rowid-filter-off.txt
7 kB
2022-08-11 16:21
optimizer-trace-rowid-filter-on.txt
9 kB
2022-08-11 16:21

Issue Links

causes

MDEV-30142 rowid_filter: negative access cost factor values

Closed

duplicates

MDEV-19720 Server crash in st_join_table::save_explain_data or Assertion `sel->quick' failed in JOIN::make_range_rowid_filters with rowid_filter=on

Closed

is caused by

MDEV-16188 Use in-memory PK filters built from range index scans

Closed

mentioned in: Page Failed to load; Page Failed to load; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(22 mentioned in)

Activity

Transition	Time In Source Status	Execution Times

Julien Fritsch made transition - 2022-09-08 07:54

In Progress

Needs Feedback

75d 14h 58m

Julien Fritsch made transition - 2022-09-09 05:47

Needs Feedback

Open

21h 52m

Julien Fritsch made transition - 2022-09-15 07:48

Open

Confirmed

6d 14h 59m

Igor Babaev (Inactive) made transition - 2022-09-23 17:41

Confirmed

In Progress

17d 18h 27m

Igor Babaev (Inactive) made transition - 2022-09-25 15:46

In Progress

In Testing

1d 22h 5m

Igor Babaev (Inactive) made transition - 2022-09-26 18:11

In Testing

Stalled

1d 2h 24m

Igor Babaev (Inactive) made transition - 2022-09-26 18:12

Stalled

In Progress

14s

Igor Babaev (Inactive) made transition - 2022-10-18 04:10

In Progress

In Review

21d 9h 58m

Oleksandr Byelkin made transition - 2022-10-25 18:34

In Review

Stalled

7d 14h 23m

Igor Babaev (Inactive) made transition - 2022-10-27 04:07

Stalled

Closed

1d 9h 33m

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Sasha Pachev

Votes:: 2 Vote for this issue

Watchers:: 11 Start watching this issue

Dates

Created:: 2022-06-14 19:23

Updated:: 2024-09-05 19:52

Resolved:: 2022-10-27 04:07

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration