> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Contains information about all filesystem cache settings

# system.filesystem_cache_settings

<h2 id="description">
  Description
</h2>

Contains information about all filesystem cache settings

<h2 id="columns">
  Columns
</h2>

* `cache_name` ([String](/reference/data-types/index)) — Cache name
* `path` ([String](/reference/data-types/index)) — Cache directory path
* `max_size` ([UInt64](/reference/data-types/index)) — Maximum cache size
* `max_elements` ([UInt64](/reference/data-types/index)) — Maximum number of cache elements, e.g. file segments (limits number of files on filesystem)
* `max_file_segment_size` ([UInt64](/reference/data-types/index)) — Maximum size of a single file segment
* `boundary_alignment` ([UInt64](/reference/data-types/index)) — File segment alignment
* `cache_on_write_operations` ([UInt8](/reference/data-types/index)) — Enables write-through cache (cache on INSERT and MERGE)
* `cache_policy` ([String](/reference/data-types/index)) — Cache eviction policy
* `slru_size_ratio` ([Float64](/reference/data-types/index)) — SLRU cache policy size ratio of protected to probationary elements
* `background_download_threads` ([UInt64](/reference/data-types/index)) — Number of background download threads. Value 0 disables background download
* `background_download_queue_size_limit` ([UInt64](/reference/data-types/index)) — Size of background download queue. Value 0 disables background download
* `background_download_max_file_segment_size` ([UInt64](/reference/data-types/index)) — Maximum size which can be downloaded in background download
* `load_metadata_threads` ([UInt64](/reference/data-types/index)) — Maximum number of threads used to load cache metadata at server startup
* `load_metadata_asynchronously` ([UInt8](/reference/data-types/index)) — Enables asynchronous loading of metadata on server startup
* `keep_free_space_size_ratio` ([Float64](/reference/data-types/index)) — A ratio of free space which cache would try to uphold in the background
* `keep_free_space_elements_ratio` ([Float64](/reference/data-types/index)) — A ratio of free elements which cache would try to uphold in the background
* `keep_free_space_remove_batch` ([UInt64](/reference/data-types/index)) — A remove batch size of cache elements made by background thread which upholds free space/elements ratio
* `invalidated_entries_cleanup_interval_ms` ([UInt64](/reference/data-types/index)) — Idle interval in milliseconds of the background task which purges invalidated (lazily-removed) priority queue entries
* `invalidated_entries_cleanup_threshold` ([UInt64](/reference/data-types/index)) — Number of accumulated invalidated priority queue entries which triggers their background removal
* `invalidated_entries_cleanup_remove_batch` ([UInt64](/reference/data-types/index)) — Maximum number of invalidated priority queue entries removed under a single write lock per background iteration
* `enable_filesystem_query_cache_limit` ([UInt8](/reference/data-types/index)) — Enable limiting maximum size of cache which can be written within a query
* `cache_hits_threshold` ([UInt64](/reference/data-types/index)) — Deprecated setting
* `enable_bypass_cache_with_threshold` ([UInt8](/reference/data-types/index)) — Undocumented. Not recommended for use
* `bypass_cache_threshold` ([UInt64](/reference/data-types/index)) — Undocumented. Not recommended for use
* `write_cache_per_user_id_directory` ([UInt8](/reference/data-types/index)) — Internal ClickHouse Cloud setting
* `allow_dynamic_cache_resize` ([UInt8](/reference/data-types/index)) — Allow dynamic resize of filesystem cache
* `dynamic_resize_lock_wait_ms` ([UInt64](/reference/data-types/index)) — Timeout in milliseconds to acquire the dynamic resize exclusive lock before skipping the resize attempt
* `max_size_ratio_to_total_space` ([Float64](/reference/data-types/index)) — Ratio of `max_size` to total disk space
* `skip_cache_on_disk_failure` ([UInt8](/reference/data-types/index)) — If true, bypass filesystem cache operations silently on disk IO errors. If false (default), disk IO errors are propagated as startup failures.
* `use_split_cache` ([UInt8](/reference/data-types/index)) — Use separation of files to system/data.
* `split_cache_ratio` ([Float64](/reference/data-types/index)) — Ratio of system segment to total size of cache for split\_cache.
* `overcommit_eviction_evict_step` ([UInt64](/reference/data-types/index)) — Eviction step in bytes for overcommit eviction policy. Used for keep\_free\_space\_\*\_ratio settings
* `check_cache_probability` ([Float64](/reference/data-types/index)) — Works only for debug or sanitizer build. Checks cache correctness by going through all cache and checking state of each cache element
* `is_initialized` ([UInt8](/reference/data-types/index)) — Indicates whether cache was successfully initialized
* `current_size` ([UInt64](/reference/data-types/index)) — Current cache size
* `current_elements_num` ([UInt64](/reference/data-types/index)) — Current cache elements (file segments) number