Columnstore write cache (MCOL-3875)

[MCOL-4914] Complete ColumnStore Cache Part 2 Created: 2021-11-04  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: None
Fix Version/s: 23.10

Type: Sub-Task Priority: Critical
Reporter: Gagan Goel (Inactive) Assignee: Leonid Fedorov
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-4924 Insert Cache - Table not accessible a... Closed
is blocked by MCOL-4926 Insert cache - Got an insert cache cr... Closed
Relates
relates to MCOL-5038 Add timer for Insert Cache flush Open
relates to MCOL-4769 Complete ColumnStore Insert Cache Part 1 Closed
Sprint: 2020-7

 Description   

This is a continuation of MCOL-4769 and covers the following items not addressed in that ticket:

1. columnstore_cache_use_import cannot be made default because cpimport bloats the database by wasting space in HWM blocks. This needs a resolution.
2. If a select statement is sent to a secondary (slave) node - there should be a cache flush caused on the primary (needs design)
3. any START TRANSACTION should flush cache. Cache should not be used if there are any multi-statement transactions present in the system (needs design)

 Comments   
Comment by David Hall (Inactive) [ 2022-03-31 ]

1) Add timer to flush every time period.
2) Add option to not flush upon select.
3) Ensure at least one of the above is on, but allow for both.

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