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

Mariadb report takes over 5hrs to run against Mariadb 10.7.3 server

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 10.7.3
    • N/A
    • Server
    • None

    Description

      One of our reports is extremely slow when run against 10.7.3 server. It takes over 5 hours whereas the same report run against 10.6.7 takes only 2 minutes. The SQL has been attached (slowsql.txt)

      Screenshot for Results against 10.7.3

      Screenshot for Results against 10.6.7

      I have reproduced the results in a third party product called Squirrel.

      When running the query and returning 100 rows for 10.6.7
      the query results are returned in 37.588 seconds

      When running the query and returning 100 rows for 10.7.3
      the query results are returned in 544.163 seconds

      When running the query and returning 1000 rows for 10.6.7
      the query results are returned in 86.245 seconds

      Screenshot for 10.6.7

      When running the query and returning 1000 rows for 10.7.3
      the query results are returned in 3376.95 seconds

      Screenshot for 10.7.3

      Attached is the 7zip compressed file for ddl (gosales_1021.7z) and the sql which is extremely slow (slowsql.txt)

      Attachments

        1. executed_analyze_table_statements_gosalesxx_1021.txt
          61 kB
          Mike Savoie
        2. gosales_1021.7z
          6.11 MB
          Mike Savoie
        3. image-2022-05-26-12-21-48-483.png
          235 kB
          Mike Savoie
        4. image-2022-05-26-12-22-15-539.png
          233 kB
          Mike Savoie
        5. image-2022-05-26-12-31-53-239.png
          95 kB
          Mike Savoie
        6. image-2022-05-26-12-33-16-432.png
          97 kB
          Mike Savoie
        7. Mariadb_10_6_7_gosalesdw_explain_format_json.txt
          9 kB
          Mike Savoie
        8. Mariadb_10_6_7_GOSALESDW_variables.txt
          11 kB
          Mike Savoie
        9. Mariadb_10_6_7_GOSALESDW_variables-1.txt
          67 kB
          Mike Savoie
        10. Mariadb_10_7_3_gosalesdw_explain_format_json.txt
          9 kB
          Mike Savoie
        11. Mariadb_10_7_3_GOSALESDW_variables.txt
          11 kB
          Mike Savoie
        12. Mariadb_10_7_3_GOSALESDW_variables-1.txt
          67 kB
          Mike Savoie
        13. show_variables_10.7.3.txt
          548 kB
          Mike Savoie
        14. Slowsql.txt
          5 kB
          Mike Savoie

        Activity

          People

            Unassigned Unassigned
            Mike.Savoie@ca.ibm.com Mike Savoie
            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.