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

Performance regression in INSERT..SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Do
    • 1.4.3
    • N/A, 1.4.5
    • MDB Plugin
    • None
    • 2020-5, 2020-6, 2020-7

    Description

      *strong text*After integration, INSERT SELECT is no longer using "vtable" like method for executing SELECT part (does it via ROW interface). The fix is to push SELECT into Select Handler (a 1.4 replacement of vtable).

      As of 1.4.3 MCS uses table API to query the data running INSERT..SELECT. Mentioned ENT-669 backports 10.5 feature described by CLX-77 into 10.4 Ent. The feature enables Select Handler to execute the query part.

      1.4 forces MCS to skip OFFSET processing b/c MDB applies OFFSET on its own.
      1.5 contains changes that allows to push OFFSET down to a smart engine.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. MCOL-545 Bulk operation produce IO on UM

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

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3929 SELECT INTO..OUTFILE

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16327 Server doesn't account for engines that supports OFFSET on their own.

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

          Task - A task that needs to be done. MDEV-18553 Make LIMIT/OFFSET processing uniform

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

          Activity

            People

              drrtuy Roman
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.