\u8bf4\u660e<\/h2>\n
ClickHouse\u7684\u914d\u7f6e\u6587\u4ef6\u662fconfig.xml\uff0c\u9ed8\u8ba4\u5728\/etc\/clickhouse-server\/\u76ee\u5f55\u4e2d\uff0c\u53ef\u4ee5\u5728conf.d\u548cconfig.d\u76ee\u5f55\u4e2d\u7684*.xml\u548c*.conf\u6587\u4ef6\u4e2d\u8986\u76d6\u5404\u4e2a\u8bbe\u7f6e\u3002\u8fd8\u53ef\u4ee5\u4e3a\u8fd9\u4e9b\u914d\u7f6e\u6587\u4ef6\u7684\u5143\u7d20\u6307\u5b9areplace\u6216remove\u5c5e\u6027\uff0c\u5982\u679c\u5747\u672a\u6307\u5b9a\uff0c\u5b83\u5c06\u4ee5\u9012\u5f52\u65b9\u5f0f\u5408\u5e76\u5143\u7d20\u7684\u5185\u5bb9\uff0c\u4ece\u800c\u66ff\u6362\u91cd\u590d\u5b50\u5143\u7d20\u7684\u503c\u3002\u5982\u679c\u6307\u5b9a\u4e86replace\uff0c\u5c06\u7528\u6307\u5b9a\u7684\u5143\u7d20\u66ff\u6362\u6574\u4e2a\u5143\u7d20\u3002\u5982\u679c\u6307\u5b9a\u4e86remove\uff0c\u5219\u5220\u9664\u8be5\u5143\u7d20\u3002
\n\u914d\u7f6e\u6587\u4ef6\u8fd8\u53ef\u4ee5\u5b9a\u4e49substitutions\uff08\u66ff\u4ee3\uff09\u3002\u5982\u679c\u5143\u7d20\u5177\u6709incl\u5c5e\u6027\uff0c\u5219\u6587\u4ef6\u4e2d\u7684\u76f8\u5e94\u503c\u5c06\u88ab\u66ff\u6362\u3002\u66ff\u6362\u6587\u4ef6\u7684\u8def\u5f84\u4e3a\/etc\/metrika.xml\u3002\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6\u52a0\u5165include_from\u5143\u7d20\u8fdb\u884c\u66f4\u6539\u3002\u66ff\u6362\u503c\u5728\u6b64\u6587\u4ef6\u7684\/yandex\/substitution_name\u5143\u7d20\u4e2d\u6307\u5b9a\u3002\u5982\u679cincl\u4e2d\u6307\u5b9a\u7684\u66ff\u4ee3\u4e0d\u5b58\u5728\uff0c\u5219\u5c06\u5176\u8bb0\u5f55\u5728\u65e5\u5fd7\u4e2d\u3002\u4e3a\u4e86\u9632\u6b62ClickHouse\u8bb0\u5f55\u7f3a\u5c11\u7684\u66ff\u4ee3\u9879\uff0c\u8bf7\u6307\u5b9a\uff1aoptional= true\u5c5e\u6027\u3002
\n\u53ef\u4ee5\u4eceZooKeeper\u4e2d\u8fdb\u884c\u66ff\u6362\uff0c\u6307\u5b9a\u5c5e\u6027from_zk =\u201c \/path\/to\/node\u201d\u3002\u5143\u7d20\u503c\u5c06\u66ff\u6362\u4e3aZooKeeper\u4e2d\/path\/to\/node\u4e0a\u8282\u70b9\u7684\u5185\u5bb9\u3002\u8fd8\u53ef\u4ee5\u5c06\u6574\u4e2aXML\u5b50\u6811\u653e\u5728ZooKeeper\u8282\u70b9\u4e0a\uff0c\u5e76\u5c06\u5176\u5b8c\u5168\u63d2\u5165\u5230source\u5143\u7d20\u4e2d\u3002
\nconfig.xml\u6587\u4ef6\u53ef\u4ee5\u4f7f\u7528users\u8bbe\u7f6e\uff0c\u4e3aprofiles\u548cquotas\u6307\u5b9a\u5355\u72ec\u7684\u914d\u7f6e\u3002\u6b64\u914d\u7f6e\u7684\u76f8\u5bf9\u8def\u5f84\u5728\\’users_config\\’\u5143\u7d20\u4e2d\u8bbe\u7f6e\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u662fusers.xml\u3002\u5982\u679c\u7701\u7565users_config\uff0c\u5219\u76f4\u63a5\u5728config.xml\u4e2d\u6307\u5b9a\u3002<\/p>\n
\u914d\u7f6e\u53c2\u6570<\/h2>\n
\u4e86\u89e3\u4e86\u5404\u4e2a\u53c2\u6570\u7684\u76ee\u7684\u662f\u66f4\u597d\u8fdb\u884c\u914d\u7f6e\u548c\u4f7f\u7528\u8d44\u6e90\u7684\u9650\u5236\uff0c\u5173\u4e8e\u53c2\u6570\u7684\u8be6\u7ec6\u8bf4\u660e\u53ef\u4ee5\u770b\u5b98\u65b9\u6587\u6863\uff1aServer settings<\/a>\u3001Settings<\/a><\/p>\n 1.\u00a0builtin_dictionaries_reload_interval\uff1a\u91cd\u65b0\u52a0\u8f7d\u5185\u7f6e\u8bcd\u5178\u7684\u65f6\u95f4\u95f4\u9694\uff08\u4ee5\u79d2\u4e3a\u5355\u4f4d\uff09\uff0c\u9ed8\u8ba43600\u3002\u53ef\u4ee5\u5728\u4e0d\u91cd\u65b0\u542f\u52a8\u670d\u52a1\u5668\u7684\u60c5\u51b5\u4e0b\u201c\u5373\u65f6\u201d\u4fee\u6539\u8bcd\u5178\u3002<\/p>\n 2. compression\uff1aMergeTree\u5f15\u64ce\u8868\u7684\u6570\u636e\u538b\u7f29\u8bbe\u7f6e\u3002\u914d\u7f6e\u6a21\u677f\u5982\uff1a<\/p>\n \u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a<case>\u3002\u5982\u679c\u6570\u636e\u90e8\u5206\u4e0e\u6761\u4ef6\u96c6\u5339\u914d\uff0c\u4f7f\u7528\u6307\u5b9a\u7684\u538b\u7f29\u65b9\u6cd5\uff1b\u5982\u679c\u6570\u636e\u90e8\u5206\u5339\u914d\u591a\u4e2a\u6761\u4ef6\u96c6\uff0c\u5c06\u4f7f\u7528\u7b2c\u4e00\u4e2a\u5339\u914d\u7684\u6761\u4ef6\u96c6\uff1b\u5982\u679c\u6570\u636e\u90e8\u5206\u4e0d\u6ee1\u8db3\u4efb\u4f55\u6761\u4ef6\uff0c\u5219\u4f7f\u7528lz4\u538b\u7f29\u3002 4.\u00a0default_profile\uff1a\u9ed8\u8ba4\u8bbe\u7f6e\u914d\u7f6e\u6587\u4ef6\uff0c\u5728\u53c2\u6570user_config\u4e2d\u6307\u5b9a\u3002<\/p>\n 5.\u00a0dictionaries_config\uff1a\u5916\u90e8\u8bcd\u5178<\/a>\u7684\u914d\u7f6e\u6587\u4ef6\u7684\u8def\u5f84\uff0c\u5728config\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9a\u3002\u8def\u5f84\u53ef\u4ee5\u5305\u542b\u901a\u914d\u7b26*\u548c\uff1f\u7684\u7edd\u5bf9\u6216\u5219\u76f8\u5bf9\u8def\u5f84\u3002<\/p>\n 6.\u00a0dictionaries_lazy_load\uff1a\u5ef6\u8fdf\u52a0\u8f7d\u8bcd\u5178\uff0c\u9ed8\u8ba4false\u3002 7.\u00a0format_schema_path\uff1a\u5305\u542b\u8f93\u5165\u683c\u5f0f\u6587\u4ef6\uff08\u4f8b\u5982CapnProto\u683c\u5f0f\u7684\u65b9\u6848\uff09\u7684\u76ee\u5f55\u8def\u5f84\u3002<\/p>\n 8.\u00a0graphite\uff1a\u5c06\u6570\u636e\u53d1\u9001\u5230Graphite<\/a>\uff0c\u5b83\u662f\u4e00\u6b3e\u4f01\u4e1a\u7ea7\u76d1\u63a7\u3002<\/p>\n \u53ef\u4ee5\u914d\u7f6e\u591a\u4e2a<graphite>\u5b50\u53e5\u3002\u4f8b\u5982\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u5b83\u4ee5\u4e0d\u540c\u7684\u65f6\u95f4\u95f4\u9694\u53d1\u9001\u4e0d\u540c\u7684\u6570\u636e\u3002\u540e\u671f\u76d1\u63a7\u4f1a\u5355\u72ec\u5199\u7bc7\u6587\u7ae0\u4ecb\u7ecd\uff0c\u76ee\u524d\u6682\u65f6\u8fdb\u884c\u8bf4\u660e\u3002 10.\u00a0http_port\/https_port\uff1a\u901a\u8fc7HTTP\u8fde\u63a5\u5230\u670d\u52a1\u5668\u7684\u7aef\u53e3\u3002\u5982\u679c\u6307\u5b9a\u4e86https_port\uff0c\u5219\u5fc5\u987b\u914d\u7f6eopenSSL\u3002\u5982\u679c\u6307\u5b9a\u4e86http_port\uff0c\u5219\u5373\u4f7f\u5df2\u8bbe\u7f6eopenSSL\u914d\u7f6e\uff0c\u4e5f\u4f1a\u5c06\u5176\u5ffd\u7565\u3002<\/p>\n 11.\u00a0http_server_default_response\uff1a\u8bbf\u95eeClickHouse HTTP\u670d\u52a1\u5668\u65f6\u9ed8\u8ba4\u663e\u793a\u7684\u9875\u9762\u3002\u9ed8\u8ba4\u503c\u4e3a\u201cOK\u201d\uff08\u672b\u5c3e\u6709\u6362\u884c\u7b26\uff09<\/p>\n 12.\u00a0include_from\uff1a\u5e26\u66ff\u6362\u6587\u4ef6\u7684\u8def\u5f84\uff0c\u6709\u5173\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u89c1\u201cConfiguration files<\/a>\u201d\u90e8\u5206\u3002<\/p>\n 13.\u00a0interserver_http_port\uff1a\u4e8e\u5728ClickHouse\u670d\u52a1\u5668\u4e4b\u95f4\u4ea4\u6362\u6570\u636e\u7684\u7aef\u53e3\u3002<\/p>\n 14.\u00a0interserver_http_host\uff1a\u5176\u4ed6\u670d\u52a1\u5668\u53ef\u4ee5\u7528\u6765\u8bbf\u95ee\u8be5\u670d\u52a1\u5668\u7684\u4e3b\u673a\u540d\u3002\u5982\u679c\u7701\u7565\uff0c\u5219\u5176\u5b9a\u4e49\u65b9\u6cd5\u4e0ehostname -f\u547d\u4ee4\u76f8\u540c\u3002<\/p>\n 15.\u00a0interserver_http_credentials\uff1a\u5728\u4f7f\u7528Replicated *\u5f15\u64ce\u8fdb\u884c\u590d\u5236\u671f\u95f4\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u7684\u7528\u6237\u540d\u548c\u5bc6\u7801\u3002 \u8fd9\u4e9b\u51ed\u636e\u4ec5\u7528\u4e8e\u526f\u672c\u4e4b\u95f4\u7684\u901a\u4fe1\uff0c\u4e0eClickHouse\u5ba2\u6237\u7aef\u7684\u51ed\u636e\u65e0\u5173\u3002 \u670d\u52a1\u5668\u6b63\u5728\u68c0\u67e5\u8fd9\u4e9b\u51ed\u636e\u4ee5\u8fde\u63a5\u526f\u672c\uff0c\u5e76\u5728\u8fde\u63a5\u5230\u5176\u4ed6\u526f\u672c\u65f6\u4f7f\u7528\u76f8\u540c\u7684\u51ed\u636e\u3002 \u56e0\u6b64\uff0c\u5bf9\u4e8e\u7fa4\u96c6\u4e2d\u7684\u6240\u6709\u526f\u672c\uff0c\u5e94\u5c06\u8fd9\u4e9b\u51ed\u636e\u8bbe\u7f6e\u4e3a\u76f8\u540c\u3002\u9ed8\u8ba4\u4e0d\u4f7f\u7528\u8eab\u4efd\u9a8c\u8bc1\u3002<\/p>\n 16.\u00a0keep_alive_timeout\uff1aClickHouse\u5728\u5173\u95ed\u8fde\u63a5\u4e4b\u524d\u7b49\u5f85\u4f20\u5165\u8bf7\u6c42\u7684\u79d2\u6570\u3002 \u9ed8\u8ba4\u4e3a3\u79d2\u3002<\/p>\n 17.\u00a0listen_host\uff1a\u9650\u5236\u6765\u6e90\u4e3b\u673a\u7684\u8bf7\u6c42\uff0c\u00a0\u5982\u679c\u8981\u670d\u52a1\u5668\u56de\u7b54\u6240\u6709\u8bf7\u6c42\uff0c\u8bf7\u6307\u5b9a\u201c::\u201d \uff1a<\/p>\n 18.\u00a0logger\uff1a\u65e5\u5fd7\u8bb0\u5f55\u8bbe\u7f6e\u3002\u9009\u9879\u7ec4\u91cc\u7684\u8bbe\u7f6e\u6709\uff1alevel\u3001log\u3001errorlog\u3001size\u3001count\uff1a<\/p>\n \u8fd8\u652f\u6301\u5199\u5165\u7cfb\u7edf\u65e5\u5fd7\uff1a<\/p>\n 19.\u00a0macros\uff1a\u590d\u5236\u8868\u7684\u53c2\u6570\u66ff\u6362\uff0c\u5982\u679c\u4e0d\u4f7f\u7528\u590d\u5236\u8868\uff0c\u5219\u53ef\u4ee5\u7701\u7565\u3002\u6709\u5173\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u89c1\u201cCreating replicated tables<\/a>\u201d<\/p>\n 20.\u00a0mark_cache_size\uff1a\u6807\u8bb0\u7f13\u5b58\u7684\u5927\u5c0f\uff0c\u7528\u4e8eMergeTree\u7cfb\u5217\u7684\u8868\u4e2d\u3002 \u00a0\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff0c\u5171\u4eab\u670d\u52a1\u5668\u7684\u7f13\u5b58\uff0c\u5e76\u6839\u636e\u9700\u8981\u5206\u914d\u5185\u5b58\u3002\u7f13\u5b58\u5927\u5c0f\u5fc5\u987b\u81f3\u5c11\u4e3a5368709120\uff085G\uff09\u3002<\/p>\n 21.\u00a0max_concurrent_queries\uff1a\u540c\u65f6\u5904\u7406\u7684\u6700\u5927\u8bf7\u6c42\u6570\u3002<\/p>\n 22.\u00a0max_connections\uff1a\u6700\u5927\u8fde\u63a5\u6570\u3002<\/p>\n 23.\u00a0max_open_files\uff1a\u6253\u5f00\u6700\u5927\u7684\u6587\u4ef6\u6570\uff0c\u9ed8\u8ba4\u6700\u5927\u503c<\/p>\n 24.\u00a0max_table_size_to_drop\uff1a\u5220\u9664\u8868\u7684\u9650\u5236\uff0c\u9ed8\u8ba450G\uff0c0\u8868\u793a\u4e0d\u9650\u5236\u3002\u5982\u679cMergeTree\u8868\u7684\u5927\u5c0f\u8d85\u8fc7max_table_size_to_drop\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\uff0c\u5219\u65e0\u6cd5\u4f7f\u7528DROP\u67e5\u8be2\u5c06\u5176\u5220\u9664\u3002\u5982\u679c\u4ecd\u7136\u9700\u8981\u5220\u9664\u8868\u800c\u4e0d\u91cd\u65b0\u542f\u52a8ClickHouse\u670d\u52a1\u5668\uff0c\u8bf7\u521b\u5efa<clickhouse-path>\/flags\/force_drop_table\u6587\u4ef6\u5e76\u8fd0\u884cDROP\u67e5\u8be2\u3002<\/p>\n 25.\u00a0merge_tree\uff1a\u5bf9MergeTree<\/a>\u4e2d\u7684\u8868\u8fdb\u884c\u8c03\u6574\uff0c\u6709\u5173\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u89c1MergeTreeSettings.h\u5934\u6587\u4ef6\u3002<\/p>\n 26.\u00a0openSSL\uff1aSSL\u5ba2\u6237\u7aef\/\u670d\u52a1\u5668\u914d\u7f6e\u3002\u670d\u52a1\u5668\/\u5ba2\u6237\u7aef\u8bbe\u7f6e\uff1a<\/p>\n 27.\u00a0part_log\uff1a\u8bb0\u5f55\u4e0eMergeTree\u5173\u8054\u7684\u4e8b\u4ef6\u3002\u5982\u6dfb\u52a0\u6216\u5408\u5e76\u6570\u636e\u3002\u53ef\u4ee5\u4f7f\u7528\u65e5\u5fd7\u6765\u6a21\u62df\u5408\u5e76\u7b97\u6cd5\u5e76\u6bd4\u8f83\u5176\u7279\u5f81\u3002 \u67e5\u8be2\u8bb0\u5f55\u5728system.part_log\u8868\u4e2d\uff0c\u800c\u4e0d\u8bb0\u5f55\u5728\u5355\u72ec\u7684\u6587\u4ef6\u4e2d\u3002 \u60a8\u53ef\u4ee5\u5728table\u53c2\u6570\u4e2d\u914d\u7f6e\u8be5\u8868\u7684\u540d\u79f0\uff08<part_log>\uff09\u3002\u4f7f\u7528\u4ee5\u4e0b\u53c2\u6570\u6765\u914d\u7f6e\u65e5\u5fd7\u8bb0\u5f55\uff1a<\/p>\n 28. path\uff1a\u6570\u636e\u7684\u76ee\u5f55\u8def\u5f84\u3002<\/p>\n 29.\u00a0query_log\uff1a\u901a\u8fc7log_queries = 1\u8bbe\u7f6e\uff0c\u8bb0\u5f55\u63a5\u6536\u5230\u7684\u67e5\u8be2\u3002\u67e5\u8be2\u8bb0\u5f55\u5728system.query_log\u8868\u4e2d\uff0c\u800c\u4e0d\u8bb0\u5f55\u5728\u5355\u72ec\u7684\u6587\u4ef6\u4e2d\u3002\u53ef\u4ee5\u5728table\u53c2\u6570\u4e2d\u66f4\u6539\u8868\u7684\u540d\u79f0\u3002<\/p>\n \u5982\u679c\u8be5\u8868\u4e0d\u5b58\u5728\uff0cClickHouse\u5c06\u521b\u5efa\u5b83\u3002\u5982\u679c\u5728\u66f4\u65b0ClickHouse\u670d\u52a1\u5668\u65f6\u67e5\u8be2\u65e5\u5fd7\u7684\u7ed3\u6784\u53d1\u751f\u4e86\u66f4\u6539\uff0c\u5219\u5177\u6709\u65e7\u7ed3\u6784\u7684\u8868\u5c06\u91cd\u547d\u540d\uff0c\u5e76\u81ea\u52a8\u521b\u5efa\u4e00\u4e2a\u65b0\u8868\u3002 \u5982\u679c\u8be5\u8868\u4e0d\u5b58\u5728\uff0cClickHouse\u5c06\u521b\u5efa\u5b83\u3002\u5982\u679c\u5728\u66f4\u65b0ClickHouse\u670d\u52a1\u5668\u65f6\u67e5\u8be2\u7ebf\u7a0b\u65e5\u5fd7\u7684\u7ed3\u6784\u53d1\u751f\u4e86\u66f4\u6539\uff0c\u5219\u5177\u6709\u65e7\u7ed3\u6784\u7684\u8868\u5c06\u91cd\u547d\u540d\uff0c\u5e76\u81ea\u52a8\u521b\u5efa\u4e00\u4e2a\u65b0\u8868\u3002 32.\u00a0query_masking_rules\uff1a\u57fa\u4e8eRegexp\u7684\u89c4\u5219\uff0c\u5e94\u7528\u4e8e\u67e5\u8be2\u4ee5\u53ca\u6240\u6709\u65e5\u5fd7\u6d88\u606f\u3002\u518d\u5176\u5b58\u50a8\u5728\u670d\u52a1\u5668\u65e5\u5fd7\u4e2d\uff0csystem.query_log\uff0csystem.text_log\uff0csystem.processes\u8868\u4ee5\u53ca\u4ee5\u65e5\u5fd7\u5f62\u5f0f\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002\u8fd9\u6837\u53ef\u4ee5\u9632\u6b62SQL\u67e5\u8be2\u4e2d\u7684\u654f\u611f\u6570\u636e\u6cc4\u6f0f\u8bb0\u5f55\u5230\u65e5\u5fd7\u4e2d\u3002<\/p>\n \u89c4\u5219\u9002\u7528\u4e8e\u6574\u4e2a\u67e5\u8be2\uff0csystem.events\u8868\u5177\u6709\u8ba1\u6570\u5668QueryMaskingRulesMatch\uff0c\u8be5\u8ba1\u6570\u5668\u5177\u6709\u67e5\u8be2\u63a9\u7801\u89c4\u5219\u5339\u914d\u7684\u603b\u6570\u3002\u5bf9\u4e8e\u5206\u5e03\u5f0f\u67e5\u8be2\uff0c\u5fc5\u987b\u5206\u522b\u914d\u7f6e\u6bcf\u4e2a\u670d\u52a1\u5668\uff0c\u5426\u5219\u5b50\u67e5\u8be2\u5c06\u4f20\u9012\u7ed9\u5176\u4ed6\u670d\u52a1\u5668\u8282\u70b9\u5c06\u88ab\u5b58\u50a8\u800c\u4e0d\u4f1a\u5c4f\u853d\u3002 34.\u00a0timezone\uff1a\u670d\u52a1\u5668\u7684\u65f6\u533a\uff0c\u5b9a\u4e3aUTC\u65f6\u533a\u6216\u5730\u7406\u4f4d\u7f6e\uff08\u4f8b\u5982\uff0c\u975e\u6d32\/\u963f\u6bd4\u8ba9\uff09\u7684IANA\u6807\u8bc6\u7b26\u3002 35. tcp_port\uff1a\u901a\u8fc7TCP\u534f\u8bae\u4e0e\u5ba2\u6237\u7aef\u8fdb\u884c\u901a\u4fe1\u7684\u7aef\u53e3\uff0c\u5373ClickHouse\u7aef\u53e3\u3002<\/p>\n 36. tcp_port_secure\uff1a\u901a\u8fc7TCP\u534f\u8bae\u4e0e\u5ba2\u6237\u7aef\u8fdb\u884c\u901a\u4fe1\u7684\u7aef\u53e3\uff0c\u5373ClickHouse\u7aef\u53e3\u3002 \u4e0eOpenSSL\u8bbe\u7f6e\u4e00\u8d77\u4f7f\u7528\u3002<\/p>\n 37.\u00a0mysql_port\uff1a\u901a\u8fc7MySQL\u534f\u8bae\u4e0e\u5ba2\u6237\u7aef\u901a\u4fe1\u7684\u7aef\u53e3\u3002<\/p>\n 38.\u00a0tmp_path\uff1a\u7528\u4e8e\u5904\u7406\u5927\u578b\u67e5\u8be2\u7684\u4e34\u65f6\u6570\u636e\u7684\u8def\u5f84\u3002<\/p>\n 39.\u00a0tmp_policy\uff1a\u4ecestorage_configuration\u7684\u7b56\u7565\uff0c\u7528\u4e8e\u5b58\u50a8\u4e34\u65f6\u6587\u4ef6\u3002\u5982\u679c\u672a\u8bbe\u7f6e\uff0c\u5219\u4f7f\u7528tmp_path\uff0c\u5426\u5219\u5c06\u5ffd\u7565\u5b83\u3002 41.\u00a0user_files_path\uff1a\u5305\u542b\u7528\u6237\u6587\u4ef6\u7684\u76ee\u5f55\uff0c\u5728\u8868\u51fd\u6570file()\u4e2d\u4f7f\u7528\u3002<\/p>\n 42.\u00a0users_config\uff1a\u7528\u6237\u914d\u7f6e\u6587\u4ef6\uff0c\u53ef\u4ee5\u914d\u7f6e\u7528\u6237\u8bbf\u95ee\u3001profiles\u3001quota\u3001\u67e5\u8be2\u7b49\u7ea7\u7b49\u3002<\/p>\n 43.\u00a0zookeeper\uff1aClickHouse\u4e0eZooKeeper\u7fa4\u96c6\u8fdb\u884c\u4ea4\u4e92\u7684\u8bbe\u7f6e\u3002\u4f7f\u7528\u590d\u5236\u8868\u65f6\uff0cClickHouse\u4f7f\u7528ZooKeeper\u6765\u5b58\u50a8\u526f\u672c\u7684\u5143\u6570\u636e\u3002\u5982\u679c\u4e0d\u4f7f\u7528\u590d\u5236\u8868\uff0c\u5219\u53ef\u4ee5\u5ffd\u7565\u6b64\u53c2\u6570\u3002<\/p>\n 44.\u00a0use_minimalistic_part_header_in_zookeeper\uff1aZooKeeper\u4e2d\u6570\u636e\u90e8\u5206\u5934\u7684\u5b58\u50a8\u65b9\u6cd5\u30021\uff1a\u6253\u5f00\uff1b0\b\uff1a\u5173\u95ed\u3002\u9ed8\u8ba40 \u5982\u679cuse_minimalistic_part_header_in_zookeeper = 1\uff0c\u5219\u590d\u5236\u7684\u8868\u4f7f\u7528\u5355\u4e2aznode\u7d27\u51d1\u5730\u5b58\u50a8\u6570\u636e\u90e8\u5206\u7684\u5934\u3002 \u5982\u679c\u8868\u5305\u542b\u8bb8\u591a\u5217\uff0c\u5219\u6b64\u5b58\u50a8\u65b9\u6cd5\u5c06\u5927\u5927\u51cf\u5c11Zookeeper\u4e2d\u5b58\u50a8\u7684\u6570\u636e\u91cf\u3002\u4f46\u65e0\u6cd5\u5c06ClickHouse\u670d\u52a1\u5668\u964d\u7ea7\u5230\u4e0d\u652f\u6301\u6b64\u8bbe\u7f6e\u7684\u7248\u672c\uff0c\u5728\u7fa4\u96c6\u4e2d\u7684\u670d\u52a1\u5668\u4e0a\u5347\u7ea7ClickHouse\u65f6\u8981\u5c0f\u5fc3\u3002 \u4e0d\u8981\u4e00\u6b21\u5347\u7ea7\u6240\u6709\u670d\u52a1\u5668\u3002 \u5728\u6d4b\u8bd5\u73af\u5883\u4e2d\u6216\u4ec5\u5728\u7fa4\u96c6\u4e2d\u7684\u51e0\u53f0\u670d\u52a1\u5668\u4e0a\u6d4b\u8bd5ClickHouse\u7684\u65b0\u7248\u672c\u66f4\u4e3a\u5b89\u5168\u3002\u5df2\u7ecf\u4f7f\u7528\u6b64\u8bbe\u7f6e\u5b58\u50a8\u7684\u6570\u636e\u90e8\u4ef6\u6807\u9898\u65e0\u6cd5\u6062\u590d\u4e3a\u5176\u4ee5\u524d\u7684\uff08\u975e\u7d27\u51d1\uff09\u8868\u793a\u5f62\u5f0f\u3002 1.\u00a0distributed_product_mode\uff1a\u66f4\u6539\u5206\u5e03\u5f0f\u5b50\u67e5\u8be2\u7684\u884c\u4e3a\u3002\u5f53\u67e5\u8be2\u5305\u542b\u5206\u5e03\u5f0f\u8868\u7684\u4e58\u79ef\uff0c\u5373\u5f53\u5206\u5e03\u5f0f\u8868\u7684\u67e5\u8be2\u5305\u542b\u5206\u5e03\u5f0f\u8868\u7684\u975eGLOBAL\u5b50\u67e5\u8be2\u65f6\uff0cClickHouse\u5c06\u5e94\u7528\u6b64\u8bbe\u7f6e\u3002 \u53ef\u8bbe\u7f6e\u7684\u503c\uff1a<\/p>\n 2.\u00a0enable_optimize_predicate_expression\uff1aSELECT\u67e5\u8be2\u4e2d\u6253\u5f00\u8c13\u8bcd\u4e0b\u63a8\uff0c\u8c13\u8bcd\u4e0b\u63a8\u53ef\u80fd\u4f1a\u5927\u5927\u51cf\u5c11\u5206\u5e03\u5f0f\u67e5\u8be2\u7684\u7f51\u7edc\u6d41\u91cf\u3002\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\u3002 16.\u00a0input_format_values_deduce_templates_of_expressions\uff1a\u542f\u7528\u6216\u7981\u7528SQL\u8868\u8fbe\u5f0f\u6a21\u677f\u63a8\u5bfc\u3002\u9ed8\u8ba41\u3002\u5982\u679c\u8fde\u7eed\u884c\u4e2d\u7684\u8868\u8fbe\u5f0f\u5177\u6709\u76f8\u540c\u7684\u7ed3\u6784\uff0c\u5219\u53ef\u4ee5\u66f4\u5feb\u5730\u89e3\u6790\u548c\u89e3\u91caValues\u4e2d\u7684\u8868\u8fbe\u5f0f\u3002 ClickHouse\u5c06\u5c1d\u8bd5\u63a8\u5bfc\u8868\u8fbe\u5f0f\u7684\u6a21\u677f\uff0c\u4f7f\u7528\u8be5\u6a21\u677f\u89e3\u6790\u4ee5\u4e0b\u884c\uff0c\u5e76\u5bf9\u6210\u529f\u89e3\u6790\u7684\u884c\u8fdb\u884c\u8bc4\u4f30\u3002\u5982\uff1a<\/p>\n 17.\u00a0input_format_values_accurate_types_of_literals\uff1a\u00a0\u4ec5\u5f53input_format_values_deduce_templates_of_expressions = 1\u65f6\u624d\u4f7f\u7528\u6b64\u8bbe\u7f6e\u3002\u53ef\u80fd\u4f1a\u53d1\u751f\u67d0\u4e9b\u5217\u7684\u8868\u8fbe\u5f0f\u5177\u6709\u76f8\u540c\u7684\u7ed3\u6784\uff0c\u4f46\u5305\u542b\u4e0d\u540c\u7c7b\u578b\u7684\u60c5\u51b5\uff0c\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\u3002\u5982\uff1a<\/p>\n \u542f\u7528\u6b64\u8bbe\u7f6e\u540e\uff0cClickHouse\u5c06\u68c0\u67e5\u5b9e\u9645\u7c7b\u578b\uff0c\u5e76\u5c06\u4f7f\u7528\u76f8\u5e94\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u6a21\u677f\u3002 \u5728\u67d0\u4e9b\u60c5\u51b5\u4e0b\uff0c\u53ef\u80fd\u4f1a\u5927\u5927\u51cf\u6162\u8868\u8fbe\u5f0f\u7684\u8bc4\u4f30\u3002\u7981\u7528\u540e\uff0cClickHouse\u53ef\u80fd\u4f1a\u4f7f\u7528\u66f4\u901a\u7528\u7684\u7c7b\u578b\uff08\u4f8b\u5982Float64\u6216Int64\u800c\u4e0d\u662f42\u7684UInt64\uff09\uff0c\u4f46\u53ef\u80fd\u4f1a\u5bfc\u81f4\u6ea2\u51fa\u548c\u7cbe\u5ea6\u95ee\u9898\u3002 \u53ef\u4ee5\u770bDateTime<\/a>\u6570\u636e\u7c7b\u578b\u548c\u65e5\u671f\u51fd\u6570<\/a>\u3002 26.\u00a0join_any_take_last_row\uff1a\u4e25\u683c\u66f4\u6539\u8054\u63a5\u64cd\u4f5c\u7684\u884c\u4e3a\uff0c\u4ec5\u9002\u7528\u4e8e\u5177\u6709Join\u5f15\u64ce\u8868\u7684JOIN\u64cd\u4f5c\u3002\u9ed8\u8ba4\u503c0\uff0c<\/p>\n \u53ef\u4ee5\u770bJOIN\u5b50\u53e5<\/a>\uff0c\u8054\u63a5\u8868\u5f15\u64ce<\/a>\u3002 28.\u00a0join_any_take_last_row\uff1a\u66f4\u6539ANY JOIN\u7684\u884c\u4e3a\u3002 \u7981\u7528\uff0cANY JOIN\u5c06\u83b7\u53d6\u627e\u5230\u7684\u7b2c\u4e00\u884c\u952e\u3002 \u542f\u7528\uff0c\u5982\u679c\u540c\u4e00\u952e\u6709\u591a\u4e2a\u884c\uff0c\u5219ANY JOIN\u4f1a\u83b7\u53d6\u6700\u540e\u5339\u914d\u7684\u884c\u3002 \u8be5\u8bbe\u7f6e\u4ec5\u5728\u8054\u63a5\u8868\u5f15\u64ce\u4e2d\u4f7f\u7528\u3002\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\u3002 \u5bf9\u4e8e\u7531\u4e8eLIMIT\u800c\u5feb\u901f\u5b8c\u6210\u7684\u67e5\u8be2\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u8f83\u4f4e\u7684\u201cmax_threads\u201d\u3002<\/p>\n 44.\u00a0max_insert_threads\uff1a\u6267\u884cINSERT SELECT\u67e5\u8be2\u7684\u6700\u5927\u7ebf\u7a0b\u6570\u3002\u9ed8\u8ba4\u503c0\uff0c\u53ef\u90090\u3001\u6b63\u6574\u6570\u3002\u8f83\u9ad8\u7684\u503c\u5c06\u5bfc\u81f4\u8f83\u9ad8\u7684\u5185\u5b58\u4f7f\u7528\u7387\u3002\u5e76\u884cINSERT SELECT\u4ec5\u5728SELECT\u90e8\u5206\u200b\u200b\u5e76\u884c\u6267\u884c\u65f6\u624d\u6709\u6548\u3002 59.\u00a0stream_flush_interval_ms\uff1a\u5728\u8d85\u65f6\u6216\u7ebf\u7a0b\u751f\u6210max_insert_block_size\u884c\u7684\u60c5\u51b5\u4e0b\uff0c\u9002\u7528\u4e8e\u5177\u6709\u6d41\u5f0f\u4f20\u8f93\u7684\u8868\uff0c\u9ed8\u8ba47500\u3002\u503c\u8d8a\u5c0f\uff0c\u5c06\u6570\u636e\u5237\u65b0\u5230\u8868\u4e2d\u7684\u9891\u7387\u8d8a\u9ad8\u3002\u5c06\u8be5\u503c\u8bbe\u7f6e\u5f97\u592a\u4f4e\u4f1a\u5bfc\u81f4\u6027\u80fd\u4e0b\u964d\u3002 61.\u00a0prefer_localhost_replica\uff1a\u542f\u7528\u6216\u5219\u7981\u7528\u5904\u7406\u5206\u5e03\u5f0f\u67e5\u8be2\u65f6\u4f7f\u7528localhost\u526f\u672c\u3002\u9ed8\u8ba41\uff0c\u53ef\u9009\u503c0\u30011\uff1a<\/p>\n \u6ce8\u610f\uff1a\u5982\u679c\u4f7f\u7528max_parallel_replicas\uff0c\u8bf7\u7981\u7528\u6b64\u8bbe\u7f6e\u3002 91.\u00a0allow_introspection_functions\uff1a\u542f\u7528\u7981\u7528\u5185\u7701\u529f\u80fd\u4ee5\u8fdb\u884c\u67e5\u8be2\u6982\u8981\u5206\u6790\u3002\u9ed8\u8ba4\u503c\uff1a0\uff0c\u53ef\u90090(\u7981\u7528)\u30011(\u542f\u7528) 95.\u00a0output_format_avro_sync_interval\uff1a\u8bbe\u7f6e\u8f93\u51faAvro\u6587\u4ef6\u7684\u540c\u6b65\u6807\u8bb0\u4e4b\u95f4\u7684\u6700\u5c0f\u6570\u636e\u5927\u5c0f\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\u3002\u9ed8\u8ba432K\uff0c\u53ef\u9009\u503c\uff1a32\uff0832\u5b57\u8282\uff09~ 1073741824\uff081 GiB\uff09 \u80cc\u666f \u6700\u8fd1\u82b1\u4e86\u4e9b\u65f6\u95f4\u770b\u4e86\u4e0bClickHouse\u6587\u6863\uff0c\u53d1\u73b0\u5b83\u5728OLAP\u65b9\u9762\u8868\u73b0\u5f88\u4f18\u5f02\uff0c\u800c\u4e14\u76f8\u5bf9\u4e5f\u6bd4\u8f83\u8f7b\u91cf\u548c\u7b80\u5355\uff0c …<\/p>\nServer settings\uff1a\u5728config.xml\u91cc\u8bbe\u7f6e<\/h3>\n
<builtin_dictionaries_reload_interval>3600<\/builtin_dictionaries_reload_interval><\/pre>\n<\/div>\n
<compression incl=\\\"clickhouse_compression\\\"> --\u6307\u5b9aincl\n <case>\n <min_part_size>10000000000<\/min_part_size> --\u6570\u636e\u90e8\u5206\u7684\u6700\u5c0f\u5927\u5c0f\n <min_part_size_ratio>0.01<\/min_part_size_ratio> --\u6570\u636e\u90e8\u5206\u5927\u5c0f\u4e0e\u8868\u5927\u5c0f\u7684\u6bd4\u7387\n <method>zstd<\/method> --\u538b\u7f29\u7b97\u6cd5\uff0czstd\u548clz4\n <\/case>\n<\/compression><\/pre>\n
\n3. default_database\uff1a\u9ed8\u8ba4\u6570\u636e\u5e93\u3002<\/p>\n<default_database>default<\/default_database><\/pre>\n<\/div>\n
<default_profile>default<\/default_profile><\/pre>\n<\/div>\n
<dictionaries_config>*_dictionary.xml<\/dictionaries_config><\/pre>\n<\/div>\n
\ntrue\uff1a\u5728\u9996\u6b21\u4f7f\u7528\u65f6\u521b\u5efa\u6bcf\u4e2a\u5b57\u5178\u3002 \u5982\u679c\u5b57\u5178\u521b\u5efa\u5931\u8d25\uff0c\u5219\u6b63\u5728\u4f7f\u7528\u5b57\u5178\u7684\u51fd\u6570\u5c06\u5f15\u53d1\u5f02\u5e38\u3002
\nfalse\uff1a\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u5c06\u521b\u5efa\u6240\u6709\u5b57\u5178\uff0c\u5982\u679c\u6709\u9519\u8bef\uff0c\u5219\u670d\u52a1\u5668\u5c06\u5173\u95ed\u3002<\/p>\n<dictionaries_lazy_load>true<\/dictionaries_lazy_load><\/pre>\n<\/div>\n
<format_schema_path> format_schemas \/ <\/ format_schema_path><\/pre>\n<\/div>\n
<graphite>\n <host>localhost<\/host> -- Graphite\u670d\u52a1\u5668\n <port>42000<\/port> -- Graphite\u670d\u52a1\u5668\u4e0a\u7684\u7aef\u53e3\n <timeout>0.1<\/timeout> -- \u53d1\u9001\u8d85\u65f6\u65f6\u95f4\uff0c\u4ee5\u79d2\u4e3a\u5355\u4f4d\n <interval>60<\/interval> -- \u53d1\u9001\u95f4\u9694\uff0c\u4ee5\u79d2\u4e3a\u5355\u4f4d\n <root_path>one_min<\/root_path> -- \u5bc6\u94a5\u7684\u524d\u7f00\n <metrics>true<\/metrics> -- \u4ecesystem.metrics\u8868\u53d1\u9001\u6570\u636e\n <events>true<\/events> -- \u4ecesystem.events\u8868\u53d1\u9001\u5728\u8be5\u65f6\u95f4\u6bb5\u5185\u7d2f\u79ef\u7684\u589e\u91cf\u6570\u636e\n <events_cumulative>false<\/events_cumulative> -- \u4ecesystem.events\u8868\u53d1\u9001\u7d2f\u79ef\u6570\u636e\n <asynchronous_metrics>true<\/asynchronous_metrics> -- \u4ecesystem.asynchronous_metrics\u8868\u53d1\u9001\u6570\u636e\n<\/graphite><\/pre>\n
\n9.\u00a0graphite_rollup\uff1a\u6570\u636e\u6c47\u603b\u8bbe\u7f6e<\/p>\n <default>\n <function>max<\/function>\n <retention>\n <age>0<\/age>\n <precision>60<\/precision>\n <\/retention>\n <retention>\n <age>3600<\/age>\n <precision>300<\/precision>\n <\/retention>\n <retention>\n <age>86400<\/age>\n <precision>3600<\/precision>\n <\/retention>\n <\/default>\n<\/graphite_rollup_example><\/pre>\n<\/div>\n
<http_port>8123<\/http_port><\/pre>\n<\/div>\n
<http_server_default_response>\n <![CDATA[<html ng-app=\\\"SMI2\\\"><head><base href=\\\"http:\/\/ui.tabix.io\/\\\"><\/head><body><div ui-view=\\\"\\\" class=\\\"content-ui\\\"><\/div><script src=\\\"http:\/\/loader.tabix.io\/master.js\\\"><\/script><\/body><\/html>]]>\n<\/http_server_default_response><\/pre>\n<\/div>\n
<include_from>\/etc\/metrica.xml<\/include_from><\/pre>\n<\/div>\n
<interserver_http_port>9009<\/interserver_http_port><\/pre>\n<\/div>\n
<interserver_http_host>example.yandex.ru<\/interserver_http_host><\/pre>\n<\/div>\n
<interserver_http_credentials>\n <user>admin<\/user>\n <password>222<\/password>\n<\/interserver_http_credentials><\/pre>\n<\/div>\n
<keep_alive_timeout>3<\/keep_alive_timeout><\/pre>\n<\/div>\n
<listen_host> :: 1 <\/ listen_host>\n<listen_host> 127.0.0.1 <\/ listen_host><\/pre>\n<\/div>\n
![\\\"\u590d\u5236\u4ee3\u7801\\\"](\\\"https:\/\/common.cnblogs.com\/images\/copycode.gif\\\")
<\/a><\/div>\n<logger>\n <level>trace<\/level> --\u65e5\u5fd7\u8bb0\u5f55\u7ea7\u522b\u3002\u53ef\u63a5\u53d7\u7684\u503c\uff1a trace, debug, information, warning, error\n <log>\/var\/log\/clickhouse-server\/clickhouse-server.log<\/log> --\u65e5\u5fd7\u6587\u4ef6\uff0c\u6839\u636e\u7ea7\u522b\u5305\u542b\u6240\u6709\u6761\u76ee\n <errorlog>\/var\/log\/clickhouse-server\/clickhouse-server.err.log<\/errorlog> -- \u9519\u8bef\u65e5\u5fd7\u6587\u4ef6\n <size>1000M<\/size> -- \u6587\u4ef6\u7684\u5927\u5c0f\u3002\u9002\u7528\u4e8eloganderrorlog\uff0c\u6587\u4ef6\u8fbe\u5230\u5927\u5c0f\u540e\uff0cClickHouse\u5c06\u5bf9\u5176\u8fdb\u884c\u5b58\u6863\u5e76\u91cd\u547d\u540d\uff0c\u5e76\u5728\u5176\u4f4d\u7f6e\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u65e5\u5fd7\u6587\u4ef6\n <count>10<\/count> -- ClickHouse\u5b58\u50a8\u7684\u5df2\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u7684\u6570\u91cf\n<\/logger><\/pre>\n
<logger>\n <use_syslog>1<\/use_syslog> -- \u5199\u5165\u7cfb\u7edf\u65e5\u5fd7\n <syslog>\n <address>syslog.remote:10514<\/address> -- syslogd\u7684\u4e3b\u673a[\uff1aport]\u3002\u5982\u679c\u7701\u7565\uff0c\u5219\u4f7f\u7528\u672c\u5730\u5b88\u62a4\u7a0b\u5e8f\n <hostname>myhost.local<\/hostname> -- \u53ef\u9009\uff0c\u4ece\u4e2d\u53d1\u9001\u65e5\u5fd7\u7684\u4e3b\u673a\u7684\u540d\u79f0\u3002\n <facility>LOG_LOCAL6<\/facility> -- syslog\u5173\u952e\u5b57\uff0c\u5176\u5927\u5199\u5b57\u6bcd\u5e26\u6709\u201c LOG_\u201d\u524d\u7f00\uff1a\uff08LOG_USER\uff0cLOG_DAEMON\uff0cLOG_LOCAL3\uff0c\u4f9d\u6b64\u7c7b\u63a8\uff09\n <format>syslog<\/format> -- \u683c\u5f0f\u3002\u53ef\u80fd\u7684\u503c\uff1absd\u548csyslog\n <\/syslog>\n<\/logger><\/pre>\n
<macros incl=\\\"macros\\\" optional=\\\"true\\\" \/><\/pre>\n<\/div>\n
<mark_cache_size>5368709120<\/mark_cache_size><\/pre>\n<\/div>\n
<max_concurrent_queries>100<\/max_concurrent_queries><\/pre>\n<\/div>\n
<max_connections>4096<\/max_connections><\/pre>\n<\/div>\n
<max_open_files> 262144 <\/ max_open_files><\/pre>\n<\/div>\n
<max_table_size_to_drop>0<\/max_table_size_to_drop><\/pre>\n<\/div>\n
<merge_tree>\n<max_suspicious_broken_parts>5<\/max_suspicious_broken_parts>\n<\/merge_tree><\/pre>\n<\/div>\n
<openSSL>\n <server>\n <!-- openssl req -subj \\\"\/CN=localhost\\\" -new -newkey rsa:2048 -days 365 -nodes -x509 -keyout \/etc\/clickhouse-server\/server.key -out \/etc\/clickhouse-server\/server.crt -->\n <certificateFile>\/etc\/clickhouse-server\/server.crt<\/certificateFile> --PEM\u683c\u5f0f\u7684\u5ba2\u6237\u7aef\/\u670d\u52a1\u5668\u8bc1\u4e66\u6587\u4ef6\u7684\u8def\u5f84\u3002\u5982\u679cprivateKeyFile\u5305\u542b\u8bc1\u4e66\uff0c\u5219\u53ef\u4ee5\u5ffd\u7565\u5b83\u3002\n <privateKeyFile>\/etc\/clickhouse-server\/server.key<\/privateKeyFile> --\u5177\u6709PEM\u8bc1\u4e66\u7684\u79d8\u5bc6\u5bc6\u94a5\u7684\u6587\u4ef6\u7684\u8def\u5f84\u3002\u8be5\u6587\u4ef6\u53ef\u80fd\u540c\u65f6\u5305\u542b\u5bc6\u94a5\u548c\u8bc1\u4e66\u3002\n <!-- openssl dhparam -out \/etc\/clickhouse-server\/dhparam.pem 4096 -->\n <dhParamsFile>\/etc\/clickhouse-server\/dhparam.pem<\/dhParamsFile>\n <verificationMode>none<\/verificationMode> --\u68c0\u67e5\u8282\u70b9\u8bc1\u4e66\u7684\u65b9\u6cd5\u3002\u8be6\u7ec6\u4fe1\u606f\u5728Context\u7c7b\u7684\u63cf\u8ff0\u4e2d\u3002\u53ef\u80fd\u7684\u503c\uff1anone, relaxed, strict, once.\n <loadDefaultCAFile>true<\/loadDefaultCAFile> --\u6307\u793a\u5c06\u4f7f\u7528OpenSSL\u7684\u5185\u7f6eCA\u8bc1\u4e66\u3002\u53ef\u63a5\u53d7\u7684\u503c\uff1atrue\uff0cfalse\n <cacheSessions>true<\/cacheSessions> --\u542f\u7528\u6216\u7981\u7528\u7f13\u5b58\u4f1a\u8bdd\u3002\u5fc5\u987b\u4e0esessionIdContext\u7ed3\u5408\u4f7f\u7528\u3002\u53ef\u63a5\u53d7\u7684\u503c\uff1atrue\uff0cfalse\u3002\n <disableProtocols>sslv2,sslv3<\/disableProtocols> --\u4e0d\u5141\u8bb8\u4f7f\u7528\u7684\u534f\u8bae\u3002\n <preferServerCiphers>true<\/preferServerCiphers> ----\u9996\u9009\u670d\u52a1\u5668\u5bc6\u7801\n <\/server>\n <client>\n <loadDefaultCAFile>true<\/loadDefaultCAFile> --\u6307\u793a\u5c06\u4f7f\u7528OpenSSL\u7684\u5185\u7f6eCA\u8bc1\u4e66\u3002\u53ef\u63a5\u53d7\u7684\u503c\uff1atrue\uff0cfalse\n <cacheSessions>true<\/cacheSessions> -- --\u542f\u7528\u6216\u7981\u7528\u7f13\u5b58\u4f1a\u8bdd\u3002\u5fc5\u987b\u4e0esessionIdContext\u7ed3\u5408\u4f7f\u7528\u3002\u53ef\u63a5\u53d7\u7684\u503c\uff1atrue\uff0cfalse\u3002\n <disableProtocols>sslv2,sslv3<\/disableProtocols> --\u4e0d\u5141\u8bb8\u4f7f\u7528\u7684\u534f\u8bae\u3002\n <preferServerCiphers>true<\/preferServerCiphers> --\u9996\u9009\u670d\u52a1\u5668\u5bc6\u7801\n <!-- Use for self-signed: <verificationMode>none<\/verificationMode> -->\n <invalidCertificateHandler> --\u7528\u4e8e\u9a8c\u8bc1\u65e0\u6548\u8bc1\u4e66\u7684\u7c7b\n <!-- Use for self-signed: <name>AcceptCertificateHandler<\/name> -->\n <name>RejectCertificateHandler<\/name>\n <\/invalidCertificateHandler>\n <\/client>\n<\/openSSL><\/pre>\n
<part_log>\n <database>system<\/database> --\u5e93\u540d\n <table>part_log<\/table> --\u8868\u540d\n <partition_by>toMonday(event_date)<\/partition_by> --\u81ea\u5b9a\u4e49\u5206\u533a\u952e\n <flush_interval_milliseconds>7500<\/flush_interval_milliseconds> --\u5c06\u6570\u636e\u4ece\u5185\u5b58\u4e2d\u7684\u7f13\u51b2\u533a\u5237\u65b0\u5230\u8868\u7684\u65f6\u95f4\u95f4\u9694\uff0c\u5355\u4f4d\u6beb\u79d2\u3002\n<\/part_log><\/pre>\n<\/div>\n
<path>\/var\/lib\/clickhouse\/<\/path><\/pre>\n<\/div>\n
<query_log>\n <database>system<\/database> --\u5e93\u540d\n <table>query_log<\/table> --\u8868\u540d\n <partition_by>toMonday(event_date)<\/partition_by> --\u81ea\u5b9a\u4e49\u5206\u533a\u952e\n <flush_interval_milliseconds>7500<\/flush_interval_milliseconds> --\u5c06\u6570\u636e\u4ece\u5185\u5b58\u4e2d\u7684\u7f13\u51b2\u533a\u5237\u65b0\u5230\u8868\u7684\u65f6\u95f4\u95f4\u9694\n<\/query_log><\/pre>\n<\/div>\n
\n30.\u00a0query_thread_log\uff1a\u4f7f\u7528log_query_threads = 1\u8bbe\u7f6e\uff0c\u8bb0\u5f55\u63a5\u6536\u5230\u67e5\u8be2\u7684\u7ebf\u7a0b\u3002\u67e5\u8be2\u8bb0\u5f55\u5728system.query_thread_log\u8868\u4e2d\uff0c\u800c\u4e0d\u8bb0\u5f55\u5728\u5355\u72ec\u7684\u6587\u4ef6\u4e2d\u3002\u60a8\u53ef\u4ee5\u5728table\u53c2\u6570\u4e2d\u66f4\u6539\u8868\u7684\u540d\u79f0\u3002<\/p>\n<query_thread_log>\n <database>system<\/database> --\u5e93\u540d\n <table>query_thread_log<\/table> --\u8868\u540d\n <partition_by>toMonday(event_date)<\/partition_by> --\u81ea\u5b9a\u4e49\u5206\u533a\u952e\n <flush_interval_milliseconds>7500<\/flush_interval_milliseconds> --\u5c06\u6570\u636e\u4ece\u5185\u5b58\u4e2d\u7684\u7f13\u51b2\u533a\u5237\u65b0\u5230\u8868\u7684\u65f6\u95f4\u95f4\u9694\n<\/query_thread_log><\/pre>\n<\/div>\n
\n31.\u00a0trace_log\uff1atrace_log\u7cfb\u7edf\u8868\u64cd\u4f5c\u7684\u8bbe\u7f6e\u3002<\/p>\n<trace_log>\n <database>system<\/database> --\u5e93\u540d\n <table>trace_log<\/table> --\u8868\u540d\n <partition_by>toYYYYMM(event_date)<\/partition_by> ----\u81ea\u5b9a\u4e49\u5206\u533a\u952e\n <flush_interval_milliseconds>7500<\/flush_interval_milliseconds> ----\u5c06\u6570\u636e\u4ece\u5185\u5b58\u4e2d\u7684\u7f13\u51b2\u533a\u5237\u65b0\u5230\u8868\u7684\u65f6\u95f4\u95f4\u9694\n<\/trace_log><\/pre>\n<\/div>\n
<query_masking_rules>\n <rule>\n <name>hide SSN<\/name> --\u89c4\u5219\u540d\u79f0\n <regexp>(^|\\\\D)\\\\d{3}-\\\\d{2}-\\\\d{4}($|\\\\D)<\/regexp> --\u6b63\u5219\u8868\u8fbe\u5f0f\n <replace>000-00-0000<\/replace> --\u66ff\u6362\uff0c\u654f\u611f\u6570\u636e\u7684\u66ff\u6362\u5b57\u7b26\u4e32\uff08\u9ed8\u8ba4\u4e3a\u53ef\u9009-\u516d\u4e2a\u661f\u53f7\uff09\n <\/rule>\n<\/query_masking_rules><\/pre>\n
\n33.\u00a0remote_servers\uff1a\u8fdc\u7a0b\u670d\u52a1\u5668\uff0c\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u548c\u96c6\u7fa4\u8868\u529f\u80fd\u4f7f\u7528\u7684\u96c6\u7fa4\u7684\u914d\u7f6e\u3002<\/p>\n<remote_servers incl=\\\"clickhouse_remote_servers\\\" \/><\/pre>\n<\/div>\n
\n\u5f53DateTime\u5b57\u6bb5\u8f93\u51fa\u4e3a\u6587\u672c\u683c\u5f0f\uff08\u6253\u5370\u5728\u5c4f\u5e55\u6216\u6587\u4ef6\u4e2d\uff09\uff0c\u4ee5\u53ca\u4ece\u5b57\u7b26\u4e32\u83b7\u53d6DateTime\u65f6\uff0c\u65f6\u533a\u5bf9\u4e8e\u5728String\u548cDateTime\u683c\u5f0f\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u662f\u5fc5\u9700\u7684\u3002 \u6b64\u5916\uff0c\u5982\u679c\u5728\u8f93\u5165\u53c2\u6570\u4e2d\u672a\u63a5\u6536\u5230\u65f6\u533a\uff0c\u5219\u5728\u4f7f\u7528\u65f6\u95f4\u548c\u65e5\u671f\u7684\u51fd\u6570\u4e2d\u4f1a\u4f7f\u7528\u65f6\u533a\u3002<\/p>\n<timezone>Europe\/Moscow<\/timezone><\/pre>\n<\/div>\n
<tcp_port>9000<\/tcp_port><\/pre>\n<\/div>\n
<tcp_port_secure> 9440 <\/ tcp_port_secure><\/pre>\n<\/div>\n
<mysql_port>9004<\/mysql_port><\/pre>\n<\/div>\n
<tmp_path>\/var\/lib\/clickhouse\/tmp\/<\/tmp_path><\/pre>\n<\/div>\n
\n40.\u00a0uncompressed_cache_size\uff1a\u8868\u5f15\u64ce\u4eceMergeTree\u4f7f\u7528\u7684\u672a\u538b\u7f29\u6570\u636e\u7684\u7f13\u5b58\u5927\u5c0f\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff0c8G\uff09\u3002\u670d\u52a1\u5668\u6709\u4e00\u4e2a\u5171\u4eab\u7f13\u5b58\uff0c\u5185\u5b58\u662f\u6309\u9700\u5206\u914d\u7684\u3002\u5982\u679c\u542f\u7528\uff0c\u5219\u4f7f\u7528\u9ad8\u901f\u7f13\u5b58\u3002\u5728\u4e2a\u522b\u60c5\u51b5\u4e0b\uff0c\u672a\u538b\u7f29\u7684\u7f13\u5b58\u5bf9\u4e8e\u975e\u5e38\u77ed\u7684\u67e5\u8be2\u662f\u6709\u5229\u7684\u3002<\/p>\n<uncompressed_cache_size>8589934592<\/uncompressed_cache_size><\/pre>\n<\/div>\n
<user_files_path>\/var\/lib\/clickhouse\/user_files\/<\/user_files_path><\/pre>\n<\/div>\n
<users_config>users.xml<\/users_config><\/pre>\n<\/div>\n
<zookeeper>\n <node>\n <host>example1<\/host>\n <port>2181<\/port>\n <\/node>\n <node>\n <host>example2<\/host>\n <port>2181<\/port>\n <\/node>\n <session_timeout_ms>30000<\/session_timeout_ms> --\u5ba2\u6237\u7aef\u4f1a\u8bdd\u7684\u6700\u5927\u8d85\u65f6\uff08\u4ee5\u6beb\u79d2\u4e3a\u5355\u4f4d\uff09\n <operation_timeout_ms>10000<\/operation_timeout_ms>\n <!-- Optional. Chroot suffix. Should exist. -->\n <root>\/path\/to\/zookeeper\/node<\/root> -- \u7528\u4f5cClickHouse\u670d\u52a1\u5668\u4f7f\u7528\u7684znode\u7684\u6839\u7684znode\n <!-- Optional. Zookeeper digest ACL string. -->\n <identity>user:password<\/identity> --\u7528\u6237\u548c\u5bc6\u7801\uff0cZooKeeper\u53ef\u80fd\u9700\u8981\u8fd9\u4e9b\u7528\u6237\u548c\u5bc6\u7801\u624d\u80fd\u8bbf\u95ee\u8bf7\u6c42\u7684znode\n<\/zookeeper><\/pre>\n
\n\u4ec5\u9002\u7528\u4e8eMergeTree\u7cfb\u5217\u3002\u53ef\u4ee5\u6307\u5b9a\uff1a<\/p>\n\n
\n45.\u00a0disable_internal_dns_cache\uff1a\u7981\u7528\u5185\u90e8DNS\u7f13\u5b58\uff0c\u9ed8\u8ba40\u3002
\n46.\u00a0dns_cache_update_period\uff1a\u5185\u90e8DNS\u7f13\u5b58\u4e2d\u5b58\u50a8\u7684IP\u5730\u5740\u7684\u66f4\u65b0\u65f6\u95f4\uff08\u4ee5\u79d2\u4e3a\u5355\u4f4d\uff09\uff0c\u66f4\u65b0\u662f\u5728\u5355\u72ec\u7684\u7cfb\u7edf\u7ebf\u7a0b\u4e2d\u5f02\u6b65\u6267\u884c\u7684\uff0c\u9ed8\u8ba415\u79d2\u3002<\/p>\nSettings\uff1a\u4f7f\u7528set\u8bbe\u7f6e\uff08system.settings\uff09<\/h3>\n
\n\u9650\u5236\u6761\u4ef6\uff1a<\/p>\n\n
\n
\n3.\u00a0fallback_to_stale_replicas_for_distributed_queries\uff1a\u5982\u679c\u6ca1\u6709\u65b0\u7684\u6570\u636e\uff0c\u5219\u5f3a\u5236\u67e5\u8be2\u5230\u8fc7\u671f\u7684\u526f\u672c\u4e2d\u67e5\u8be2\uff0c \u8bf7\u53c2\u89c1\u590d\u5236<\/a>\u3002\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\u3002
\n4.\u00a0force_index_by_date\uff1a\u5982\u679c\u65e0\u6cd5\u6309\u65e5\u671f\u4f7f\u7528\u7d22\u5f15\uff0c\u5219\u7981\u7528\u67e5\u8be2\u6267\u884c\uff0c\u4e0eMergeTree<\/a>\u7cfb\u5217\u4e2d\u7684\u8868\u4e00\u8d77\u4f7f\u7528\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002
\n\u5982\u679cforce_index_by_date = 1\uff0c\u68c0\u67e5\u67e5\u8be2\u662f\u5426\u5177\u6709\u53ef\u7528\u4e8e\u9650\u5236\u6570\u636e\u8303\u56f4\u7684\u65e5\u671f\u952e\u6761\u4ef6\u3002 \u5982\u679c\u6ca1\u6709\u5408\u9002\u7684\u6761\u4ef6\uff0c\u5b83\u5c06\u5f15\u53d1\u5f02\u5e38\u3002 \u4f46\u4e0d\u4f1a\u68c0\u67e5\u6761\u4ef6\u662f\u5426\u51cf\u5c11\u4e86\u8981\u8bfb\u53d6\u7684\u6570\u636e\u91cf\u3002 \u5982\u6761\u4ef6Date\uff01=\\’2000-01-01\\’\u662f\u53ef\u4ee5\u63a5\u53d7\u7684\uff0c\u5373\u4f7f\u5b83\u4e0e\u8868\u4e2d\u7684\u6240\u6709\u6570\u636e\u5339\u914d\uff08\u5373\uff0c\u8fd0\u884c\u67e5\u8be2\u9700\u8981\u5b8c\u5168\u626b\u63cf\uff09\u3002
\n5.\u00a0force_primary_key\uff1a\u5982\u679c\u65e0\u6cd5\u901a\u8fc7\u4e3b\u952e\u5efa\u7acb\u7d22\u5f15\uff0c\u5219\u7981\u7528\u67e5\u8be2\u6267\u884c\uff0c\u4e0eMergeTree<\/a>\u7cfb\u5217\u4e2d\u7684\u8868\u4e00\u8d77\u4f7f\u7528\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002
\n\u5982\u679cforce_primary_key = 1\uff0c\u68c0\u67e5\u67e5\u8be2\u662f\u5426\u5177\u6709\u53ef\u7528\u4e8e\u9650\u5236\u6570\u636e\u8303\u56f4\u7684\u4e3b\u952e\u6761\u4ef6\u3002 \u5982\u679c\u6ca1\u6709\u5408\u9002\u7684\u6761\u4ef6\uff0c\u5b83\u5c06\u5f15\u53d1\u5f02\u5e38\u3002 \u4f46\u4e0d\u4f1a\u68c0\u67e5\u6761\u4ef6\u662f\u5426\u51cf\u5c11\u4e86\u8981\u8bfb\u53d6\u7684\u6570\u636e\u91cf\u3002
\n6.\u00a0format_schema\uff1a\u4f7f\u7528\u5b9a\u4e49\u7684\u683c\u5f0f\u3002
\n7.\u00a0fsync_metadata\uff1a\u5199\u5165.sql\u6587\u4ef6\u65f6\u542f\u7528\u6216\u7981\u7528fsync\u3002 \u9ed8\u8ba41\uff0c\u542f\u7528\u3002\u53ef\u90090\u30011\u3002\u5982\u679c\u670d\u52a1\u5668\u5177\u6709\u6570\u767e\u4e07\u4e2a\u4e0d\u65ad\u521b\u5efa\u548c\u9500\u6bc1\u7684\u5c0f\u8868\uff0c\u5219\u7981\u7528\u5b83\u662f\u6709\u610f\u4e49\u7684\u3002
\n8.\u00a0enable_http_compression\uff1aHTTP\u8bf7\u6c42\u7684\u54cd\u5e94\u4e2d\u542f\u7528\u6216\u7981\u7528\u6570\u636e\u538b\u7f29\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002
\n9.\u00a0http_zlib_compression_level\uff1a\u8bbe\u7f6eHTTP\u8bf7\u6c42\u7684\u54cd\u5e94\u4e2d\u7684\u6570\u636e\u538b\u7f29\u7ea7\u522b\u3002\u9ed8\u8ba43\uff0c\u53ef\u90091~9\u3002
\n10.\u00a0http_native_compression_disable_checksumming_on_decompress\uff1a\u4ece\u5ba2\u6237\u7aef\u89e3\u538b\u7f29HTTP POST\u6570\u636e\u65f6\u542f\u7528\u6216\u7981\u7528\u6821\u9a8c\u548c\u9a8c\u8bc1\u3002 \u4ec5\u7528\u4e8eClickHouse\u672c\u673a\u538b\u7f29\u683c\u5f0f\uff08\u4e0d\u9002\u7528\u4e8egzip\u6216deflate\uff09\uff0c\u9ed8\u8ba40\uff0c\u7981\u7528\uff0c\u53ef\u90090\u30011\u3002
\n11.\u00a0send_progress_in_http_headers\uff1a\u5728clickhouse-server\u54cd\u5e94\u4e2d\u542f\u7528\u6216\u7981\u7528X-ClickHouse-Progress HTTP\u54cd\u5e94\u6807\u5934\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002\u66f4\u591a\u4fe1\u606f\u89c1\uff1aHTTP \u5ba2\u6237\u7aef<\/a>
\n12.\u00a0max_http_get_redirects\uff1a\u9650\u5236URL\u5f15\u64ce\u8868\u7684\u6700\u5927HTTP GET\u91cd\u5b9a\u5411\u8dc3\u70b9\u6570\u3002 \u8be5\u8bbe\u7f6e\u9002\u7528\u4e8e\u4e24\u79cd\u7c7b\u578b\u7684\u8868\uff1a\u7531CREATE TABLE\u67e5\u8be2\u548curl\u8868\u51fd\u6570\u521b\u5efa\u7684\u8868\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u3001\u975e0\u6b63\u6574\u6570\u3002
\n13.\u00a0input_format_allow_errors_num\uff1a\u8bbe\u7f6e\u4ece\u6587\u672c\u683c\u5f0f\uff08CSV\uff0cTSV\u7b49\uff09\u8bfb\u53d6\u65f6\u53ef\u63a5\u53d7\u7684\u6700\u5927\u9519\u8bef\u6570\u3002\u9ed8\u8ba40\u3002\u5982\u679c\u5728\u8bfb\u53d6\u884c\u65f6\u53d1\u751f\u9519\u8bef\uff0c\u4f46\u9519\u8bef\u8ba1\u6570\u5668\u4ecd\u5c0f\u4e8einput_format_allow_errors_num\uff0c\u5219ClickHouse\u4f1a\u5ffd\u7565\u8be5\u884c\u5e76\u7ee7\u7eed\u8fdb\u884c\u4e0b\u4e00\u884c\u3002\u5982\u679c\u540c\u65f6\u8d85\u8fc7\u4e86input_format_allow_errors_num\u548cinput_format_allow_errors_ratio\uff0c\u5219ClickHouse\u4f1a\u5f15\u53d1\u5f02\u5e38\u3002
\n14.\u00a0input_format_allow_errors_ratio\uff1a\u8bbe\u7f6e\u4ece\u6587\u672c\u683c\u5f0f\uff08CSV\uff0cTSV\u7b49\uff09\u8bfb\u53d6\u65f6\u5141\u8bb8\u7684\u6700\u5927\u9519\u8bef\u767e\u5206\u6bd4\u3002\u9519\u8bef\u767e\u5206\u6bd4\u8bbe\u7f6e\u4e3a0\u52301\u4e4b\u95f4\u7684\u6d6e\u70b9\u6570\u3002\u9ed8\u8ba40\u3002\u5982\u679c\u5728\u8bfb\u53d6\u884c\u65f6\u53d1\u751f\u9519\u8bef\uff0c\u4f46\u9519\u8bef\u8ba1\u6570\u5668\u4ecd\u5c0f\u4e8einput_format_allow_errors_ratio\uff0c\u5219ClickHouse\u4f1a\u5ffd\u7565\u8be5\u884c\u5e76\u7ee7\u7eed\u8fdb\u884c\u4e0b\u4e00\u884c\u3002\u5982\u679c\u540c\u65f6\u8d85\u8fc7\u4e86input_format_allow_errors_num\u548cinput_format_allow_errors_ratio\uff0c\u5219ClickHouse\u4f1a\u5f15\u53d1\u5f02\u5e38\u3002
\n15.\u00a0input_format_values_interpret_expressions\uff1a\u5982\u679c\u5feb\u901f\u6d41\u89e3\u6790\u5668\u65e0\u6cd5\u89e3\u6790\u6570\u636e\uff0c\u5219\u542f\u7528\u6216\u7981\u7528\u5b8c\u6574\u7684SQL\u89e3\u6790\u5668\u3002\u6b64\u8bbe\u7f6e\u4ec5\u7528\u4e8e\u6570\u636e\u63d2\u5165\u65f6\u7684\u201c\u503c\u201d\u683c\u5f0f\u3002\u6709\u5173\u8bed\u6cd5\u5206\u6790\u7684\u66f4\u591a\u4fe1\u606f\uff0c\u8bf7\u53c2\u89c1\u201c\u8bed\u6cd5<\/a>\u201d\u90e8\u5206\u3002\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\uff1a<\/p>\n\n
\n\u5982\uff1a\u63d2\u5165\u5177\u6709\u4e0d\u540c\u8bbe\u7f6e\u7684DateTime\u7c7b\u578b\u503c\u3002<\/p>\nSET input_format_values_interpret_expressions = 0;\nINSERT INTO datetime_t VALUES (now())\nException on client:\nCode: 27. DB::Exception: Cannot parse input: expected ) before: now()): (at row 1)\nSET input_format_values_interpret_expressions = 1;\nINSERT INTO datetime_t VALUES (now())\nOk<\/pre>\n
INSERT INTO test VALUES (lower(\\'Hello\\')), (lower(\\'world\\')), (lower(\\'INSERT\\')), (upper(\\'Values\\')), ...\n1\uff1a\u5982\u679cinput_format_values_interpret_expressions = 1\u548cformat_values_deduce_templates_of_expressions = 0\u4f1a\u5206\u522b\u4e3a\u6bcf\u884c\u89e3\u91ca\u8868\u8fbe\u5f0f\uff08\u8fd9\u5bf9\u4e8e\u5927\u91cf\u7684\u884c\u6765\u8bf4\u975e\u5e38\u6162\uff09\n2\uff1a\u5982\u679cinput_format_values_interpret_expressions = 0\u548cformat_values_deduce_templates_of_expressions = 1\u4f1a\u4f7f\u7528\u6a21\u677flower\uff08String\uff09\u89e3\u6790\u7b2c\u4e00\uff0c\u7b2c\u4e8c\u548c\u7b2c\u4e09\u884c\u3002\n3\uff1a\u5982\u679cinput_format_values_interpret_expressions = 1\u548cformat_values_deduce_templates_of_expressions = 1 \u4e0e\u524d\u9762\u7684\u60c5\u51b5\u76f8\u540c\uff0c\u4f46\u662f\u5982\u679c\u65e0\u6cd5\u63a8\u65ad\u51fa\u6a21\u677f\uff0c\u5219\u8fd8\u5141\u8bb8\u56de\u9000\u4ee5\u5355\u72ec\u89e3\u91ca\u8868\u8fbe\u5f0f\u3002<\/pre>\n<\/div>\n
(..., abs(0), ...), -- UInt64 literal\n(..., abs(3.141592654), ...), -- Float64 literal\n(..., abs(-1), ...), -- Int64 literal<\/pre>\n<\/div>\n
\n18.\u00a0input_format_defaults_for_omitted_fields\uff1a\u6267\u884cINSERT\u67e5\u8be2\u65f6\uff0c\u5c06\u7701\u7565\u7684\u5217\u66ff\u6362\u4e3a\u5404\u4e2a\u5217\u7684\u9ed8\u8ba4\u503c\u3002 \u6b64\u9009\u9879\u4ec5\u9002\u7528\u4e8eJSONEachRow\uff0cCSV\u548cTabSeparated\u683c\u5f0f\u3002\u542f\u7528\u6b64\u9009\u9879\u540e\uff0c\u6269\u5c55\u8868\u5143\u6570\u636e\u5c06\u4ece\u670d\u52a1\u5668\u53d1\u9001\u5230\u5ba2\u6237\u7aef\u3002 \u6d88\u8017\u4e86\u670d\u52a1\u5668\u4e0a\u7684\u5176\u4ed6\u8ba1\u7b97\u8d44\u6e90\uff0c\u5e76\u53ef\u80fd\u964d\u4f4e\u6027\u80fd\u3002\u9ed8\u8ba41\uff0c\u53ef\u90090\u30011\u3002
\n19.\u00a0input_format_tsv_empty_as_default\uff1a\u5c06TSV\u4e2d\u7684\u7a7a\u767d\u5b57\u6bb5\u66ff\u6362\u4e3a\u9ed8\u8ba4\u503c\u3002\u5bf9\u4e8e\u590d\u6742\u7684\u9ed8\u8ba4\u8868\u8fbe\u5f0f\uff0c\u4e5f\u5fc5\u987b\u542f\u7528input_format_defaults_for_omitted_fields\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002
\n20.\u00a0input_format_null_as_default\uff1a\u5982\u679c\u8f93\u5165\u6570\u636e\u5305\u542bNULL\uff0c\u4f46\u5bf9\u5e94\u5217\u7684\u6570\u636e\u7c7b\u578b\u4e0d\u662fNullable\uff08T\uff09\uff0c\u5219\u542f\u7528\u6216\u7981\u7528\u9ed8\u8ba4\u503c\uff08\u5bf9\u4e8e\u6587\u672c\u8f93\u5165\u683c\u5f0f\uff09,\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011
\n21.\u00a0input_format_skip_unknown_fields\uff1a\u542f\u7528\u6216\u7981\u7528\u8df3\u8fc7\u591a\u4f59\u6570\u636e\u5217\u7684\u63d2\u5165\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002\u5199\u5165\u6570\u636e\u65f6\uff0c\u5982\u679c\u8f93\u5165\u6570\u636e\u5305\u542b\u76ee\u6807\u8868\u4e2d\u4e0d\u5b58\u5728\u7684\u5217\uff0c\u5219ClickHouse\u4f1a\u5f15\u53d1\u5f02\u5e38\u3002\u5982\u679c\u542f\u7528\u4e86\u8df3\u8fc7\uff0c\u5219ClickHouse\u4e0d\u4f1a\u63d2\u5165\u989d\u5916\u7684\u6570\u636e\uff0c\u4e5f\u4e0d\u4f1a\u5f15\u53d1\u5f02\u5e38\u3002\u652f\u6301\u683c\u5f0f\uff1aJSONEachRow,CSVWithNames,TabSeparatedWithNames,TSKV\u3002
\n22.\u00a0input_format_import_nested_json\uff1a\u542f\u7528\u6216\u7981\u7528\u5e26\u6709\u5d4c\u5957\u5bf9\u8c61\u7684JSON\u6570\u636e\u63d2\u5165\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002\u652f\u6301\u7684\u683c\u5f0f\u4e3aJSONEachRow\u3002
\n23.\u00a0input_format_with_names_use_header\uff1a\u542f\u7528\u6216\u7981\u7528\u5728\u63d2\u5165\u6570\u636e\u65f6\u68c0\u67e5\u5217\u987a\u5e8f\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002\u4e3a\u4e86\u63d0\u9ad8\u63d2\u5165\u6027\u80fd\uff0c\u5982\u679c\u786e\u5b9a\u8f93\u5165\u6570\u636e\u7684\u5217\u987a\u5e8f\u4e0e\u76ee\u6807\u8868\u4e2d\u7684\u987a\u5e8f\u76f8\u540c\uff0c\u5219\u5efa\u8bae\u7981\u7528\u6b64\u68c0\u67e5\u3002\u652f\u6301\u7684\u683c\u5f0fCSVWithNames\u3001TabSeparatedWithNames\u3002
\n24.\u00a0date_time_input_format\uff1a\u5141\u8bb8\u9009\u62e9\u4e00\u4e2a\u89e3\u6790\u5668\u7684\u6587\u672c\u8868\u793a\u65e5\u671f\u548c\u65f6\u95f4\uff0c\u8be5\u8bbe\u7f6e\u4e0d\u9002\u7528\u4e8e\u65e5\u671f\u548c\u65f6\u95f4\u529f\u80fd\u3002\u9ed8\u8ba4basic\uff0c\u53ef\u9009\uff1abasic\u3001best_effort\u3002<\/p>\n\n
\n25.\u00a0join_default_strictness\uff1a\u8bbe\u7f6eJOIN\u5b50\u53e5\u7684\u9ed8\u8ba4\u4e25\u683c\u6027\uff0c\u9ed8\u8ba4all\u3002\u53ef\u9009\u503c\uff1a<\/p>\n\n
\n
\n27.\u00a0join_use_nulls\uff1a\u8bbe\u7f6eJOIN\u884c\u4e3a\u7684\u7c7b\u578b\uff0c\u5408\u5e76\u8868\u65f6\u53ef\u80fd\u4f1a\u51fa\u73b0\u7a7a\u5355\u5143\u683c\uff0cClickHouse\u6839\u636e\u6b64\u8bbe\u7f6e\u4ee5\u4e0d\u540c\u7684\u65b9\u5f0f\u586b\u5145\u3002\u9ed8\u8ba40\uff0c\u53ef\u9009\uff1a<\/p>\n\n
\n29.\u00a0max_block_size\uff1a\u5728ClickHouse\u4e2d\uff0c\u6570\u636e\u7531\u5757\uff08\u5217\u90e8\u5206\u7684\u96c6\u5408\uff09\u5904\u7406\u3002 \u5904\u7406\u6bcf\u4e2a\u5757\u90fd\u6709\u5f00\u9500\u3002 \u5bf9\u4e8e\u8981\u4ece\u8868\u4e2d\u52a0\u8f7d\u7684\u5757\u5927\u5c0f\uff08\u4ee5\u884c\u6570\u4e3a\u5355\u4f4d\uff09\uff0c\u5efa\u8bae\u4f7f\u7528max_block_size\u8bbe\u7f6e\u3002 \u76ee\u7684\u662f\u907f\u514d\u5728\u591a\u4e2a\u7ebf\u7a0b\u4e2d\u63d0\u53d6\u5927\u91cf\u5217\u65f6\u907f\u514d\u5360\u7528\u8fc7\u591a\u5185\u5b58\uff0c\u5e76\u81f3\u5c11\u4fdd\u7559\u4e00\u4e9b\u7f13\u5b58\u5c40\u90e8\u6027\u3002\u9ed8\u8ba4\uff1a65,536\uff08\u884c\u6570\uff09\u3002\u5e76\u975e\u603b\u662f\u4ece\u8868\u4e2d\u52a0\u8f7dmax_block_size\u5927\u5c0f\u7684\u5757\u3002 \u5982\u679c\u5f88\u660e\u663e\u9700\u8981\u68c0\u7d22\u8f83\u5c11\u7684\u6570\u636e\uff0c\u5219\u5904\u7406\u8f83\u5c0f\u7684\u5757\u3002
\n30.\u00a0preferred_block_size_bytes\uff1a\u7528\u4e8e\u4e0emax_block_size\u76f8\u540c\u7684\u76ee\u7684\uff0c\u4f46\u662f\u5b83\u901a\u8fc7\u5c06\u5176\u8c03\u6574\u4e3a\u9002\u5408\u5757\u4e2d\u7684\u884c\u6570\u6765\u8bbe\u7f6e\u5efa\u8bae\u7684\u5757\u5927\u5c0f\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\uff0c\u4f46\u5757\u5927\u5c0f\u4e0d\u80fd\u8d85\u8fc7max_block_size\u884c\u3002\u9ed8\u8ba4\u503c\uff1a1,000,000\u3002 \u4ec5\u5728\u4eceMergeTree\u5f15\u64ce\u8bfb\u53d6\u65f6\u6709\u6548\u3002
\n31.\u00a0merge_tree_min_rows_for_concurrent_read\uff1a\u4eceMergeTree\u5f15\u64ce\u8868\u7684\u6587\u4ef6\u4e2d\u8bfb\u53d6\u7684\u884c\u6570\u8d85\u8fc7merge_tree_min_rows_for_concurrent_read\uff0c\u5219ClickHouse\u5c1d\u8bd5\u5728\u591a\u4e2a\u7ebf\u7a0b\u4e0a\u4ece\u8be5\u6587\u4ef6\u6267\u884c\u5e76\u53d1\u8bfb\u53d6\u3002\u9ed8\u8ba4163840\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n32.\u00a0merge_tree_min_bytes_for_concurrent_read\uff1a\u4eceMergeTree\u5f15\u64ce\u8868\u7684\u6587\u4ef6\u8bfb\u53d6\u7684\u5b57\u8282\u6570\u8d85\u8fc7\u4e86merge_tree_min_bytes_for_concurrent_read\uff0c\u5219ClickHouse\u4f1a\u5c1d\u8bd5\u5728\u591a\u4e2a\u7ebf\u7a0b\u4e2d\u540c\u65f6\u8bfb\u53d6\u8be5\u6587\u4ef6\u3002\u9ed8\u8ba4251658240\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n33.\u00a0merge_tree_min_rows_for_seek\uff1a\u5728\u4e00\u4e2a\u6587\u4ef6\u4e2d\u8bfb\u53d6\u7684\u4e24\u4e2a\u6570\u636e\u5757\u4e4b\u95f4\u7684\u8ddd\u79bb\u5c0f\u4e8emerge_tree_min_rows_for_seek\u884c\uff0c\u5219ClickHouse\u4e0d\u4f1a\u641c\u7d22\u6587\u4ef6\uff0c\u800c\u662f\u987a\u5e8f\u8bfb\u53d6\u6570\u636e\u3002\u9ed8\u8ba40\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n34.\u00a0merge_tree_min_bytes_for_seek\uff1a\u5728\u4e00\u4e2a\u6587\u4ef6\u4e2d\u8bfb\u53d6\u7684\u4e24\u4e2a\u6570\u636e\u5757\u4e4b\u95f4\u7684\u8ddd\u79bb\u5c0f\u4e8emerge_tree_min_bytes_for_seek\u5b57\u8282\uff0c\u5219ClickHouse\u987a\u5e8f\u8bfb\u53d6\u5305\u542b\u4e24\u4e2a\u5757\u7684\u6587\u4ef6\u7684\u8303\u56f4\uff0c\u4ece\u800c\u907f\u514d\u4e86\u989d\u5916\u7684\u67e5\u627e\u3002\u9ed8\u8ba40\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n35.\u00a0merge_tree_coarse_index_granularity\uff1a\u641c\u7d22\u6570\u636e\u65f6\uff0cClickHouse\u68c0\u67e5\u7d22\u5f15\u6587\u4ef6\u4e2d\u7684\u6570\u636e\u6807\u8bb0\u3002\u5982\u679cClickHouse\u53d1\u73b0\u6240\u9700\u952e\u5728\u67d0\u4e2a\u8303\u56f4\u5185\uff0c\u5219\u4f1a\u5c06\u8be5\u8303\u56f4\u5212\u5206\u4e3amerge_tree_coarse_index_granularity\u5b50\u8303\u56f4\uff0c\u7136\u540e\u5728\u8be5\u8303\u56f4\u5185\u9012\u5f52\u641c\u7d22\u6240\u9700\u952e\u3002\u9ed8\u8ba48\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u5076\u6570\u6574\u6570\u3002
\n36.\u00a0merge_tree_max_rows_to_use_cache\uff1a\u5728\u4e00\u4e2a\u67e5\u8be2\u4e2d\u8bfb\u53d6\u7684\u884c\u6570\u8d85\u8fc7merge_tree_max_rows_to_use_cache\u884c\uff0c\u5219\u5b83\u4e0d\u4f7f\u7528\u672a\u538b\u7f29\u5757\u7684\u7f13\u5b58\uff0c\u4f7f\u7528\u538b\u7f29\u5757\u7684\u9ad8\u901f\u7f13\u5b58\u5b58\u50a8\u4e3a\u67e5\u8be2\u63d0\u53d6\u7684\u6570\u636e\u3002 ClickHouse\u4f7f\u7528\u6b64\u7f13\u5b58\u6765\u52a0\u5feb\u5bf9\u91cd\u590d\u7684\u5c0f\u578b\u67e5\u8be2\u7684\u54cd\u5e94\u3002\u6b64\u8bbe\u7f6e\u53ef\u4fdd\u62a4\u9ad8\u901f\u7f13\u5b58\u514d\u53d7\u8bfb\u53d6\u5927\u91cf\u6570\u636e\u7684\u67e5\u8be2\u7684\u7834\u574f\u3002 uncompressed_cache_size\u670d\u52a1\u5668\u8bbe\u7f6e\u5b9a\u4e49\u672a\u538b\u7f29\u5757\u7684\u7f13\u5b58\u5927\u5c0f\u3002\u9ed8\u8ba41048576\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n37.\u00a0merge_tree_max_bytes_to_use_cache\uff1a\u5728\u4e00\u4e2a\u67e5\u8be2\u4e2d\u8bfb\u53d6\u7684\u6570\u636e\u591a\u4e8emerge_tree_max_bytes_to_use_cache\u5b57\u8282\uff0c\u5219\u5b83\u4e0d\u4f7f\u7528\u672a\u538b\u7f29\u5757\u7684\u7f13\u5b58\uff0c\u540c\u4e0a\u3002\u9ed8\u8ba42013265920\uff0c\u53ef\u9009\u4efb\u4f55\u6b63\u6574\u6570\u3002
\n38.\u00a0min_bytes_to_use_direct_io\uff1a\u4f7f\u7528\u76f4\u63a5I\/O\u8bbf\u95ee\u5b58\u50a8\u78c1\u76d8\u6240\u9700\u7684\u6700\u5c0f\u6570\u636e\u91cf\u3002\u5982\u679c\u8981\u8bfb\u53d6\u7684\u6240\u6709\u6570\u636e\u7684\u603b\u5b58\u50a8\u91cf\u8d85\u8fc7min_bytes_to_use_direct_io\u5b57\u8282\uff0c\u5219ClickHouse\u4f1a\u4f7f\u7528O_DIRECT\u9009\u9879\u4ece\u5b58\u50a8\u78c1\u76d8\u8bfb\u53d6\u6570\u636e\u3002\u9ed8\u8ba40\uff0c\u7981\u7528\uff0c\u53ef\u90090\u3001\u6b63\u6574\u6570\u3002
\n39. log_queries\uff1a\u8bbe\u7f6e\u53d1\u9001\u5230ClickHouse\u7684\u67e5\u8be2\u5c06\u6839\u636equery_log\u670d\u52a1\u5668\u914d\u7f6e\u53c2\u6570\u4e2d\u7684\u89c4\u5219\u8bb0\u5f55\u3002
\n40.\u00a0log_query_threads\uff1a\u8bbe\u7f6e\u8fd0\u884c\u7684\u67e5\u8be2\u7684\u7ebf\u7a0b\u5c06\u6839\u636equery_thread_log\u670d\u52a1\u5668\u914d\u7f6e\u53c2\u6570\u4e2d\u7684\u89c4\u5219\u8bb0\u5f55\u3002
\n41.\u00a0max_insert_block_size\uff1a\u63d2\u5165\u8868\u4e2d\u8981\u5f62\u6210\u7684\u5757\u7684\u5927\u5c0f\u3002\u6b64\u8bbe\u7f6e\u4ec5\u5728\u670d\u52a1\u5668\u6784\u6210\u5757\u7684\u60c5\u51b5\u4e0b\u9002\u7528\u3002\u5bf9\u901a\u8fc7HTTP\u63a5\u53e3\u7684IN\u200b\u200bSERT\uff0c\u670d\u52a1\u5668\u89e3\u6790\u6570\u636e\u683c\u5f0f\u5e76\u5f62\u6210\u6307\u5b9a\u5927\u5c0f\u7684\u5757\u3002\u9ed8\u8ba41048576\u3002\u9ed8\u8ba4\u503c\u7565\u5927\u4e8emax_block_size\uff0c\u8fd9\u6837\u505a\u662f\u56e0\u4e3a\u67d0\u4e9b\u8868\u5f15\u64ce\uff08* MergeTree\uff09\u5728\u78c1\u76d8\u4e0a\u4e3a\u6bcf\u4e2a\u63d2\u5165\u7684\u5757\u5f62\u6210\u4e86\u4e00\u4e2a\u6570\u636e\u90e8\u5206\uff0c\u8fd9\u662f\u4e00\u4e2a\u76f8\u5f53\u5927\u7684\u5b9e\u4f53\u3002\u7c7b\u4f3c\u5730\uff0c* MergeTree\u8868\u5728\u63d2\u5165\u671f\u95f4\u5bf9\u6570\u636e\u8fdb\u884c\u6392\u5e8f\uff0c\u5e76\u4e14\u8db3\u591f\u5927\u7684\u5757\u5927\u5c0f\u5141\u8bb8\u5bf9RAM\u4e2d\u7684\u66f4\u591a\u6570\u636e\u8fdb\u884c\u6392\u5e8f\u3002
\n42.\u00a0max_replica_delay_for_distributed_queries\uff1a\u4ee5\u79d2\u4e3a\u5355\u4f4d\u8bbe\u7f6e\u65f6\u95f4\u3002\u5982\u679c\u526f\u672c\u6ede\u540e\u4e8e\u8bbe\u7f6e\u503c\uff0c\u5219\u4e0d\u4f7f\u7528\u8be5\u526f\u672c\u3002\u9ed8\u8ba4300\u79d2\uff0c\u5728\u590d\u5236\u8868\u7684\u5206\u5e03\u5f0f\u8868\u6267\u884cSELECT\u65f6\u4f7f\u7528\u3002
\n43.\u00a0max_threads\uff1a\u67e5\u8be2\u5904\u7406\u7ebf\u7a0b\u7684\u6700\u5927\u6570\u91cf\uff0c\u4e0d\u5305\u62ec\u7528\u4e8e\u4ece\u8fdc\u7a0b\u670d\u52a1\u5668\u68c0\u7d22\u6570\u636e\u7684\u7ebf\u7a0b\uff08\u8bf7\u53c2\u89c1\u201c max_distributed_connections\u201d\u53c2\u6570\uff09\uff0c\u9002\u7528\u4e8e\u5e76\u884c\u6267\u884c\u67e5\u8be2\u5904\u7406\u7ba1\u9053\u76f8\u540c\u9636\u6bb5\u7684\u7ebf\u7a0b\u3002\u9ed8\u8ba4\u503c\uff1a\u7269\u7406CPU\u5185\u6838\u6570\u3002max_threads\u503c\u8d8a\u5c0f\uff0c\u6d88\u8017\u7684\u5185\u5b58\u8d8a\u5c11\u3002
\n\u5f53\u4ece\u8868\u4e2d\u8bfb\u53d6\u65f6\uff0c\u5982\u679c\u53ef\u4ee5\u4f7f\u7528\u51fd\u6570\u6c42\u503c\u8868\u8fbe\u5f0f\uff0c\u4f7f\u7528WHERE\u8fdb\u884c\u8fc7\u6ee4\u5e76\u4f7f\u7528\u81f3\u5c11\u201cmax_threads\u201d\u4e2a\u7ebf\u7a0b\u6570\u5e76\u884c\u5730\u4e3aGROUP BY\u8fdb\u884c\u9884\u805a\u5408\u3002<\/p>\n\n
\n
\n45.\u00a0max_compress_block_size\uff1a\u538b\u7f29\u5199\u5165\u8868\u4e4b\u524d\uff0c\u672a\u538b\u7f29\u6570\u636e\u5757\u7684\u6700\u5927\u5927\u5c0f\uff0c\u9ed8\u8ba41048576\uff081 MiB\uff09\u3002\u5982\u679c\u51cf\u5c0f\u5927\u5c0f\uff0c\u5219\u7531\u4e8e\u9ad8\u901f\u7f13\u5b58\u5c40\u90e8\u6027\uff0c\u538b\u7f29\u7387\u5c06\u964d\u4f4e\uff0c\u538b\u7f29\u548c\u89e3\u538b\u7f29\u901f\u5ea6\u4f1a\u7565\u6709\u589e\u52a0\uff0c\u5e76\u4e14\u5185\u5b58\u6d88\u8017\u4e5f\u4f1a\u51cf\u5c11\u3002\u901a\u5e38\u6ca1\u6709\u4efb\u4f55\u7406\u7531\u66f4\u6539\u6b64\u8bbe\u7f6e\u3002\u4e0d\u8981\u5c06\u538b\u7f29\u5757\uff08\u7531\u5b57\u8282\u7ec4\u6210\u7684\u5185\u5b58\u5757\uff09\u4e0e\u67e5\u8be2\u5904\u7406\u5757\uff08\u8868\u4e2d\u7684\u4e00\u7ec4\u884c\uff09\u6df7\u6dc6\u3002
\n46.\u00a0min_compress_block_size\uff1a\u5bf9\u4e8eMergeTree\u8868\u4e3a\u4e86\u51cf\u5c11\u5904\u7406\u67e5\u8be2\u65f6\u7684\u5ef6\u8fdf\uff0c\u5982\u679c\u5757\u7684\u5927\u5c0f\u81f3\u5c11\u4e3amin_compress_block_size\uff0c\u5219\u5728\u5199\u5165\u4e0b\u4e00\u4e2a\u6807\u8bb0\u65f6\u5c06\u538b\u7f29\u8be5\u5757\u3002\u9ed8\u8ba4\u503c\u4e3a65536\u3002\u5982\u679c\u672a\u538b\u7f29\u7684\u6570\u636e\u5c0f\u4e8emax_compress_block_size\uff0c\u5219\u5757\u7684\u5b9e\u9645\u5927\u5c0f\u4e0d\u5c0f\u4e8e\u6b64\u503c\u4e14\u4e0d\u5c0f\u4e8e\u4e00\u4e2a\u6807\u8bb0\u7684\u6570\u636e\u91cf\uff0c\u901a\u5e38\u6ca1\u6709\u4efb\u4f55\u7406\u7531\u66f4\u6539\u6b64\u8bbe\u7f6e\u3002
\n47.\u00a0max_query_size\uff1a\u53ef\u4ee5\u5e26\u5230RAM\u4ee5\u4fbf\u4e0eSQL\u89e3\u6790\u5668\u4e00\u8d77\u89e3\u6790\u7684\u67e5\u8be2\u7684\u6700\u5927\u90e8\u5206\uff0c\u9ed8\u8ba4256K\u3002
\n48.\u00a0Interactive_delay\uff1a\u68c0\u67e5\u8bf7\u6c42\u6267\u884c\u662f\u5426\u5df2\u53d6\u6d88\u5e76\u53d1\u9001\u8fdb\u5ea6\u7684\u65f6\u95f4\u95f4\u9694\uff0c\u4ee5\u5fae\u79d2\u4e3a\u5355\u4f4d\u3002\u9ed8\u8ba4\u503c\uff1a100000\uff08\u68c0\u67e5\u53d6\u6d88\u5e76\u6bcf\u79d2\u53d1\u900110\u6b21\u8fdb\u5ea6\uff09\u3002
\n49.\u00a0connect_timeout\uff0creceive_timeout\uff0csend_timeout\uff1a\u7528\u4e8e\u4e0e\u5ba2\u6237\u7aef\u901a\u4fe1\u7684\u5957\u63a5\u5b57\u4e0a\u7684\u8d85\u65f6\uff08\u4ee5\u79d2\u4e3a\u5355\u4f4d\uff09\uff0c\u9ed8\u8ba4\u4e3a10\uff0c300\uff0c300
\n50.\u00a0cancel_http_readonly_queries_on_client_close\uff1a\u5f53\u5ba2\u6237\u7aef\u5173\u95ed\u8fde\u63a5\u800c\u4e0d\u7b49\u5f85\u54cd\u5e94\u65f6\uff0c\u53d6\u6d88HTTP\u53ea\u8bfb\u67e5\u8be2\u3002\u9ed8\u8ba40\uff0c
\n51.\u00a0poll_interval\uff1a\u5c06\u7b49\u5f85\u5faa\u73af\u9501\u5b9a\u6307\u5b9a\u7684\u79d2\u6570\uff0c\u9ed8\u8ba410\u3002
\n52.\u00a0max_distributed_connections\uff1a\u4e0e\u8fdc\u7a0b\u670d\u52a1\u5668\u7684\u5e76\u53d1\u8fde\u63a5\u7684\u6700\u5927\u6570\u91cf\uff0c\u7528\u4e8e\u5bf9\u5355\u4e2a\u67e5\u8be2\u5230\u5355\u4e2aDistributed\u8868\u8fdb\u884c\u5206\u5e03\u5f0f\u5904\u7406\u3002\u5efa\u8bae\u8bbe\u7f6e\u4e0d\u5c0f\u4e8e\u96c6\u7fa4\u4e2d\u670d\u52a1\u5668\u6570\u91cf\u7684\u503c\uff0c\u9ed8\u8ba41024\u3002
\n53.\u00a0distributed_connections_pool_size\uff1a\u4e0e\u8fdc\u7a0b\u670d\u52a1\u5668\u7684\u5e76\u53d1\u8fde\u63a5\u7684\u6700\u5927\u6570\u91cf\uff0c\u7528\u4e8e\u5bf9\u6240\u6709\u67e5\u8be2\u5230\u5355\u4e2aDistributed\u8868\u8fdb\u884c\u7684\u5206\u5e03\u5f0f\u5904\u7406\u3002 \u6211\u4eec\u5efa\u8bae\u8bbe\u7f6e\u4e00\u4e2a\u4e0d\u5c0f\u4e8e\u96c6\u7fa4\u4e2d\u670d\u52a1\u5668\u6570\u91cf\u7684\u503c\u3002\u9ed8\u8ba41024\u3002
\n54.\u00a0connect_timeout_with_failover_ms\uff1a\u5982\u679c\u96c6\u7fa4\u5b9a\u4e49\u4e2d\u4f7f\u7528\u4e86\u201c shard\u201d\u548c\u201c replica\u201d\u90e8\u5206\uff0c\u5219\u8fde\u63a5\u5230\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u7684\u8fdc\u7a0b\u670d\u52a1\u5668\u7684\u8d85\u65f6\u65f6\u95f4\uff08\u4ee5\u6beb\u79d2\u4e3a\u5355\u4f4d\uff09\uff0c\u9ed8\u8ba450\u6beb\u79d2\u3002
\n55.\u00a0connections_with_failover_max_tries\uff1a\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u4e0e\u6bcf\u4e2a\u526f\u672c\u7684\u6700\u5927\u8fde\u63a5\u5c1d\u8bd5\u6b21\u6570\uff0c\u9ed8\u8ba43\u3002
\n56.\u00a0extremes\uff1a\u662f\u5426\u8ba1\u7b97\u6781\u503c\uff08\u67e5\u8be2\u7ed3\u679c\u5217\u4e2d\u7684\u6700\u5c0f\u503c\u548c\u6700\u5927\u503c\uff09\u3002 \u63a5\u53d70\u62161\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c0\uff08\u7981\u7528\uff09\u3002
\n57.\u00a0use_uncompressed_cache\uff1a\u662f\u5426\u4f7f\u7528\u672a\u538b\u7f29\u5757\u7684\u7f13\u5b58\u3002\u63a5\u53d70\u62161\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c0\uff08\u7981\u7528\uff09\u3002
\n\u5f53\u4f7f\u7528\u5927\u91cf\u77ed\u67e5\u8be2\u65f6\uff0c\u4f7f\u7528\u672a\u538b\u7f29\u7684\u7f13\u5b58\uff08\u4ec5\u9002\u7528\u4e8eMergeTree\u7cfb\u5217\u4e2d\u7684\u8868\uff09\u53ef\u4ee5\u6709\u6548\u51cf\u5c11\u5ef6\u8fdf\u5e76\u589e\u52a0\u541e\u5410\u91cf\u3002\u5efa\u8bae\u4e3a\u9891\u7e41\u53d1\u9001\u7b80\u77ed\u8bf7\u6c42\u7684\u7528\u6237\u542f\u7528\u6b64\u8bbe\u7f6e\u3002
\n\u6ce8\u610funcompressed_cache_size\u914d\u7f6e\u53c2\u6570\uff08\u4ec5\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u8bbe\u7f6e\uff09\uff1a\u672a\u538b\u7f29\u7684\u7f13\u5b58\u5757\u7684\u5927\u5c0f\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4e3a8 GiB\u3002\u672a\u538b\u7f29\u7684\u7f13\u5b58\u5c06\u6839\u636e\u9700\u8981\u586b\u5145\uff0c\u5e76\u4e14\u4f7f\u7528\u6700\u5c11\u7684\u6570\u636e\u5c06\u81ea\u52a8\u5220\u9664\u3002
\n\u5bf9\u4e8e\u8bfb\u53d6\u4e00\u4e9b\u6570\u636e\u91cf\uff08\u4e00\u767e\u4e07\u884c\u6216\u66f4\u591a\uff09\u7684\u67e5\u8be2\uff0c\u672a\u538b\u7f29\u7684\u7f13\u5b58\u5c06\u81ea\u52a8\u7981\u7528\uff0c\u4ee5\u8282\u7701\u771f\u6b63\u5c0f\u7684\u67e5\u8be2\u7684\u7a7a\u95f4\u3002\u8fd9\u610f\u5473\u7740\u53ef\u4ee5\u59cb\u7ec8\u5c06\u201c use_uncompressed_cache\u201d\u8bbe\u7f6e\u8bbe\u4e3a1\u3002
\n58.\u00a0replace_running_query\uff1a\u4f7f\u7528HTTP\u63a5\u53e3\u65f6\uff0c\u53ef\u4ee5\u4f20\u9012\\’query_id\\’\u53c2\u6570\u3002\u8fd9\u662f\u7528\u4f5c\u67e5\u8be2\u6807\u8bc6\u7b26\u7684\u4efb\u4f55\u5b57\u7b26\u4e32\u3002\u5982\u679c\u6b64\u65f6\u5df2\u5b58\u5728\u6765\u81ea\u5177\u6709\u76f8\u540cquery_id\u7684\u76f8\u540c\u7528\u6237\u7684\u67e5\u8be2\uff0c\u5219\u884c\u4e3a\u53d6\u51b3\u4e8ereplace_running_query\u53c2\u6570\uff1a<\/p>\n\n
\n60.\u00a0load_balancing\uff1a\u6307\u5b9a\u7528\u4e8e\u5206\u5e03\u5f0f\u67e5\u8be2\u5904\u7406\u7684\u526f\u672c\u9009\u62e9\u7b97\u6cd5\u3002\u9ed8\u8ba4\uff1aRandom\u3002<\/p>\n\n
\n\u8ba1\u7b97\u6bcf\u4e2a\u526f\u672c\u7684\u9519\u8bef\u6570\u91cf\u3002 \u67e5\u8be2\u53d1\u9001\u5230\u6700\u5c11\u7684\u9519\u8bef\u526f\u672c\uff0c\u5982\u679c\u5b58\u5728\u591a\u4e2a\uff0c\u5219\u53d1\u9001\u5230\u5176\u4e2d\u4efb\u4f55\u4e00\u4e2a\u3002
\n\u7f3a\u70b9\uff1a\u4e0d\u8003\u8651\u670d\u52a1\u5668\u7684\u90bb\u8fd1\u6027\uff1b \u5982\u679c\u526f\u672c\u5177\u6709\u4e0d\u540c\u7684\u6570\u636e\uff0c\u5219\u53ef\u80fd\u83b7\u5f97\u4e0d\u540c\u7684\u6570\u636e\u3002<\/li>\n
\n\u8ba1\u7b97\u6bcf\u4e2a\u526f\u672c\u7684\u9519\u8bef\u6570\u91cf\u3002\u6bcf\u96945\u5206\u949f\uff0c\u9519\u8bef\u6570\u91cf\u5c06\u88ab2\u6574\u9664\u3002\u5982\u679c\u6709\u4e00\u4e2a\u526f\u672c\u7684\u9519\u8bef\u6570\u91cf\u6700\u5c11\uff08\u5373\u6700\u8fd1\u5728\u5176\u4ed6\u526f\u672c\u4e0a\u53d1\u751f\u7684\u9519\u8bef\uff09\uff0c\u5219\u5c06\u67e5\u8be2\u53d1\u9001\u7ed9\u5b83\u3002\u5982\u679c\u6709\u591a\u4e2a\u526f\u672c\u4e14\u9519\u8bef\u7684\u6700\u5c0f\u6570\u91cf\u76f8\u540c\uff0c\u5219\u67e5\u8be2\u5c06\u4ee5\u4e0e\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u670d\u52a1\u5668\u4e3b\u673a\u540d\u6700\u76f8\u4f3c\u7684\u4e3b\u673a\u540d\u53d1\u9001\u5230\u526f\u672c\u3002\u56e0\u6b64\uff0c\u5982\u679c\u5b58\u5728\u7b49\u6548\u7684\u526f\u672c\uff0c\u5219\u9996\u9009\u540d\u79f0\u6700\u63a5\u8fd1\u7684\u526f\u672c\u3002<\/li>\n
\n\u5177\u6709\u76f8\u540c\u6570\u91cf\u9519\u8bef\u7684\u526f\u672c\u5c06\u4ee5\u4e0e\u914d\u7f6e\u4e2d\u6307\u5b9a\u7684\u987a\u5e8f\u76f8\u540c\u7684\u987a\u5e8f\u8fdb\u884c\u8bbf\u95ee\uff0c<\/li>\n
\n\u9009\u62e9\u96c6\u5408\u4e2d\u7684\u7b2c\u4e00\u4e2a\u526f\u672c\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u526f\u672c\u4e0d\u53ef\u7528\uff0c\u5219\u9009\u62e9\u4e00\u4e2a\u968f\u673a\u526f\u672c\u3002 \u5b83\u5728\u4ea4\u53c9\u590d\u5236\u62d3\u6251\u8bbe\u7f6e\u4e2d\u6709\u6548\uff0c\u4f46\u5728\u5176\u4ed6\u914d\u7f6e\u4e2d\u65e0\u6548\u3002
\nfirst_or_random\u7b97\u6cd5\u89e3\u51b3\u4e86in_order\u7b97\u6cd5\u7684\u95ee\u9898\u3002 \u4f7f\u7528in_order\uff0c\u5982\u679c\u4e00\u4e2a\u526f\u672c\u51fa\u73b0\u6545\u969c\uff0c\u5219\u4e0b\u4e00\u4e2a\u526f\u672c\u8d1f\u8f7d\u5c06\u52a0\u500d\uff0c\u800c\u5176\u4f59\u526f\u672c\u5219\u5904\u7406\u901a\u5e38\u7684\u6d41\u91cf\u3002 \u4f7f\u7528first_or_random\u7b97\u6cd5\u65f6\uff0c\u8d1f\u8f7d\u5728\u4ecd\u7136\u53ef\u7528\u7684\u526f\u672c\u4e4b\u95f4\u5e73\u5747\u5206\u914d\u3002<\/li>\n<\/ul>\n\n
\n62.\u00a0totals_mode\uff1a\u5b58\u5728HAVING\u65f6\u4ee5\u53ca\u5b58\u5728max_rows_to_group_by\u548cgroup_by_overflow_mode =\\’any\\’\u65f6\u5982\u4f55\u8ba1\u7b97TOTALS\u3002
\n63.\u00a0totals_auto_threshold\uff1atotals_mode =\\’auto\\’\u7684\u9608\u503c\uff0c
\n64.\u00a0max_parallel_replicas\uff1a\u6267\u884c\u67e5\u8be2\u65f6\uff0c\u6bcf\u4e2a\u5206\u7247\u7684\u6700\u5927\u526f\u672c\u6570\u3002\u4e3a\u4e86\u4fdd\u6301\u4e00\u81f4\u6027\uff08\u4ee5\u83b7\u53d6\u540c\u4e00\u6570\u636e\u62c6\u5206\u7684\u4e0d\u540c\u90e8\u5206\uff09\uff0c\u6b64\u9009\u9879\u4ec5\u5728\u8bbe\u7f6e\u91c7\u6837\u952e\u65f6\u624d\u6709\u6548\u3002\u590d\u5236\u5ef6\u8fdf\u4e0d\u53d7\u63a7\u5236\u3002
\n65.\u00a0compile\uff1a\u542f\u7528\u67e5\u8be2\u7f16\u8bd1\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c0\uff08\u7981\u7528\uff09\u3002\u7f16\u8bd1\u4ec5\u7528\u4e8e\u67e5\u8be2\u5904\u7406\u7ba1\u9053\u7684\u4e00\u90e8\u5206\uff1a\u7528\u4e8e\u805a\u5408\u7684\u7b2c\u4e00\u9636\u6bb5\uff08GROUP BY\uff09\u3002\u5bf9\u4e8e\u5177\u6709\u591a\u4e2a\u7b80\u5355\u805a\u5408\u51fd\u6570\u7684\u67e5\u8be2\uff0c\u53ef\u4ee5\u770b\u5230\u6700\u5927\u7684\u6027\u80fd\u6539\u8fdb\uff08\u5728\u6781\u5c11\u6570\u60c5\u51b5\u4e0b\uff0c\u901f\u5ea6\u63d0\u9ad8\u4e86\u56db\u500d\uff09\u3002\u901a\u5e38\uff0c\u6027\u80fd\u63d0\u5347\u5fae\u4e0d\u8db3\u9053\u3002\u5728\u6781\u5c11\u6570\u60c5\u51b5\u4e0b\uff0c\u5b83\u53ef\u80fd\u4f1a\u51cf\u6162\u67e5\u8be2\u7684\u6267\u884c\u901f\u5ea6\u3002
\n66.\u00a0min_count_to_compile\uff1a\u8fd0\u884c\u7f16\u8bd1\u4e4b\u524d\u53ef\u80fd\u4f7f\u7528\u5df2\u7f16\u8bd1\u4ee3\u7801\u5757\u7684\u6b21\u6570\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c3\u3002\u5bf9\u4e8e\u6d4b\u8bd5\uff0c\u53ef\u4ee5\u5c06\u8be5\u503c\u8bbe\u7f6e\u4e3a0
\n67.\u00a0output_format_json_quote_64bit_integers\uff1a\u5982\u679c\u8be5\u503c\u4e3atrue\uff0c\u5219\u5728\u4f7f\u7528JSON * Int64\u548cUInt64\u683c\u5f0f\u65f6\uff08\u4ee5\u4e0e\u5927\u591a\u6570JavaScript\u5b9e\u73b0\u517c\u5bb9\uff09\uff0c\u5f15\u53f7\u4e2d\u4f1a\u51fa\u73b0\u6574\u6570\u3002\u5426\u5219\uff0c\u5c06\u8f93\u51fa\u4e0d\u5e26\u5f15\u53f7\u7684\u6574\u6570\u3002
\n68.\u00a0format_csv_delimiter\uff1aCSV\u6570\u636e\u4e2d\u7684\u5206\u9694\u7b26\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4e3a\uff1a\uff0c
\n69.\u00a0input_format_csv_unquoted_null_literal_as_null\uff1a\u5bf9\u4e8eCSV\u8f93\u5165\u683c\u5f0f\uff0c\u542f\u7528\u6216\u7981\u7528\u5c06\u672a\u5f15\u7528\u7684NULL\u89e3\u6790\u4e3a\u6587\u5b57\u3002
\n70.\u00a0output_format_csv_crlf_end_of_line\uff1a\u5728CSV\u4e2d\u4f7f\u7528DOS \/ Windows\u6837\u5f0f\u884c\u5206\u9694\u7b26\uff08CRLF\uff09\uff0c\u800c\u4e0d\u662fUnix\u6837\u5f0f\uff08LF\uff09\u3002
\n71.\u00a0output_format_tsv_crlf_end_of_line\uff1a\u5728TSV\u4e2d\u4f7f\u7528DOC \/ Windows\u6837\u5f0f\u884c\u5206\u9694\u7b26\uff08CRLF\uff09\uff0c\u800c\u4e0d\u662fUnix\u6837\u5f0f\uff08LF\uff09\u3002
\n72. insert_quorum\uff1a\u542f\u7528\u4ef2\u88c1\u5199\u5165\uff0c\u5199\u5165\u591a\u5c11\u4e2a\u526f\u672c\u624d\u7b97\u6210\u529f\u3002\u9ed8\u8ba40\u3002insert_quorum <2\uff0c\u5219\u7981\u7528\u4ef2\u88c1\u5199\u5165\uff1binsert_quorum> = 2\uff0c\u5219\u542f\u7528\u4ef2\u88c1\u5199\u5165\u3002
\n\u5f53\u5728insert_quorum_timeout\u671f\u95f4\u5c06\u6570\u636e\u6b63\u786e\u5199\u5165\u526f\u672c\u7684insert_quorum\u65f6\uff0cINSERT\u624d\u80fd\u6210\u529f\u3002\u5982\u679c\u7531\u4e8e\u4efb\u4f55\u539f\u56e0\u800c\u6210\u529f\u5199\u5165\u7684\u526f\u672c\u6570\u91cf\u672a\u8fbe\u5230insert_quorum\uff0c\u5219\u8ba4\u4e3a\u5199\u5165\u5931\u8d25\uff0c\u5e76\u5c06\u4ece\u5df2\u5199\u5165\u6570\u636e\u7684\u6240\u6709\u526f\u672c\u4e2d\u5220\u9664\u63d2\u5165\u7684\u5757\u3002\u8bfb\u53d6\u4eceinsert_quorum\u5199\u5165\u7684\u6570\u636e\u65f6\uff0c\u53ef\u4ee5\u4f7f\u7528select_sequential_consistency\u9009\u9879\u3002\u67e5\u8be2\u65f6\u53ef\u7528\u526f\u672c\u7684\u6570\u91cf\u5c0f\u4e8einsert_quorum\u5219\u4f1a\u62a5\u9519\u3002
\n73.\u00a0insert_quorum_timeout\uff1a\u4ef2\u88c1\u5199\u5165\u8d85\u65f6\uff08\u79d2\uff09\uff0c\u9ed8\u8ba460s\u3002 \u5982\u679c\u8d85\u65f6\u65f6\u95f4\u5185\u6ca1\u6709\u5199\u5b8c\uff0c\u5219\u5c06\u751f\u6210\u4e00\u4e2a\u5f02\u5e38\uff0c\u5e76\u4e14\u5ba2\u6237\u7aef\u5fc5\u987b\u91cd\u590d\u67e5\u8be2\u624d\u80fd\u5c06\u540c\u4e00\u5757\u5199\u5165\u76f8\u540c\u6216\u4efb\u4f55\u5176\u4ed6\u526f\u672c\u3002
\n74. select_sequential_consistency\uff1a\u542f\u7528\u6216\u7981\u7528SELECT\u67e5\u8be2\u7684\u987a\u5e8f\u4e00\u81f4\u6027\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\u30011\u3002\u542f\u7528\u987a\u5e8f\u4e00\u81f4\u6027\u540e\uff0cClickHouse\u5141\u8bb8\u5ba2\u6237\u7aef\u4ec5\u5bf9insert_quorum\u6267\u884c\u7684INSERT\u67e5\u8be2\u4e2d\u7684\u6570\u636e\u7684\u526f\u672c\u6267\u884cSELECT\u67e5\u8be2\u3002 \u5982\u679c\u5ba2\u6237\u7aef\u5f15\u7528\u90e8\u5206\u526f\u672c\uff0c\u5219ClickHouse\u5c06\u751f\u6210\u4e00\u4e2a\u5f02\u5e38\u3002 SELECT\u67e5\u8be2\u5c06\u4e0d\u5305\u62ec\u5c1a\u672a\u5199\u5165\u526f\u672c\u4ef2\u88c1\u7684\u6570\u636e\u3002
\n75.\u00a0max_network_bytes\uff1a\u9650\u5236\u6267\u884c\u67e5\u8be2\u65f6\u901a\u8fc7\u7f51\u7edc\u63a5\u6536\u6216\u4f20\u8f93\u7684\u6570\u636e\u91cf\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\u3002\u6b64\u8bbe\u7f6e\u9002\u7528\u4e8e\u6bcf\u4e2a\u5355\u72ec\u7684\u67e5\u8be2\u3002\u9ed8\u8ba40\uff0c\u4e0d\u9650\u5236\u3002\u53ef\u9009\u503c\uff1a0\u3001\u6b63\u6574\u6570\u3002
\n76.\u00a0max_network_bandwidth_for_user\uff1a\u9650\u5236\u6570\u636e\u5728\u7f51\u7edc\u4e0a\u6bcf\u79d2\u4ea4\u6362\u7684\u901f\u5ea6\uff08\u5b57\u8282\uff09\uff0c\u7528\u4e8e\u5355\u4e2a\u7528\u6237\u6267\u884c\u7684\u6240\u6709\u540c\u65f6\u8fd0\u884c\u7684\u67e5\u8be2\u3002\u9ed8\u8ba4\u503c\uff1a0\uff0c\u4e0d\u9650\u5236\u3002\u53ef\u9009\u503c\uff1a0\u3001\u6b63\u6574\u6570\u3002
\n77.\u00a0max_network_bandwidth_for_all_users\uff1a\u9650\u5236\u6570\u636e\u5728\u7f51\u7edc\u4e0a\u6bcf\u79d2\u4ea4\u6362\u7684\u901f\u5ea6\uff08\u5b57\u8282\uff09\uff0c\u7528\u4e8e\u670d\u52a1\u5668\u4e0a\u6240\u6709\u540c\u65f6\u8fd0\u884c\u7684\u67e5\u8be2\u3002\u9ed8\u8ba4\u503c\uff1a0\uff0c\u4e0d\u9650\u5236\u3002\u53ef\u9009\u503c\uff1a0\u3001\u6b63\u6574\u6570\u3002
\n78.\u00a0allow_experimental_cross_to_join_conversion\uff1a\u5c06\u8fde\u8868\u7684,\u8bed\u6cd5\u91cd\u5199\u6210join on\u3001using\u8bed\u6cd5\uff0c\u5982\u679c\u8bbe\u7f6e\u503c\u4e3a0\uff0c\u5219\u4e0d\u4f1a\u4f7f\u7528\u4f7f\u7528\u9017\u53f7\u7684\u8bed\u6cd5\u6765\u5904\u7406\u67e5\u8be2\uff0c\u5e76\u4e14\u4f1a\u5f15\u53d1\u5f02\u5e38\u3002\u9ed8\u8ba41\u3002\u53ef\u90090\u30011\u3002\u53ef\u4ee5\u770bjoin\u7684\u4f7f\u7528<\/a>
\n79.\u00a0count_distinct_implementation\uff1a\u6307\u5b9a\u5e94\u4f7f\u7528\u54ea\u4e2auniq *\u51fd\u6570\u6765\u6267\u884cCOUNT\uff08DISTINCT …\uff09\uff0c\u9ed8\u8ba4uniqExact\u3002\u53ef\u9009\u503c\uff1auniq<\/a>\u3001uniqCombined<\/a>\u3001uniqCombined64<\/a>\u3001uniqHLL12<\/a>\u3001uniqExact<\/a>
\n80.\u00a0skip_unavailable_shards\uff1a\u542f\u7528\u6216\u7981\u7528\u8df3\u8fc7\u4e0d\u53ef\u7528\u7684\u5206\u7247\u3002\u5982\u679c\u5206\u7247\u7684\u6240\u6709\u526f\u672c\u90fd\u4e0d\u53ef\u7528\uff0c\u5219\u8ba4\u4e3a\u5206\u7247\u4e0d\u53ef\u7528\u3002\u9ed8\u8ba40\uff0c\u7981\u6b62\u8df3\u8fc7\uff0c\u53ef\u9009\u503c0\u30011\u3002
\n81. optimize_skip_unused_shards\uff1a\u5bf9\u5728PREWHERE \/ WHERE\u4e2d\u5177\u6709\u5206\u7247\u952e\u6761\u4ef6\u7684SELECT\u67e5\u8be2\u542f\u7528\u6216\u7981\u7528\u8df3\u8fc7\u672a\u4f7f\u7528\u7684\u5206\u7247\uff08\u5047\u8bbe\u6570\u636e\u662f\u901a\u8fc7\u5206\u7247\u952e\u5206\u53d1\u7684\uff0c\u5426\u5219\u4e0d\u6267\u884c\u4efb\u4f55\u64cd\u4f5c\uff09\u3002\u9ed8\u8ba40\uff0c\u7981\u6b62\u8df3\u8fc7\u3002
\n82.\u00a0force_optimize_skip_unused_shards\uff1a\u5982\u679c\u542f\u7528\u4e86optimize_skip_unused_shards(0)\uff0c\u5e76\u4e14\u65e0\u6cd5\u8df3\u8fc7\u672a\u4f7f\u7528\u7684\u5206\u7247\u3002\u5982\u679c\u65e0\u6cd5\u8df3\u8fc7\u5e76\u4e14\u542f\u7528\u4e86\u8bbe\u7f6e\uff0c\u5219\u5c06\u5f15\u53d1\u5f02\u5e38\u3002\u9ed8\u8ba40\uff0c\u7981\u7528\u3002\u53ef\u9009\u503c\uff1a0\uff1a\u7981\u7528\uff08\u4e0d\u629b\u51fa\uff091\uff1a\u4ec5\u5728\u8868\u5177\u6709\u5206\u7247\u952e\u65f6\u624d\u7981\u7528\u67e5\u8be2\u6267\u884c\u00a02\uff1a\u7981\u7528\u67e5\u8be2\u6267\u884c\uff0c\u65e0\u8bba\u4e3a\u8868\u5b9a\u4e49\u4e86\u5206\u7247\u952e\u5982\u4f55
\n83.\u00a0optimize_throw_if_noop\uff1a\u5982\u679cOPTIMIZE\u67e5\u8be2\u672a\u6267\u884c\u5408\u5e76\uff0c\u5219\u542f\u7528\u6216\u7981\u7528\u5f15\u53d1\u5f02\u5e38\u3002\u9ed8\u8ba40\uff0c\u53ef\u90090\uff1a\u7981\u7528\u5f15\u53d1\u5f02\u5e38\uff1b1\uff1a\u542f\u7528\u5f15\u53d1\u5f02\u5e38
\n\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5373\u4f7f\u672a\u6267\u884c\u4efb\u4f55\u64cd\u4f5c\uff0cOPTIMIZE\u4e5f\u4f1a\u6210\u529f\u8fd4\u56de\u3002\u4f7f\u7528\u6b64\u8bbe\u7f6e\u53ef\u4ee5\u533a\u5206\u8fd9\u4e9b\u60c5\u51b5\uff0c\u5e76\u5728\u5f02\u5e38\u6d88\u606f\u4e2d\u83b7\u53d6\u539f\u56e0\u3002
\n84.\u00a0distributed_replica_error_half_life\uff1a\u63a7\u5236\u5c06\u5206\u5e03\u5f0f\u8868\u4e2d\u7684\u9519\u8bef\u5feb\u901f\u5f52\u96f6\u7684\u65b9\u5f0f\u3002\u5982\u679c\u67d0\u4e2a\u526f\u672c\u5728\u4e00\u6bb5\u65f6\u95f4\u5185\u4e0d\u53ef\u7528\uff0c\u7d2f\u79ef\u4e865\u4e2a\u9519\u8bef\uff0c\u5e76\u4e14distributed_replica_error_half_life\u8bbe\u7f6e\u4e3a1\u79d2\uff0c\u5219\u8be5\u526f\u672c\u5728\u4e0a\u6b21\u9519\u8bef\u4e4b\u540e3\u79d2\u949f\u88ab\u89c6\u4e3a\u6b63\u5e38\u3002\u9ed8\u8ba460s\u3002
\n85.\u00a0distributed_replica_error_cap\uff1a\u6bcf\u4e2a\u526f\u672c\u7684\u9519\u8bef\u8ba1\u6570\u90fd\u4ee5\u8be5\u503c\u4e3a\u4e0a\u9650\uff0c\u4ece\u800c\u9632\u6b62\u5355\u4e2a\u526f\u672c\u7d2f\u79ef\u592a\u591a\u9519\u8bef\uff0c\u9ed8\u8ba41000\u3002
\n86.\u00a0distributed_directory_monitor_sleep_time_ms\uff1a\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u53d1\u9001\u6570\u636e\u7684\u57fa\u672c\u95f4\u9694\u3002\u53d1\u751f\u9519\u8bef\u65f6\uff0c\u5b9e\u9645\u95f4\u9694\u5c06\u5448\u6307\u6570\u589e\u957f\uff0c\u9ed8\u8ba4100\u6beb\u79d2\u3002
\n87.\u00a0distributed_directory_monitor_max_sleep_time_ms\uff1a\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u53d1\u9001\u6570\u636e\u7684\u6700\u5927\u95f4\u9694\u3002\u9650\u5236\u5728distributed_directory_monitor_sleep_time_ms\u8bbe\u7f6e\u7684\u95f4\u9694\u7684\u6307\u6570\u589e\u957f\u3002\u9ed8\u8ba4\u503c\uff1a30000\u6beb\u79d2\uff0830\u79d2\uff09\u3002
\n88.\u00a0distributed_directory_monitor_batch_inserts\uff1a\u542f\u7528\/\u7981\u7528\u6279\u91cf\u53d1\u9001\u63d2\u5165\u7684\u6570\u636e\u3002\u542f\u7528\u6279\u53d1\u9001\u529f\u80fd\u540e\uff0c\u5206\u5e03\u5f0f\u8868\u5f15\u64ce\u5c06\u5c1d\u8bd5\u901a\u8fc7\u4e00\u9879\u64cd\u4f5c\u53d1\u9001\u591a\u4e2a\u63d2\u5165\u6570\u636e\u6587\u4ef6\uff0c\u800c\u4e0d\u662f\u5206\u522b\u53d1\u9001\u3002\u6279\u53d1\u9001\u901a\u8fc7\u66f4\u597d\u5730\u5229\u7528\u670d\u52a1\u5668\u548c\u7f51\u7edc\u8d44\u6e90\u6765\u63d0\u9ad8\u7fa4\u96c6\u6027\u80fd\u3002\u9ed8\u8ba40\uff0c\u7981\u7528\uff0c\u53ef\u90090\u30011\u3002
\n89.\u00a0os_thread_priority\uff1a\u4e3a\u6267\u884c\u67e5\u8be2\u7684\u7ebf\u7a0b\u8bbe\u7f6e\u4f18\u5148\u7ea7\uff08nice\uff09\u3002\u5f53\u9009\u62e9\u5728\u6bcf\u4e2a\u53ef\u7528CPU\u5185\u6838\u4e0a\u8fd0\u884c\u7684\u4e0b\u4e00\u4e2a\u7ebf\u7a0b\u65f6\uff0cOS\u8c03\u5ea6\u7a0b\u5e8f\u4f1a\u8003\u8651\u6b64\u4f18\u5148\u7ea7\u3002\u9ed8\u8ba4\u503c\uff1a0\uff0c\u53ef\u9009\u503c\uff1a\u53ef\u4ee5\u5728[-20\uff0c19]\u8303\u56f4\u5185\u8bbe\u7f6e\u503c\u3002\u8f83\u4f4e\u7684\u503c\u8868\u793a\u8f83\u9ad8\u7684\u4f18\u5148\u7ea7\u3002
\n90. query_profiler_real_time_period_ns\uff1a\u67e5\u8be2\u4e8b\u4ef6\u63a2\u67e5\u5668\u7684\u5b9e\u9645\u65f6\u949f\u8ba1\u65f6\u5668\u7684\u5468\u671f\u3002\u5b9e\u65f6\u65f6\u949f\u8ba1\u65f6\u5668\u8ba1\u7b97\u6302\u949f\u65f6\u95f4\u3002\u5355\u4f4d\u7eb3\u79d2\uff0c\u9ed8\u8ba4\u503c\uff1a1000000000\u7eb3\u79d2\uff08\u6bcf\u79d2\uff09\uff0c\u53ef\u9009\u503c\uff1a<\/p>\n\n
\n92.\u00a0input_format_parallel_parsing\uff1a\u542f\u7528\u6570\u636e\u683c\u5f0f\u7684\u4fdd\u7559\u987a\u5e8f\u5e76\u884c\u89e3\u6790\u3002 \u4ec5\u652f\u6301TSV\uff0cTKSV\uff0cCSV\u548cJSONEachRow\u683c\u5f0f\u3002
\n93. min_chunk_bytes_for_parallel_parsing\uff1a\u6bcf\u4e2a\u7ebf\u7a0b\u5c06\u5e76\u884c\u89e3\u6790\u7684\u6700\u5c0f\u5757\u5927\u5c0f\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\uff0c\u9ed8\u8ba41M\u3002
\n94.\u00a0output_format_avro_codec\uff1a\u8bbe\u7f6e\u7528\u4e8e\u8f93\u51faAvro\u6587\u4ef6\u7684\u538b\u7f29\u7f16\u89e3\u7801\u5668\u3002\u9ed8\u8ba4snappy\u6216deflate\uff0c\u53ef\u9009\u503c\uff1a<\/p>\n\n
\n96.\u00a0format_avro_schema_registry_url\uff1a\u8bbe\u7f6eConfluent Schema\u6ce8\u518c\u8868URL\u4ee5\u4e0eAvroConfluent\u683c\u5f0f\u4e00\u8d77\u4f7f\u7528\uff0c\u9ed8\u8ba4\u7a7a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"