Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5999

Query Accelerator | get innodb data faster

    XMLWordPrintable

Details

    • 2025-4, 2025-5

    Description

      As of now the major bottleneck for QA is data retrieval from MDB, namely CES retrieves innodb data using only one client connection. Given that MCS query execution is a pipeline, its performance is limited by the slowest part.
      This issue describes the way to resolve this single-threaded data retrieval. There are at least two feasible ways:

      • Innodb table partitioning coupled with optimization query re-write that turns single data retrieval CES into UNION of partition-specific CESes
      • engine-independent statistics, namely mysql.column_stats table contents

      Attachments

        Issue Links

          includes

          New Feature - A new feature of the product, which has yet to be developed. MCOL-4935 A prototype planner/optimizer using term rewriting

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MCOL-6036 Rewrite optimizer engine + CES parallel read rewrite rule

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

          Task - A task that needs to be done. MDEV-36922 Adding histogram data retrieval method for Histogram_json_hb

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

          Task - A task that needs to be done. MCOL-6013 To be Scheduled !!! Query Accelerator | over shared memory data retrieval

          • Major - Major loss of function.
          • Open
          mentioned in

          Page Loading...

          Activity

            People

              drrtuy Roman
              allen.herrera Allen Herrera
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.