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

Mutex lock contention doing block cache lookup when loading a block

Details

    • New Feature
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 22.08.8, 23.02.1
    • None
    • PrimProc
    • 2023-11, 2023-12, 2024-1, 2024-2

    Description

      A shared mutex contention in FileBufferMgr::findPtr becomes visible after MCOL-5472 is resolved and VSS cache is disabled.
      The mutex in findPtr controls access to LRU cache structures.
      The suggested solution is to horizontally scale LRU and mutex using hash(LBID) mod scaling_factor.

      Attachments

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5460 concurrent CTE operation excessive mutex

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            drrtuy Roman created issue -
            drrtuy Roman made changes -
            Field Original Value New Value
            drrtuy Roman made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Fix Version/s 23.08 [ 28540 ]
            Fix Version/s 23.02 [ 28209 ]
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Labels rm_perf
            drrtuy Roman made changes -
            Fix Version/s 23.10.1 [ 29105 ]
            Fix Version/s 23.10 [ 28540 ]
            drrtuy Roman made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            drrtuy Roman made changes -
            Assigned for Review Leonid Fedorov [ JIRAUSER48443 ]
            Sprint 2023-11 [ 737 ]
            drrtuy Roman made changes -
            Fix Version/s 23.10.1 [ 29105 ]
            drrtuy Roman made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            drrtuy Roman made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            leonid.fedorov Leonid Fedorov made changes -
            Sprint 2023-11 [ 737 ] 2023-11, 2023-13 [ 737, 748 ]
            JIraAutomate JiraAutomate made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2023-11, 2023-12 [ 737, 748 ] 2023-11, 2023-12, 2023-13 [ 737, 748, 755 ]
            drrtuy Roman made changes -
            Issue Type Bug [ 1 ] New Feature [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Blocker [ 1 ] Critical [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2023-11, 2023-12, 2024-1 [ 737, 748, 755 ] 2023-11, 2023-12, 2024-1, 2024-2 [ 737, 748, 755, 764 ]
            julien.fritsch Julien Fritsch made changes -
            Labels rm_perf Concurrency rm_perf
            julien.fritsch Julien Fritsch made changes -
            Sprint 2023-11, 2023-12, 2024-1, 2024-2 [ 737, 748, 755, 764 ] 2023-11, 2023-12, 2024-1, 2024-2, 2024-3 [ 737, 748, 755, 764, 784 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2023-11, 2023-12, 2024-1, 2024-2, 2025-1 [ 737, 748, 755, 764, 784 ] 2023-11, 2023-12, 2024-1, 2024-2 [ 737, 748, 755, 764 ]

            People

              drrtuy Roman
              drrtuy Roman
              Leonid Fedorov Leonid Fedorov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.