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

Slow query performance from 10.1.29

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1.29, 10.2
    • 10.2
    • 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

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            BB Silver Asu
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.