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

    • Sub-Task
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Do
    • None
    • 23.10.0
    • PrimProc
    • None
    • 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

            leonid.fedorov Leonid Fedorov
            gdorman Gregory Dorman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.