Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1.29, 10.2(EOL)
-
None
-
None
Description
This query is very slow from MariaDB 10.1.29. Also slow with all 10.2 versions
Mariadb 10.1.28 is OK. MySQL 5.7.21 is OK.
SELECT c.id,count(*) AS count,c.group_id FROM cattypes c
|
LEFT JOIN cattypegroups g ON c.group_id=g.id
|
RIGHT JOIN itemtocattypes i2c ON i2c.cattypeid=c.id
|
LEFT JOIN items i ON i2c.itemid=i.id
|
INNER JOIN itemtocatalogues i2cat ON (i2cat.itemid=i.id AND i2cat.catalogueid=117)
|
WHERE (g.catalogueid=117 OR g.id=378 AND g.ispricegroup)
|
AND i.active=1 AND i.dead=0
|
GROUP BY c.id
|
Dump file: https://www.upload.ee/files/8044172/dz_reduced2.zip.html