Server Settings

- [abort\_on\_logical\_error](#abort_on_logical_error)- [access\_control\_improvements](#access_control_improvements)- [access\_control\_path](#access_control_path)- [aggregate\_function\_group\_array\_action\_when\_limit\_is\_reached](#aggregate_function_group_array_action_when_limit_is_reached)- [aggregate\_function\_group\_array\_max\_element\_size](#aggregate_function_group_array_max_element_size)- [allow\_experimental\_webassembly\_udf](#allow_experimental_webassembly_udf)- [allow\_feature\_tier](#allow_feature_tier)- [allow\_impersonate\_user](#allow_impersonate_user)- [allow\_implicit\_no\_password](#allow_implicit_no_password)- [allow\_no\_password](#allow_no_password)- [allow\_plaintext\_password](#allow_plaintext_password)- [allow\_use\_jemalloc\_memory](#allow_use_jemalloc_memory)- [allowed\_disks\_for\_table\_engines](#allowed_disks_for_table_engines)- [async\_insert\_queue\_flush\_on\_shutdown](#async_insert_queue_flush_on_shutdown)- [async\_insert\_threads](#async_insert_threads)- [async\_load\_databases](#async_load_databases)- [async\_load\_system\_database](#async_load_system_database)- [asynchronous\_heavy\_metrics\_update\_period\_s](#asynchronous_heavy_metrics_update_period_s)- [asynchronous\_insert\_log](#asynchronous_insert_log)- [asynchronous\_metric\_log](#asynchronous_metric_log)- [asynchronous\_metrics\_enable\_heavy\_metrics](#asynchronous_metrics_enable_heavy_metrics)- [asynchronous\_metrics\_keeper\_metrics\_only](#asynchronous_metrics_keeper_metrics_only)- [asynchronous\_metrics\_update\_period\_s](#asynchronous_metrics_update_period_s)- [auth\_use\_forwarded\_address](#auth_use_forwarded_address)- [background\_buffer\_flush\_schedule\_pool\_size](#background_buffer_flush_schedule_pool_size)- [background\_common\_pool\_size](#background_common_pool_size)- [background\_distributed\_schedule\_pool\_size](#background_distributed_schedule_pool_size)- [background\_fetches\_pool\_size](#background_fetches_pool_size)- [background\_merges\_mutations\_concurrency\_ratio](#background_merges_mutations_concurrency_ratio)- [background\_merges\_mutations\_scheduling\_policy](#background_merges_mutations_scheduling_policy)- [background\_message\_broker\_schedule\_pool\_size](#background_message_broker_schedule_pool_size)- [background\_move\_pool\_size](#background_move_pool_size)- [background\_pool\_size](#background_pool_size)- [background\_schedule\_pool\_log](#background_schedule_pool_log)- [background\_schedule\_pool\_max\_parallel\_tasks\_per\_type\_ratio](#background_schedule_pool_max_parallel_tasks_per_type_ratio)- [background\_schedule\_pool\_size](#background_schedule_pool_size)- [backup\_log](#backup_log)- [backup\_threads](#backup_threads)- [backups](#backups)- [backups\_io\_thread\_pool\_queue\_size](#backups_io_thread_pool_queue_size)- [bcrypt\_workfactor](#bcrypt_workfactor)- [blob\_storage\_log](#blob_storage_log)- [builtin\_dictionaries\_reload\_interval](#builtin_dictionaries_reload_interval)- [cache\_size\_to\_ram\_max\_ratio](#cache_size_to_ram_max_ratio)- [cannot\_allocate\_thread\_fault\_injection\_probability](#cannot_allocate_thread_fault_injection_probability)- [cgroups\_memory\_usage\_observer\_wait\_time](#cgroups_memory_usage_observer_wait_time)- [compiled\_expression\_cache\_elements\_size](#compiled_expression_cache_elements_size)- [compiled\_expression\_cache\_size](#compiled_expression_cache_size)- [compression](#compression)- [concurrent\_threads\_scheduler](#concurrent_threads_scheduler)- [concurrent\_threads\_soft\_limit\_num](#concurrent_threads_soft_limit_num)- [concurrent\_threads\_soft\_limit\_ratio\_to\_cores](#concurrent_threads_soft_limit_ratio_to_cores)- [config-file](#config-file)- [config\_reload\_interval\_ms](#config_reload_interval_ms)- [core\_dump](#core_dump)- [cpu\_slot\_preemption](#cpu_slot_preemption)- [cpu\_slot\_preemption\_timeout\_ms](#cpu_slot_preemption_timeout_ms)- [cpu\_slot\_quantum\_ns](#cpu_slot_quantum_ns)- [crash\_log](#crash_log)- [custom\_cached\_disks\_base\_directory](#custom_cached_disks_base_directory)- [custom\_settings\_prefixes](#custom_settings_prefixes)- [database\_atomic\_delay\_before\_drop\_table\_sec](#database_atomic_delay_before_drop_table_sec)- [database\_catalog\_drop\_error\_cooldown\_sec](#database_catalog_drop_error_cooldown_sec)- [database\_catalog\_drop\_table\_concurrency](#database_catalog_drop_table_concurrency)- [database\_catalog\_unused\_dir\_cleanup\_period\_sec](#database_catalog_unused_dir_cleanup_period_sec)- [database\_catalog\_unused\_dir\_hide\_timeout\_sec](#database_catalog_unused_dir_hide_timeout_sec)- [database\_catalog\_unused\_dir\_rm\_timeout\_sec](#database_catalog_unused_dir_rm_timeout_sec)- [database\_replicated\_allow\_detach\_permanently](#database_replicated_allow_detach_permanently)- [database\_replicated\_drop\_broken\_tables](#database_replicated_drop_broken_tables)- [dead\_letter\_queue](#dead_letter_queue)- [default\_database](#default_database)- [default\_password\_type](#default_password_type)- [default\_profile](#default_profile)- [default\_replica\_name](#default_replica_name)- [default\_replica\_path](#default_replica_path)- [default\_session\_timeout](#default_session_timeout)- [dictionaries\_config](#dictionaries_config)- [dictionaries\_lazy\_load](#dictionaries_lazy_load)- [dictionaries\_lib\_path](#dictionaries_lib_path)- [dictionary\_background\_reconnect\_interval](#dictionary_background_reconnect_interval)- [disable\_insertion\_and\_mutation](#disable_insertion_and_mutation)- [disable\_internal\_dns\_cache](#disable_internal_dns_cache)- [disable\_tunneling\_for\_https\_requests\_over\_http\_proxy](#disable_tunneling_for_https_requests_over_http_proxy)- [disk\_connections\_hard\_limit](#disk_connections_hard_limit)- [disk\_connections\_soft\_limit](#disk_connections_soft_limit)- [disk\_connections\_store\_limit](#disk_connections_store_limit)- [disk\_connections\_warn\_limit](#disk_connections_warn_limit)- [disk\_transaction\_wait\_for\_blob\_removal](#disk_transaction_wait_for_blob_removal)- [display\_secrets\_in\_show\_and\_select](#display_secrets_in_show_and_select)- [distributed\_cache\_apply\_throttling\_settings\_from\_client](#distributed_cache_apply_throttling_settings_from_client)- [distributed\_cache\_keep\_up\_free\_connections\_ratio](#distributed_cache_keep_up_free_connections_ratio)- [distributed\_ddl](#distributed_ddl)- [distributed\_ddl.cleanup\_delay\_period](#distributed_ddl.cleanup_delay_period)- [distributed\_ddl.max\_tasks\_in\_queue](#distributed_ddl.max_tasks_in_queue)- [distributed\_ddl.path](#distributed_ddl.path)- [distributed\_ddl.pool\_size](#distributed_ddl.pool_size)- [distributed\_ddl.profile](#distributed_ddl.profile)- [distributed\_ddl.replicas\_path](#distributed_ddl.replicas_path)- [distributed\_ddl.task\_max\_lifetime](#distributed_ddl.task_max_lifetime)- [distributed\_ddl\_use\_initial\_user\_and\_roles](#distributed_ddl_use_initial_user_and_roles)- [dns\_allow\_resolve\_names\_to\_ipv4](#dns_allow_resolve_names_to_ipv4)- [dns\_allow\_resolve\_names\_to\_ipv6](#dns_allow_resolve_names_to_ipv6)- [dns\_cache\_max\_entries](#dns_cache_max_entries)- [dns\_cache\_update\_period](#dns_cache_update_period)- [dns\_max\_consecutive\_failures](#dns_max_consecutive_failures)- [drop\_distributed\_cache\_pool\_size](#drop_distributed_cache_pool_size)- [drop\_distributed\_cache\_queue\_size](#drop_distributed_cache_queue_size)- [enable\_azure\_sdk\_logging](#enable_azure_sdk_logging)- [encryption](#encryption)- [enforce\_keeper\_component\_tracking](#enforce_keeper_component_tracking)- [error\_log](#error_log)- [filesystem\_caches\_path](#filesystem_caches_path)- [format\_parsing\_thread\_pool\_queue\_size](#format_parsing_thread_pool_queue_size)- [format\_schema\_path](#format_schema_path)- [global\_profiler\_cpu\_time\_period\_ns](#global_profiler_cpu_time_period_ns)- [global\_profiler\_real\_time\_period\_ns](#global_profiler_real_time_period_ns)- [google\_protos\_path](#google_protos_path)- [graphite](#graphite)- [graphite\_rollup](#graphite_rollup)- [hdfs.libhdfs3\_conf](#hdfs.libhdfs3_conf)- [hsts\_max\_age](#hsts_max_age)-