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

Parallel Query: execute the join in the worker threads

    XMLWordPrintable

Details

    Description

      Created to document executing the join within each worker thread.

      Milestone 1
      Multi table join execution

      Milestone 2
      aggregation, distinct, limit

      Unsure
      order by

      Attachments

        1. wide_table_1M_rows.png
          wide_table_1M_rows.png
          63 kB
        2. wide_table_10M_rows.png
          wide_table_10M_rows.png
          81 kB
        3. parallel_perf_test.sql
          7 kB
        4. 1M_rows.png
          1M_rows.png
          59 kB
        5. 10M_rows.png
          10M_rows.png
          66 kB
        6. 100M_rows.png
          100M_rows.png
          73 kB

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41399 With Parallel execution Performance degradation seen in JOIN query

          • Major - Major loss of function.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41492 Intermittent signal11 seen with parallel execution

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41497 Parallel execution increases UNION query execution time by 80%

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41499 With PQ, Performance degradation observed for range predicates returning fewer rows

          • Major - Major loss of function.
          • Open

          Activity

            People

              Johnston Rex Johnston
              Johnston Rex Johnston
              Rex Johnston Rex Johnston
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 10d Original Estimate - 10d
                  10d
                  Remaining:
                  Time Spent - 37.5d Remaining Estimate - 0.75d
                  0.75d
                  Logged:
                  Time Spent - 37.5d Remaining Estimate - 0.75d
                  37.5d

                  Git Integration

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