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

Research UPDATE path bottlenecks and shortages

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • DMLProc
    • None

    Description

      Currently SQL UPDATE in MCS has the slowest path comparing with both INSERT [1] and DELETE [2]. UPDATE is a crucial part of a mixed OLTP workload so for HTAP it needs to become faster. This task is to estimate current rates and highlight bottlenecks and limitations.

      1. Using fast insert cache feature
      2. Using fast delete feature

      Attachments

        Activity

          People

            Unassigned Unassigned
            drrtuy Roman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 10d
                10d
                Remaining:
                Remaining Estimate - 10d
                10d
                Logged:
                Time Spent - Not Specified
                Not Specified

                Git Integration

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