[MCOL-5137] MariaDB CS disable versionbuffer Created: 2022-06-15  Updated: 2022-10-13

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.6.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: andreas eschbacher Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

RHEL 8.5


 Description   

Hallo,

is it possible to disable the VersionBufferFile?

<VersionBuffer>
<!-- VersionBufferFileSize must be a multiple of 8192.
One version buffer file will be put on each DB root. -->
<VersionBufferFileSize>50GB</VersionBufferFileSize>
</VersionBuffer>

What happens when the VersionBufferFileSize reaches 50 GB?
Is there a tool to truncate the File? Or should we stop the DB and remove the File and restart the DB?

ty best regards
Andreas

 Comments   
Comment by David Hall (Inactive) [ 2022-10-13 ]

There is no way to totally disable the version buffer. It is used for all DML statements (INSERT, UPDATE, DELETE)
The version buffer file is self truncating. It's size is determined by the totality of all currently running DML statements. It will remove any unneeded entries to make room when new DML statements are executed.

Each DML statement may cause a different size version buffer entry based on the blocks affected by the statement.

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