Set up docs MCPThese settings are available in system.settings and are autogenerated from the ClickHouse snapshot.
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_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.