{"id":5977,"date":"2021-05-17T15:26:53","date_gmt":"2021-05-17T07:26:53","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=5977"},"modified":"2021-05-18T10:40:19","modified_gmt":"2021-05-18T02:40:19","slug":"clickhouse-%e5%85%83%e6%95%b0%e6%8d%ae%e8%a1%a8system-settings%e4%bb%8b%e7%bb%8d%e5%92%8c%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/5977","title":{"rendered":"Clickhouse \u5143\u6570\u636e\u8868system.settings\u4ecb\u7ecd\u548c\u4f7f\u7528"},"content":{"rendered":"<p>Clickhouse \u53ef\u4ee5\u901a\u8fc7set \u6765\u8bbe\u7f6e\u53c2\u6570\u503c\uff0c\u901a\u8fc7show setting \u6765\u67e5\u770b\u5f53\u524d\u7684\u503c\u3002 \u53c2\u6570\u5185\u5bb9\u662f\u4fdd\u5b58\u5728system.settings\u5143\u6570\u636e\u8868\u91cc\u9762\u7684\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2b2c97877cd\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2b2c97877cd\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#%E5%8F%82%E8%80%83\" >\u53c2\u8003<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#systemsettings%E8%A1%A8%E7%BB%93%E6%9E%84\" >system.settings\u8868\u7ed3\u6784<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#%E8%A1%A8%E7%BB%93%E6%9E%84\" >\u8868\u7ed3\u6784<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#%E6%94%AF%E6%8C%81%E7%9A%84%E7%B1%BB%E5%9E%8B%E5%88%97%E8%A1%A8\" >\u652f\u6301\u7684\u7c7b\u578b\u5217\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#DESC%E8%BE%93%E5%87%BA\" >DESC\u8f93\u51fa<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/5977\/#%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\" >\u4f7f\u7528\u6837\u4f8b<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%82%E8%80%83\"><\/span>\u53c2\u8003<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"https:\/\/www.gbase8.cn\/en\/5868\/\">Clickhouse \u8bbe\u7f6e\u548c\u67e5\u770b\u53c2\u6570\u503cset\u548cshow settings<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"systemsettings%E8%A1%A8%E7%BB%93%E6%9E%84\"><\/span>system.settings\u8868\u7ed3\u6784<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u4e00\u51718\u4e2a\u5b57\u6bb5\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E8%A1%A8%E7%BB%93%E6%9E%84\"><\/span>\u8868\u7ed3\u6784<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u5217\u540d<\/th><th>\u7c7b\u578b<\/th><th>\u8bf4\u660e<\/th><\/tr><\/thead><tbody><tr><td>name<\/td><td>String<\/td><td>\u53c2\u6570\u540d\u5b57<\/td><\/tr><tr><td>value<\/td><td>String<\/td><td>\u53c2\u6570\u503c<\/td><\/tr><tr><td>changed<\/td><td>UInt8<\/td><td>\u53c2\u6570\u76f8\u5bf9\u9ed8\u8ba4\u503c\uff0c\u662f\u5426\u4fee\u6539\u8fc7<\/td><\/tr><tr><td>description<\/td><td>String<\/td><td>\u53c2\u6570\u7684\u7b80\u77ed\u63cf\u8ff0\u4fe1\u606f<\/td><\/tr><tr><td>min<\/td><td>Nullable(String)<\/td><td>\u53c2\u6570\u7684\u6700\u5c0f\u503c\uff0c\u5982\u679c\u6ca1\u6709\u5219\u4e3anull<\/td><\/tr><tr><td>max<\/td><td>Nullable(String)<\/td><td>\u53c2\u6570\u7684\u6700\u5927\u503c\uff0c\u5982\u679c\u6ca1\u6709\u5219\u4e3anull<\/td><\/tr><tr><td>readonly<\/td><td>UInt8<\/td><td>\u53c2\u6570\u662f\u5426\u53ea\u8bfb\uff0c\u4e0d\u53ef\u4fee\u6539<br>0\uff1a\u53ef\u4ee5\u4fee\u6539<br>1\uff1a\u4e0d\u53ef\u4ee5\u4fee\u6539<\/td><\/tr><tr><td>type<\/td><td>String<\/td><td>\u53c2\u6570\u5206\u7c7b\uff0c\u548c\u5b57\u6bb5\u57fa\u672c\u7c7b\u578b\u5bf9\u5e94\uff0cUInt31\uff0cUInt64\uff0cString\u4e4b\u7c7b\u7684<\/td><\/tr><\/tbody><\/table><figcaption>Clickhouse \u5143\u6570\u636e\u8868 system.settings\u8868\u7ed3\u6784 <\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%94%AF%E6%8C%81%E7%9A%84%E7%B1%BB%E5%9E%8B%E5%88%97%E8%A1%A8\"><\/span>\u652f\u6301\u7684\u7c7b\u578b\u5217\u8868<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>localhost :) select distinct type from system.settings\r\n\r\nSELECT DISTINCT type\r\nFROM system.settings\r\n\r\nQuery id: 07ce6a1e-1280-4a14-aee5-6db5af39b74d\r\n\r\n\u250c\u2500type\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\r\n\u2502 UInt64                   \u2502\r\n\u2502 MaxThreads               \u2502\r\n\u2502 Seconds                  \u2502\r\n\u2502 Milliseconds             \u2502\r\n\u2502 Bool                     \u2502\r\n\u2502 LoadBalancing            \u2502\r\n\u2502 TotalsMode               \u2502\r\n\u2502 Float                    \u2502\r\n\u2502 String                   \u2502\r\n\u2502 Int64                    \u2502\r\n\u2502 LogQueriesType           \u2502\r\n\u2502 DistributedProductMode   \u2502\r\n\u2502 JoinStrictness           \u2502\r\n\u2502 OverflowMode             \u2502\r\n\u2502 OverflowModeGroupBy      \u2502\r\n\u2502 JoinAlgorithm            \u2502\r\n\u2502 LogsLevel                \u2502\r\n\u2502 DefaultDatabaseEngine    \u2502\r\n\u2502 MySQLDataTypesSupport    \u2502\r\n\u2502 DistributedDDLOutputMode \u2502\r\n\u2502 UnionMode                \u2502\r\n\u2502 Char                     \u2502\r\n\u2502 DateTimeInputFormat      \u2502\r\n\u2502 DateTimeOutputFormat     \u2502\r\n\u2502 URI                      \u2502\r\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n\r\n25 rows in set. Elapsed: 0.009 sec.\r\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"DESC%E8%BE%93%E5%87%BA\"><\/span>DESC\u8f93\u51fa<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>localhost :) desc system.settings ;\r\n\r\nDESCRIBE TABLE system.settings\r\n\r\nQuery id: de9c3f5f-44f3-4713-b7bc-bfec1c6901e9\r\n\r\n\u250c\u2500name\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500type\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500default_type\u2500\u252c\u2500default_expression\u2500\u252c\u2500comment\u2500\u252c\u2500codec_expression\u2500\u252c\u2500ttl_expression\u2500\u2510\r\n\u2502 name        \u2502 String           \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 value       \u2502 String           \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 changed     \u2502 UInt8            \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 description \u2502 String           \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 min         \u2502 Nullable(String) \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 max         \u2502 Nullable(String) \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 readonly    \u2502 UInt8            \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2502 type        \u2502 String           \u2502              \u2502                    \u2502         \u2502                  \u2502                \u2502\r\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\r\n\r\n8 rows in set. Elapsed: 0.004 sec.\r\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%BD%BF%E7%94%A8%E6%A0%B7%E4%BE%8B\"><\/span>\u4f7f\u7528\u6837\u4f8b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>localhost :) select * from system.settings limit 1\\G\r\n\r\nSELECT *\r\nFROM system.settings\r\nLIMIT 1\r\n\r\nQuery id: 419e76fc-2079-445b-ad45-e79099ccba66\r\n\r\nRow 1:\r\n\u2500\u2500\u2500\u2500\u2500\u2500\r\nname:        min_compress_block_size\r\nvalue:       65536\r\nchanged:     0\r\ndescription: The actual size of the block to compress, if the uncompressed data less than max_compress_block_size is no less than this value and no less than the volume of data for one mark.\r\nmin:         \u1d3a\u1d41\u1d38\u1d38\r\nmax:         \u1d3a\u1d41\u1d38\u1d38\r\nreadonly:    0\r\ntype:        UInt64\r\n\r\n1 rows in set. Elapsed: 0.004 sec.\r\n\r\nlocalhost :)\r\n<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>Clickhouse \u53ef\u4ee5\u901a\u8fc7set \u6765\u8bbe\u7f6e\u53c2\u6570\u503c\uff0c\u901a\u8fc7show setting \u6765\u67e5\u770b\u5f53\u524d\u7684\u503c\u3002 \u53c2\u6570\u5185\u5bb9\u662f\u4fdd\u5b58\u5728system.settings\u5143\u6570\u636e\u8868\u91cc\u9762\u7684\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86],"tags":[69],"class_list":["post-5977","post","type-post","status-publish","format-standard","hentry","category-clickhouse","tag-69"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5977","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=5977"}],"version-history":[{"count":1,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5977\/revisions"}],"predecessor-version":[{"id":5978,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/5977\/revisions\/5978"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=5977"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=5977"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=5977"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}