Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
Related to performance
-
Q4/2025 Server Maintenance
Description
A query that responds immediately in 10.5 and 10.6 takes 13 seconds on 11.4.
root@alone11:~/support_az214394$ mariadb -ABNe "select version()"
|
11.4.4-MariaDB-deb12
|
root@alone11:~/support_az214394$ mariadb < az214394.sql
|
root@alone11:~/support_az214394$ time mariadb < query.sql 1>/dev/null
|
|
|
real 0m13.527s
|
user 0m0.045s
|
sys 0m0.005s
|
root@alone11:~/support_az214394$ # testing the same query using FORCE INDEX(PRIMARY)
|
root@alone11:~/support_az214394$ time mariadb < query_with_force.sql 1>/dev/null
|
|
|
real 0m0.066s
|
user 0m0.049s
|
sys 0m0.000s
|
root@alone11:~/support_az214394$
|
Using attachment, you can test this.
Attachments
Issue Links
- relates to
-
MDEV-38129 MariaDB Bug Report: Severe Performance Regression with cardinality<7 Indexes in LEFT JOIN
-
- Stalled
-
-
MDEV-38361 Followup to MDEV-36761: Indexes with NULLs-only and InnoDB statistics?
-
- Open
-