read_from_distributed_cache_if_exists_otherwise_bypass_cache
Only has an effect in ClickHouse Cloud. Same as read_from_filesystem_cache_if_exists_otherwise_bypass_cache, but for distributed cache.read_from_filesystem_cache_if_exists_otherwise_bypass_cache
Allow to use the filesystem cache in passive mode - benefit from the existing cache entries, but don’t put more entries into the cache. If you set this setting for heavy ad-hoc queries and leave it disabled for short real-time queries, this will allows to avoid cache threshing by too heavy queries and to improve the overall system efficiency.read_from_filesystem_cache_if_exists_otherwise_cache_temporarily
Use the filesystem cache as a temporary buffer for data that is not in it: a miss is read into the cache and served from it, and the cache removes it when nobody holds it anymore, unless a reader or writer outside this mode used it. Only the experimentalReaderExecutor supports it; other readers bypass the cache. read_from_filesystem_cache_if_exists_otherwise_bypass_cache takes precedence.