Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4527 Simple query performace is degraded between 5.4 and 5.5
  3. MCOL-4528

Analyze and explain the reasons for the difference between 5.4 and 5.5

    XMLWordPrintable

Details

    • Sub-Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • None
    • 5.5.2
    • N/A
    • None
    • 2021-2, 2021-3

    Description

      Basic facts as known today:

      • Available traces show 2x elapsed time between 5.4 and 5.5
      • They also show 50% difference in LIO
      • This is almost certainly NOT extent elimination problem. The reason for this statement is that when this query was run using utf8, it did not do extent elimination, and the difference was close to 4x on elapsed and 3x on LIO.
      • Personal opinions point to CPU overhead of collations. But before this is positively determined - the difference in LIO needs to be explaind.
        REPEAT: this task is RESEARCH and diagnosis only. No solutions are to be proposed at this time.

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            gdorman Gregory Dorman (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.