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

slow update statements

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.2.3
    • Fix Version/s: 1.2.5
    • Component/s: advanced tools
    • Labels:
      None
    • Environment:
      1 um 3 pm

      Description

      Customer reported:

      following the recent improvements we made on importing data, the next step requires to trigger updates on billions of rows. We do this block of rows at a time, especially to fit the versionbuffer, but it looks like while the update statement by itself is ok, a lot of time is spent in flushManyAllVersion, which from my understanding invalidate the cache after the update has touched those extents/blocks.

      I thought lowering the numblockpct to 10% would help but it seems that this is not the case.

      We run updates to insert int columns matching on (varchar,int) type query in another smaller table, and run those updates sequentially with no other query running.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              drrtuy Roman
              Reporter:
              hill David Hill (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.