Skip to main content
These settings are available in system.settings and are autogenerated from source.

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 experimental ReaderExecutor supports it; other readers bypass the cache. read_from_filesystem_cache_if_exists_otherwise_bypass_cache takes precedence.

read_from_page_cache_if_exists_otherwise_bypass_cache

Use userspace page cache in passive mode, similar to read_from_filesystem_cache_if_exists_otherwise_bypass_cache.