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

Single Query Performance Regression in Group BY

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • None
    • None
    • None
    • None
    • Red Hat Enterprise Linux Server release 6.5 (Santiago)

    Description

      Hi,
      I join show table status ans show create table.

      The query :

      select    a13.id_vehicule  id_vehicule,
                      a12.id_energie  id_energie,
                      sum(a11.num_jo_dans_mois)  WJXBFS1,
                      sum(a11.num_jo_dans_annee)  WJXBFS2
      from      `T_CALENDRIER`              a11
                      cross join            `T_ENERGIE`      a12
                      cross join            `T_VEHICULE`    a13
      where  (a11.Id_Calendrier in (20131231)
      and a13.id_genre in (45))
      group by             a13.id_vehicule,
                      a12.id_energie;

      This query is fast in mysql 5.1, but slow in mariadb.

      Thanx for your help.
      Sebastien

      Attachments

        1. vmstat-10.log
          49 kB
          MARCHAL Sebastien
        2. show table status.csv
          0.8 kB
          MARCHAL Sebastien
        3. show create table.sql
          3 kB
          MARCHAL Sebastien
        4. show_status.csv
          11 kB
          MARCHAL Sebastien
        5. server.txt
          2 kB
          VAROQUI Stephane
        6. iosstat-10.log
          548 kB
          MARCHAL Sebastien
        7. image001.jpg
          2 kB
          MARCHAL Sebastien
        8. explain_paln.csv
          0.3 kB
          MARCHAL Sebastien
        9. diffstatus-10.log
          600 kB
          MARCHAL Sebastien

        Activity

          People

            elenst Elena Stepanova
            op2seb MARCHAL Sebastien
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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