Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15332

Slow query performance from 10.1.29

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2, 10.1.29
    • Fix Version/s: 10.1, 10.2
    • Component/s: None
    • Labels:
      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

        Attachments

          Activity

            People

            Assignee:
            varun Varun Gupta
            Reporter:
            BB Silver Asu
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated: