[MCOL-5473] Mutex lock contention doing VSS lookup loading a block Created: 2023-04-11  Updated: 2023-12-15

Status: Stalled
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 22.08.8, 23.02.1
Fix Version/s: 23.10

Type: Bug Priority: Blocker
Reporter: Roman Assignee: Roman
Resolution: Unresolved Votes: 0
Labels: rm_perf

Issue Links:
PartOf
is part of MCOL-5460 concurrent CTE operation excessive mutex Stalled

 Description   

A shared mutex contention in VSS lookup becomes visible after MCOL-5472 is resolved.
Version Substitution Structure is a structure that gives PrimProc the actual version of a block if there is any DML operation in progress. Any block scan operations looks for a block using blocks' LBID before it reads the block from a persistent storage. VSS is node significant.
The suggested solution is to horizontally scale VSS cache having multiple caches. hash(LBID) mod number_of_caches can be used to deterministically pick a cache from the list.



 Comments   
Comment by JiraAutomate [ 2023-12-15 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Generated at Thu Feb 08 02:58:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.