[MDEV-20519] Query plan regression with optimizer_use_condition_selectivity > 1 - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4.7
Fix Version/s: 10.1.44, 10.2.30, 10.3.21, 10.4.11
Component/s: Optimizer
Labels:
- optimizer-use-condition-selectivity-slowdown

Description

The optimizer can choose very bad execution plans for certain queries with the default optimizer_use_condition_selectivity=4 in MariaDB 10.4. Setting optimizer_use_condition_selectivity=1 allows you to work around the problem.

Attachments

Issue Links

causes

MDEV-22535 TABLE::initialize_quick_structures() takes 0.5% in oltp_read_only

Closed

is blocked by

MDEV-20576 A new assertion added to check validity of calculated selectivity values fails

Closed

relates to

MDEV-20576 A new assertion added to check validity of calculated selectivity values fails

Closed

MDEV-20595 Assertion `0 < sel && sel <= 2.0' failed in table_cond_selectivity

Stalled

Activity

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Geoff Montee (Inactive)

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2019-09-06 20:19

Updated:: 2024-07-07 22:33

Resolved:: 2019-11-07 17:23

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

3.75d

Git Integration

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