[MDEV-24117] Memory management problem in statistics state for queries that have a large field IN (values) part - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.2.35, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.2.36, 10.3.27, 10.4.17, 10.5.8
Component/s: Optimizer
Labels:
- regression
Environment:
Centos 7

Description

A query with a large IN () section will be stuck in statistics and use up all RAM. Multiple such queries will crash the server regardless of memory limitations specified in my.cnf

I noticed this in 10.2.35. Downgrading to 10.2.34 fixes the problem

An example is the WordPress "select post_id,meta_value from wp_postmeta where meta_id in (1,2,3 etc ...)" query.

Attachments

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

1_my.test
2020-11-09 12:15
26 kB
Alice Sherepa
mariadbbug.sql
2020-11-05 21:09
156 kB
Pavel

Issue Links

is blocked by

MDEV-27380 After minor upgrade to 10.5.13 queries with large IN clauses have performance issues

Closed

is caused by

MDEV-23811 With large number of indexes optimizer chooses an inefficient plan

Closed

is duplicated by

MDEV-24163 Mariadb is restarting after sending this message [Warning] Aborted connection 5889 to db: 'xxxx' user: 'xxxxx' host:

Closed

MDEV-24173 After minor upgrade to 10.2.35 queries with large IN clauses have performance issues

Closed

MDEV-24195 Huge memory usage after upgrade

Closed

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Geza Lucz

Votes:: 11 Vote for this issue

Watchers:: 18 Start watching this issue

Dates

Created:: 2020-11-04 08:55

Updated:: 2024-09-06 10:00

Resolved:: 2020-11-11 15:19

Git Integration

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