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

Parallel execution on partitions in scans where multiple partitions are needed

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • Partitioning
    • None

    Description

      Currently when a table uses partitioning and multiple partitions only the needed partitions are scanned in queries that have WHERE clauses on the partitioning key. However for other queries all partitions need to be scanned and furthermore the scans are done sequentially.

      This task is to launch scans on different partitions in parallel instead of sequentially whenever more than one partition needs to be scanned (similarly to what the SPIDER engine does). This would allow the execution to use multiple cores (when available) and provide much faster overall execution times.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-28596 Replace Spider's parallel search feature by partitioning engine's one

          • Major - Major loss of function.
          • Open
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-6897 Making Items reentrant

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          is part of

          Task - A task that needs to be done. MDEV-22162 Make partitions more flexible to use

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16610 Torn reads from spider, with XA and isolation level REPEATABLE READ

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-6096 Ideas about parallel query execution

          • Major - Major loss of function.
          • Open

          Activity

            People

              holyfoot Alexey Botchkov
              maxmether Max Mether
              Votes:
              0 Vote for this issue
              Watchers:
              11 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.