search

StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.29k stars 1.68k forks source link

Activate CN Cache by Default and Control From Config Values #37496

Open inviscid opened 6 months ago

inviscid commented 6 months ago

Feature request

Is your feature request related to a problem? Please describe. Based on the slack discussion Dec 14, 2023 regarding activation of the CN cache, it was determined that it can only be performed by running two global set queries:

SET global enable_profile = true;
SET global enable_scan_block_cache = true;

This creates additional complexity in Kubernetes deployments because it requires post deployment processes that must run. Ideally in a Kubernetes deployment things are fully configured and operational when they deploy and all configuration is specified in the configmap.

This request is to enable activation of the cache from the CN config rather than running the global queries.

Describe the solution you'd like Enable the CN cache by default and allow control of the cache from the CN config rather than requiring post-deploy queries.

Describe alternatives you've considered Run post deploy hooks to execute the necessary queries but this creates additional complexity and introduces additional failure points that can be complicated to manage in auomated deployment scenarios (e.g. ArgoCD).

Additional context Slack Discussion

github-actions[bot] commented 1 week ago

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!