Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4691 Major Regression: Selects with aggregates 2x slower in 5.x than in 1.2 (due to collation support)
  3. MCOL-4717

Conduct experiments measuring the overall impact of using MURMUR inside collation comparators

    XMLWordPrintable

    Details

    • Type: Sub-Task
    • Status: Open (View Workflow)
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 23.02
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2021-7, 2021-8, 2021-9, 2021-10, 2021-11, 2021-12

      Description

      The goal is to evaluate a proposal to correct the performance problem.

      The method:

      • create a test version of latin1_nopad_bin collation function which would use MURMUR.
      • measure the difference in performance (the expectation is 2x vs current 6x).
      • compare behavior of aggregate queries which use so updated collation against:
        a) original CS method - present in 1.2
        b) current - as in 5.5.2

      The last should be done using both flights (30 million rows) and Quinnstreet (1 billion rows).

      Once we have the facts, we will be making a decision on what to do.

        Attachments

          Activity

            People

            Assignee:
            David.Hall David Hall
            Reporter:
            gdorman Gregory Dorman
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.