Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.18, 10.5.9
-
debian 10, Ubuntu 20.04
Description
We have a query that was running for about 0.7 sec on avarage on mariadb server 10.4.17.
After upgrade to 10.4.18 the query still takes about 0.7.
However after running analyze on the tables the query starts running for 2.2 sec.
If I downgrade the server binary to 10.4.17 the query still takes 2.2 sec, but after running analyze again it goes back to 0.7 sec
I'm attaching here explain and analyze of the query before and after running the analyze.
Unfortunatelly I cannot provide a dump of the tables, since the data is private.
I'll be happy to run more tests for you or provide you with more information to fix that regression.