Details
Description
Since upgrading from 10.2 to 10.5.13 queries using IN clauses with many values have performance issues.
This is the same issue reported under MDEV-24117 whichi s fixed in 10.5.8. Even though it's fixed in 10.5.8, I can reproduce the same issue in 10.5.9 and 10.5.13 with the attached mariadbbug.sql in the MDEV-24117.
Attachments
Issue Links
- blocks
-
MDEV-24117 Memory management problem in statistics state for queries that have a large field IN (values) part
- Closed
-
MDEV-24173 After minor upgrade to 10.2.35 queries with large IN clauses have performance issues
- Closed
- duplicates
-
MDEV-27453 Performance degredation when IN elements are string instead of int
- Closed
Thanks for the report!
I could repeat the performance regression on 10.5-10.7 (0.1 in 10.4 vs 3.8 in 10.5), there is some problem with large IN (varchars)