| If you encounter <Error in verifying browser for feedback submission. Captcha token could not be obtained.> please ensure that you can access Google services." data-user-analytics-fingerprint-enabled="true" data-consent-required="true" data-consent-screen-disclaimer="By clicking <I agree, let's chat>, you consent to the use of the AI assistant in accordance with kapa.ai's [Privacy Policy](https://www.kapa.ai/content/privacy-policy). This service uses reCAPTCHA, which requires your consent to Google's [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms). By proceeding, you explicitly agree to both kapa.ai's and Google's privacy policies."></script><link rel="icon" href="/favicon.ico"><meta name="Description" content="Apache IoTDB: Time Series Database for IoT"><meta name="Keywords" content="TSDB, time series, time series database, IoTDB, IoT database, IoT data management, 时序数据库, 时间序列管理, IoTDB, 物联网数据库, 实时数据库, 物联网数据管理, 物联网数据"><meta name="baidu-site-verification" content="wfKETzB3OT"><meta name="google-site-verification" content="mZWAoRY0yj_HAr-s47zHCGHzx5Ju-RVm5wDbPnwQYFo"><script type="text/javascript">var _paq = window._paq = window._paq || []; |
| <div id="app"><!--[--><!--[--><!--[--><span tabindex="-1"></span><a href="#main-content" class="vp-skip-link sr-only">Skip to main content</a><!--]--><!--[--><div class="theme-container external-link-icon has-toc" vp-container><!--[--><header id="navbar" class="vp-navbar" vp-navbar><div class="vp-navbar-start"><button type="button" class="vp-toggle-sidebar-button" title="Toggle Sidebar"><span class="icon"></span></button><!--[--><a class="route-link vp-brand" href="/" aria-label="Take me home"><img class="vp-nav-logo" src="/logo.png" alt><!----><!----></a><!--]--></div><div class="vp-navbar-center"><!--[--><!--]--></div><div class="vp-navbar-end"><!--[--><!--[--><div id="docsearch-container" style="display:none;"></div><div class="docsearch-placeholder"><button type="button" aria-label="Search" aria-keyshortcuts="Control+k" class="DocSearch DocSearch-Button"><span class="DocSearch-Button-Container"><svg width="20" height="20" viewBox="0 0 24 24" aria-hidden="true" class="DocSearch-Search-Icon"><circle cx="11" cy="11" r="8" stroke="currentColor" fill="none" stroke-width="1.4"></circle><path d="m21 21-4.3-4.3" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">Search</span></span><span class="DocSearch-Button-Keys"><kbd class="DocSearch-Button-Key DocSearch-Button-Key--ctrl">Ctrl</kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div><!--]--><div><button id="custom-ask-ai-button"> ✨ Ask AI </button></div><nav class="vp-nav-links"><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="Documentation"><!--[--><!---->Documentation<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/latest/QuickStart/QuickStart_apache.html" aria-label="v2.0.x"><!---->v2.0.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/V1.3.x/QuickStart/QuickStart_apache.html" aria-label="v1.3.x"><!---->v1.3.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/V1.2.x/QuickStart/QuickStart.html" aria-label="v1.2.x"><!---->v1.2.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/V0.13.x/QuickStart/QuickStart.html" aria-label="v0.13.x"><!---->v0.13.x<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><a class="auto-link external-link" href="https://cwiki.apache.org/confluence/display/IOTDB/System+Design" aria-label="Design" rel="noopener noreferrer" target="_blank"><!---->Design<!----></a></div><div class="vp-nav-item hide-in-mobile"><a class="route-link auto-link" href="/Download/" aria-label="Download"><!---->Download<!----></a></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="Community"><!--[--><!---->Community<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/About-the-Community.html" aria-label="About the Community"><!---->About the Community<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/Development-Guide.html" aria-label="Development Guide"><!---->Development Guide<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/Community-Partners.html" aria-label="Community Partners"><!---->Community Partners<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/Communication-Channels.html" aria-label="Communication Channels"><!---->Communication Channels<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/Events-and-Reports.html" aria-label="Events and Reports"><!---->Events and Reports<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/Community/Committers.html" aria-label="Committers"><!---->Committers<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="ASF"><!--[--><!---->ASF<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/" aria-label="Foundation" rel="noopener noreferrer" target="_blank"><!---->Foundation<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/licenses/" aria-label="License" rel="noopener noreferrer" target="_blank"><!---->License<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/security/" aria-label="Security" rel="noopener noreferrer" target="_blank"><!---->Security<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/sponsorship.html" aria-label="Sponsorship" rel="noopener noreferrer" target="_blank"><!---->Sponsorship<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/thanks.html" aria-label="Thanks" rel="noopener noreferrer" target="_blank"><!---->Thanks<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/events/current-event" aria-label="Current Events" rel="noopener noreferrer" target="_blank"><!---->Current Events<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://privacy.apache.org/policies/privacy-policy-public.html" aria-label="Privacy" rel="noopener noreferrer" target="_blank"><!---->Privacy<!----></a></li></ul></button></div></div></nav><div class="vp-nav-item"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="Select language"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon i18n-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="i18n icon" name="i18n" style="width:1rem;height:1rem;vertical-align:middle;"><path d="M379.392 460.8 494.08 575.488l-42.496 102.4L307.2 532.48 138.24 701.44l-71.68-72.704L234.496 460.8l-45.056-45.056c-27.136-27.136-51.2-66.56-66.56-108.544h112.64c7.68 14.336 16.896 27.136 26.112 35.84l45.568 46.08 45.056-45.056C382.976 312.32 409.6 247.808 409.6 204.8H0V102.4h256V0h102.4v102.4h256v102.4H512c0 70.144-37.888 161.28-87.04 210.944L378.88 460.8zM576 870.4 512 1024H409.6l256-614.4H768l256 614.4H921.6l-64-153.6H576zM618.496 768h196.608L716.8 532.48 618.496 768z"></path></svg><!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link route-link-active auto-link" href="/UserGuide/latest-Table/Reference/System-Config-Manual_apache.html" aria-label="English"><!---->English<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.html" aria-label="简体中文"><!---->简体中文<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><button type="button" class="vp-color-mode-switch" id="color-mode-switch"><svg xmlns="http://www.w3.org/2000/svg" class="icon auto-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="auto icon" name="auto" style="display:none;"><path d="M512 992C246.92 992 32 777.08 32 512S246.92 32 512 32s480 214.92 480 480-214.92 480-480 480zm0-840c-198.78 0-360 161.22-360 360 0 198.84 161.22 360 360 360s360-161.16 360-360c0-198.78-161.22-360-360-360zm0 660V212c165.72 0 300 134.34 300 300 0 165.72-134.28 300-300 300z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon dark-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="dark icon" name="dark" style="display:none;"><path d="M524.8 938.667h-4.267a439.893 439.893 0 0 1-313.173-134.4 446.293 446.293 0 0 1-11.093-597.334A432.213 432.213 0 0 1 366.933 90.027a42.667 42.667 0 0 1 45.227 9.386 42.667 42.667 0 0 1 10.24 42.667 358.4 358.4 0 0 0 82.773 375.893 361.387 361.387 0 0 0 376.747 82.774 42.667 42.667 0 0 1 54.187 55.04 433.493 433.493 0 0 1-99.84 154.88 438.613 438.613 0 0 1-311.467 128z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon light-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="light icon" name="light" style="display:block;"><path d="M952 552h-80a40 40 0 0 1 0-80h80a40 40 0 0 1 0 80zM801.88 280.08a41 41 0 0 1-57.96-57.96l57.96-58a41.04 41.04 0 0 1 58 58l-58 57.96zM512 752a240 240 0 1 1 0-480 240 240 0 0 1 0 480zm0-560a40 40 0 0 1-40-40V72a40 40 0 0 1 80 0v80a40 40 0 0 1-40 40zm-289.88 88.08-58-57.96a41.04 41.04 0 0 1 58-58l57.96 58a41 41 0 0 1-57.96 57.96zM192 512a40 40 0 0 1-40 40H72a40 40 0 0 1 0-80h80a40 40 0 0 1 40 40zm30.12 231.92a41 41 0 0 1 57.96 57.96l-57.96 58a41.04 41.04 0 0 1-58-58l58-57.96zM512 832a40 40 0 0 1 40 40v80a40 40 0 0 1-80 0v-80a40 40 0 0 1 40-40zm289.88-88.08 58 57.96a41.04 41.04 0 0 1-58 58l-57.96-58a41 41 0 0 1 57.96-57.96z"></path></svg></button></div><div class="vp-nav-item vp-action"><a class="vp-action-link" href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer" aria-label="GitHub"><svg xmlns="http://www.w3.org/2000/svg" class="icon github-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="github icon" name="github" style="width:1.25rem;height:1.25rem;vertical-align:middle;"><path d="M511.957 21.333C241.024 21.333 21.333 240.981 21.333 512c0 216.832 140.544 400.725 335.574 465.664 24.49 4.395 32.256-10.07 32.256-23.083 0-11.69.256-44.245 0-85.205-136.448 29.61-164.736-64.64-164.736-64.64-22.315-56.704-54.4-71.765-54.4-71.765-44.587-30.464 3.285-29.824 3.285-29.824 49.195 3.413 75.179 50.517 75.179 50.517 43.776 75.008 114.816 53.333 142.762 40.79 4.523-31.66 17.152-53.377 31.19-65.537-108.971-12.458-223.488-54.485-223.488-242.602 0-53.547 19.114-97.323 50.517-131.67-5.035-12.33-21.93-62.293 4.779-129.834 0 0 41.258-13.184 134.912 50.346a469.803 469.803 0 0 1 122.88-16.554c41.642.213 83.626 5.632 122.88 16.554 93.653-63.488 134.784-50.346 134.784-50.346 26.752 67.541 9.898 117.504 4.864 129.834 31.402 34.347 50.474 78.123 50.474 131.67 0 188.586-114.73 230.016-224.042 242.09 17.578 15.232 33.578 44.672 33.578 90.454v135.85c0 13.142 7.936 27.606 32.854 22.87C862.25 912.597 1002.667 728.747 1002.667 512c0-271.019-219.648-490.667-490.71-490.667z"></path></svg></a></div><!--]--><button type="button" class="vp-toggle-navbar-button" aria-label="Toggle Navbar" aria-expanded="false" aria-controls="nav-screen"><span><span class="vp-top"></span><span class="vp-middle"></span><span class="vp-bottom"></span></span></button></div></header><!----><!--]--><!----><div class="toggle-sidebar-wrapper"><span class="arrow start"></span></div><aside id="sidebar" class="vp-sidebar" vp-sidebar><!--[--><p class="vp-sidebar-header iotdb-sidebar-header"><span class="vp-sidebar-title">IoTDB User Guide (V2.0.x)</span></p><div class="sidebar-top-wrapper"><ul class="switch-list"><li class="switch-type">Tree</li><li class="switch-type switch-active">Table</li></ul><div class="help-icon-wrapper"><div class="help-icon"><span>Description</span></div></div></div><!--]--><ul class="vp-sidebar-links"><li><section class="vp-sidebar-group"><p class="vp-sidebar-header"><!----><span class="vp-sidebar-title">IoTDB User Guide (V2.0.x)</span><!----></p><ul class="vp-sidebar-links"></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">About IoTDB</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Background knowledge</span><span class="vp-arrow end"></span></button><!----></section></li><li><a class="route-link auto-link vp-sidebar-link" href="/UserGuide/latest-Table/QuickStart/QuickStart_apache.html" aria-label="Quick Start"><!---->Quick Start<!----></a></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Installation and Deployment</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Basic Functions</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Advanced Features</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">AI capability</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Tools System</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">API</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Ecosystem Integration</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">SQL Manual</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">Technical Insider</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable active" type="button"><!----><span class="vp-sidebar-title">Reference</span><span class="vp-arrow down"></span></button><ul class="vp-sidebar-links"><li><a class="route-link auto-link vp-sidebar-link" href="/UserGuide/latest-Table/Reference/Sample-Data.html" aria-label="Sample Data"><!---->Sample Data<!----></a></li><li><a class="route-link route-link-active auto-link vp-sidebar-link active" href="/UserGuide/latest-Table/Reference/System-Config-Manual_apache.html" aria-label="Config Manual"><!---->Config Manual<!----></a></li><li><a class="route-link auto-link vp-sidebar-link" href="/UserGuide/latest-Table/Reference/Status-Codes.html" aria-label="Status Codes"><!---->Status Codes<!----></a></li><li><a class="route-link auto-link vp-sidebar-link" href="/UserGuide/latest-Table/Reference/System-Tables_apache.html" aria-label="System Tables"><!---->System Tables<!----></a></li></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">FAQ</span><span class="vp-arrow end"></span></button><!----></section></li></ul><!----></aside><!--[--><main id="main-content" class="vp-page"><!--[--><!----><!----><nav class="vp-breadcrumb disable"></nav><div class="vp-page-title"><h1><!---->Config Manual</h1><div class="page-info"><!----><!----><span class="page-date-info" aria-label="Writing Date📅" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon calendar-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="calendar icon" name="calendar"><path d="M716.4 110.137c0-18.753-14.72-33.473-33.472-33.473-18.753 0-33.473 14.72-33.473 33.473v33.473h66.993v-33.473zm-334.87 0c0-18.753-14.72-33.473-33.473-33.473s-33.52 14.72-33.52 33.473v33.473h66.993v-33.473zm468.81 33.52H716.4v100.465c0 18.753-14.72 33.473-33.472 33.473a33.145 33.145 0 01-33.473-33.473V143.657H381.53v100.465c0 18.753-14.72 33.473-33.473 33.473a33.145 33.145 0 01-33.473-33.473V143.657H180.6A134.314 134.314 0 0046.66 277.595v535.756A134.314 134.314 0 00180.6 947.289h669.74a134.36 134.36 0 00133.94-133.938V277.595a134.314 134.314 0 00-133.94-133.938zm33.473 267.877H147.126a33.145 33.145 0 01-33.473-33.473c0-18.752 14.72-33.473 33.473-33.473h736.687c18.752 0 33.472 14.72 33.472 33.473a33.145 33.145 0 01-33.472 33.473z"></path></svg><span data-allow-mismatch="text">1/3/25</span><meta property="datePublished" content="2025-01-03T10:29:25.000Z"></span><!----><span class="page-reading-time-info" aria-label="Reading Time⌛" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon timer-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="timer icon" name="timer"><path d="M799.387 122.15c4.402-2.978 7.38-7.897 7.38-13.463v-1.165c0-8.933-7.38-16.312-16.312-16.312H256.33c-8.933 0-16.311 7.38-16.311 16.312v1.165c0 5.825 2.977 10.874 7.637 13.592 4.143 194.44 97.22 354.963 220.201 392.763-122.204 37.542-214.893 196.511-220.2 389.397-4.661 5.049-7.638 11.651-7.638 19.03v5.825h566.49v-5.825c0-7.379-2.849-13.981-7.509-18.9-5.049-193.016-97.867-351.985-220.2-389.527 123.24-37.67 216.446-198.453 220.588-392.892zM531.16 450.445v352.632c117.674 1.553 211.787 40.778 211.787 88.676H304.097c0-48.286 95.149-87.382 213.728-88.676V450.445c-93.077-3.107-167.901-81.297-167.901-177.093 0-8.803 6.99-15.793 15.793-15.793 8.803 0 15.794 6.99 15.794 15.793 0 80.261 63.69 145.635 142.01 145.635s142.011-65.374 142.011-145.635c0-8.803 6.99-15.793 15.794-15.793s15.793 6.99 15.793 15.793c0 95.019-73.789 172.82-165.96 177.093z"></path></svg><span>About 32 min</span><meta property="timeRequired" content="PT32M"></span><!----><!----></div><hr></div><!----><div class="" vp-content><!----><div id="markdown-content"><h1 id="config-manual" tabindex="-1"><a class="header-anchor" href="#config-manual"><span>Config Manual</span></a></h1><h2 id="_1-iotdb-configuration-files" tabindex="-1"><a class="header-anchor" href="#_1-iotdb-configuration-files"><span>1. IoTDB Configuration Files</span></a></h2><p>The configuration files for IoTDB are located in the <code>conf</code> folder under the IoTDB installation directory. Key configuration files include:</p><ol><li><code>confignode-env.sh</code> <strong>/</strong> <code>confignode-env.bat</code>: <ol><li>Environment configuration file for ConfigNode.</li><li>Used to configure memory size and other environment settings for ConfigNode.</li></ol></li><li><code>datanode-env.sh</code> <strong>/</strong> <code>datanode-env.bat</code>: <ol><li>Environment configuration file for DataNode.</li><li>Used to configure memory size and other environment settings for DataNode.</li></ol></li><li><code>iotdb-system.properties</code>: <ol><li>Main configuration file for IoTDB.</li><li>Contains configurable parameters for IoTDB.</li></ol></li><li><code>iotdb-system.properties.template</code>: <ol><li>Template for the <code>iotdb-system.properties</code> file.</li><li>Provides a reference for all available configuration parameters.</li></ol></li></ol><h2 id="_2-modify-configurations" tabindex="-1"><a class="header-anchor" href="#_2-modify-configurations"><span>2. Modify Configurations</span></a></h2><h3 id="_2-1-modify-existing-parameters" tabindex="-1"><a class="header-anchor" href="#_2-1-modify-existing-parameters"><span>2.1 <strong>Modify Existing Parameters</strong>:</span></a></h3><ul><li>Parameters already present in the <code>iotdb-system.properties</code> file can be directly modified.</li></ul><h3 id="_2-2-adding-new-parameters" tabindex="-1"><a class="header-anchor" href="#_2-2-adding-new-parameters"><span>2.2 <strong>Adding New Parameters</strong>:</span></a></h3><ul><li>For parameters not listed in <code>iotdb-system.properties</code>, you can find them in the <code>iotdb-system.properties.template</code> file.</li><li>Copy the desired parameter from the template file to <code>iotdb-system.properties</code> and modify its value.</li></ul><h3 id="_2-3-configuration-update-methods" tabindex="-1"><a class="header-anchor" href="#_2-3-configuration-update-methods"><span>2.3 Configuration Update Methods</span></a></h3><p>Different configuration parameters have different update methods, categorized as follows:</p><ol><li><strong>Modify before the first startup.</strong>: <ol><li>These parameters can only be modified before the first startup of ConfigNode/DataNode.</li><li>Modifying them after the first startup will prevent ConfigNode/DataNode from starting.</li></ol></li><li><strong>Restart Required for Changes to Take Effect</strong>: <ol><li>These parameters can be modified after ConfigNode/DataNode has started.</li><li>However, a restart of ConfigNode/DataNode is required for the changes to take effect.</li></ol></li><li><strong>Hot Reload</strong>: <ol><li>These parameters can be modified while ConfigNode/DataNode is running.</li><li>After modification, use the following SQL commands to apply the changes: <ul><li><code>load configuration</code>: Reloads the configuration.</li><li><code>set configuration key1 = 'value1'</code>: Updates specific configuration parameters.</li></ul></li></ol></li></ol><h2 id="_3-environment-parameters" tabindex="-1"><a class="header-anchor" href="#_3-environment-parameters"><span>3. Environment Parameters</span></a></h2><p>The environment configuration files (<code>confignode-env.sh/bat</code> and <code>datanode-env.sh/bat</code>) are used to configure Java environment parameters for ConfigNode and DataNode, such as JVM settings. These configurations are passed to the JVM when ConfigNode or DataNode starts.</p><h3 id="_3-1-confignode-env-sh-bat" tabindex="-1"><a class="header-anchor" href="#_3-1-confignode-env-sh-bat"><span>3.1 <strong><a href="http://confignode-env.sh/bat" target="_blank" rel="noopener noreferrer">confignode-env.sh/bat</a></strong></span></a></h3><ul><li>MEMORY_SIZE</li></ul><table><thead><tr><th>Name</th><th>MEMORY_SIZE</th></tr></thead><tbody><tr><td>Description</td><td>Memory size allocated when IoTDB ConfigNode starts.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the operating system and machine configuration. Defaults to 3/10 of the machine's memory, capped at 16G.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>ON_HEAP_MEMORY</li></ul><table><thead><tr><th>Name</th><th>ON_HEAP_MEMORY</th></tr></thead><tbody><tr><td>Description</td><td>On-heap memory size available for IoTDB ConfigNode. Previously named <code>MAX_HEAP_SIZE</code>.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the <code>MEMORY_SIZE</code> configuration.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>OFF_HEAP_MEMORY</li></ul><table><thead><tr><th>Name</th><th>OFF_HEAP_MEMORY</th></tr></thead><tbody><tr><td>Description</td><td>Off-heap memory size available for IoTDB ConfigNode. Previously named <code>MAX_DIRECT_MEMORY_SIZE</code>.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the <code>MEMORY_SIZE</code> configuration.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><h3 id="_3-2-datanode-env-sh-bat" tabindex="-1"><a class="header-anchor" href="#_3-2-datanode-env-sh-bat"><span>3.2 <strong><a href="http://datanode-env.sh/bat" target="_blank" rel="noopener noreferrer">datanode-env.sh/bat</a></strong></span></a></h3><ul><li>MEMORY_SIZE</li></ul><table><thead><tr><th>Name</th><th>MEMORY_SIZE</th></tr></thead><tbody><tr><td>Description</td><td>Memory size allocated when IoTDB DataNode starts.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the operating system and machine configuration. Defaults to 1/2 of the machine's memory.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>ON_HEAP_MEMORY</li></ul><table><thead><tr><th>Name</th><th>ON_HEAP_MEMORY</th></tr></thead><tbody><tr><td>Description</td><td>On-heap memory size available for IoTDB DataNode. Previously named <code>MAX_HEAP_SIZE</code>.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the <code>MEMORY_SIZE</code> configuration.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>OFF_HEAP_MEMORY</li></ul><table><thead><tr><th>Name</th><th>OFF_HEAP_MEMORY</th></tr></thead><tbody><tr><td>Description</td><td>Off-heap memory size available for IoTDB DataNode. Previously named <code>MAX_DIRECT_MEMORY_SIZE</code>.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>Depends on the <code>MEMORY_SIZE</code> configuration.</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><h2 id="_4-system-parameters-iotdb-system-properties-template" tabindex="-1"><a class="header-anchor" href="#_4-system-parameters-iotdb-system-properties-template"><span>4. System Parameters (<code>iotdb-system.properties.template</code>）</span></a></h2><p>The <code>iotdb-system.properties</code> file contains various configurations for managing IoTDB clusters, nodes, replication, directories, monitoring, SSL, connections, object storage, tier management, and REST services. Below is a detailed breakdown of the parameters:</p><h3 id="_4-1-cluster-configuration" tabindex="-1"><a class="header-anchor" href="#_4-1-cluster-configuration"><span>4.1 Cluster Configuration</span></a></h3><ul><li>cluster_name</li></ul><table><thead><tr><th>Name</th><th>cluster_name</th></tr></thead><tbody><tr><td>Description</td><td>Name of the cluster.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>default_cluster</td></tr><tr><td>Effective</td><td>Use CLI: <code>set configuration cluster_name='xxx'</code>.</td></tr><tr><td>Note</td><td>Changes are distributed across nodes. Changes may not propagate to all nodes in case of network issues or node failures. Nodes that fail to update must manually modify <code>cluster_name</code> in their configuration files and restart. Under normal circumstances, it is not recommended to modify <code>cluster_name</code> by manually modifying configuration files or to perform hot-loading via <code>load configuration</code> method.</td></tr></tbody></table><h3 id="_4-2-seed-confignode" tabindex="-1"><a class="header-anchor" href="#_4-2-seed-confignode"><span>4.2 Seed ConfigNode</span></a></h3><ul><li>cn_seed_config_node</li></ul><table><thead><tr><th>Name</th><th>cn_seed_config_node</th></tr></thead><tbody><tr><td>Description</td><td>Address of the seed ConfigNode for Confignode to join the cluster.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>127.0.0.1:10710</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_seed_config_node</li></ul><table><thead><tr><th>Name</th><th>dn_seed_config_node</th></tr></thead><tbody><tr><td>Description</td><td>Address of the seed ConfigNode for Datanode to join the cluster.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>127.0.0.1:10710</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><h3 id="_4-3-node-rpc-configuration" tabindex="-1"><a class="header-anchor" href="#_4-3-node-rpc-configuration"><span>4.3 Node RPC Configuration</span></a></h3><ul><li>cn_internal_address</li></ul><table><thead><tr><th>Name</th><th>cn_internal_address</th></tr></thead><tbody><tr><td>Description</td><td>Internal address for ConfigNode communication.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>127.0.0.1</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>cn_internal_port</li></ul><table><thead><tr><th>Name</th><th>cn_internal_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for ConfigNode internal communication.</td></tr><tr><td>Type</td><td>Short Int : [0,65535]</td></tr><tr><td>Default</td><td>10710</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>cn_consensus_port</li></ul><table><thead><tr><th>Name</th><th>cn_consensus_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for ConfigNode consensus protocol communication.</td></tr><tr><td>Type</td><td>Short Int : [0,65535]</td></tr><tr><td>Default</td><td>10720</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_rpc_address</li></ul><table><thead><tr><th>Name</th><th>dn_rpc_address</th></tr></thead><tbody><tr><td>Description</td><td>Address for client RPC service.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>127.0.0.1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_rpc_port</li></ul><table><thead><tr><th>Name</th><th>dn_rpc_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for client RPC service.</td></tr><tr><td>Type</td><td>Short Int : [0,65535]</td></tr><tr><td>Default</td><td>6667</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_internal_address</li></ul><table><thead><tr><th>Name</th><th>dn_internal_address</th></tr></thead><tbody><tr><td>Description</td><td>Internal address for DataNode communication.</td></tr><tr><td>Type</td><td>string</td></tr><tr><td>Default</td><td>127.0.0.1</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_internal_port</li></ul><table><thead><tr><th>Name</th><th>dn_internal_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for DataNode internal communication.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10730</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_mpp_data_exchange_port</li></ul><table><thead><tr><th>Name</th><th>dn_mpp_data_exchange_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for MPP data exchange.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10740</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_schema_region_consensus_port</li></ul><table><thead><tr><th>Name</th><th>dn_schema_region_consensus_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for Datanode SchemaRegion consensus protocol communication.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10750</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_data_region_consensus_port</li></ul><table><thead><tr><th>Name</th><th>dn_data_region_consensus_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for Datanode DataRegion consensus protocol communication.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10760</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>dn_join_cluster_retry_interval_ms</li></ul><table><thead><tr><th>Name</th><th>dn_join_cluster_retry_interval_ms</th></tr></thead><tbody><tr><td>Description</td><td>Interval for DataNode to retry joining the cluster.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>5000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-4-replication-configuration" tabindex="-1"><a class="header-anchor" href="#_4-4-replication-configuration"><span>4.4 Replication configuration</span></a></h3><ul><li>config_node_consensus_protocol_class</li></ul><table><thead><tr><th>Name</th><th>config_node_consensus_protocol_class</th></tr></thead><tbody><tr><td>Description</td><td>Consensus protocol for ConfigNode replication, only supports RatisConsensus</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.consensus.ratis.RatisConsensus</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>schema_replication_factor</li></ul><table><thead><tr><th>Name</th><th>schema_replication_factor</th></tr></thead><tbody><tr><td>Description</td><td>Default schema replication factor for databases.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required. Takes effect on the new database after restarting.</td></tr></tbody></table><ul><li>schema_region_consensus_protocol_class</li></ul><table><thead><tr><th>Name</th><th>schema_region_consensus_protocol_class</th></tr></thead><tbody><tr><td>Description</td><td>Consensus protocol for schema region replication. Only supports RatisConsensus when multi-replications.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.consensus.ratis.RatisConsensus</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>data_replication_factor</li></ul><table><thead><tr><th>Name</th><th>data_replication_factor</th></tr></thead><tbody><tr><td>Description</td><td>Default data replication factor for databases.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required. Takes effect on the new database after restarting.</td></tr></tbody></table><ul><li>data_region_consensus_protocol_class</li></ul><table><thead><tr><th>Name</th><th>data_region_consensus_protocol_class</th></tr></thead><tbody><tr><td>Description</td><td>Consensus protocol for data region replication. Supports IoTConsensus or RatisConsensus when multi-replications.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.consensus.iot.IoTConsensus</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><h3 id="_4-5-directory-configuration" tabindex="-1"><a class="header-anchor" href="#_4-5-directory-configuration"><span>4.5 Directory configuration</span></a></h3><ul><li>cn_system_dir</li></ul><table><thead><tr><th>Name</th><th>cn_system_dir</th></tr></thead><tbody><tr><td>Description</td><td>System data storage path for ConfigNode.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/confignode/system（Windows：data\configndoe\system）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>cn_consensus_dir</li></ul><table><thead><tr><th>Name</th><th>cn_consensus_dir</th></tr></thead><tbody><tr><td>Description</td><td>Consensus protocol data storage path for ConfigNode.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/confignode/consensus（Windows：data\configndoe\consensus）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>cn_pipe_receiver_file_dir</li></ul><table><thead><tr><th>Name</th><th>cn_pipe_receiver_file_dir</th></tr></thead><tbody><tr><td>Description</td><td>Directory for pipe receiver files in ConfigNode.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/confignode/system/pipe/receiver（Windows：data\confignode\system\pipe\receiver）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_system_dir</li></ul><table><thead><tr><th>Name</th><th>dn_system_dir</th></tr></thead><tbody><tr><td>Description</td><td>Schema storage path for DataNode. By default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/system（Windows：data\datanode\system）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_data_dirs</li></ul><table><thead><tr><th>Name</th><th>dn_data_dirs</th></tr></thead><tbody><tr><td>Description</td><td>Data storage path for DataNode. By default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/data（Windows：data\datanode\data）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_multi_dir_strategy</li></ul><table><thead><tr><th>Name</th><th>dn_multi_dir_strategy</th></tr></thead><tbody><tr><td>Description</td><td>The strategy used by IoTDB to select directories in <code>data_dirs</code> for TsFiles. You can use either the simple class name or the fully qualified class name. The system provides the following two strategies: 1. SequenceStrategy: IoTDB selects directories sequentially, iterating through all directories in <code>data_dirs</code> in a round-robin manner. 2. MaxDiskUsableSpaceFirstStrategy IoTDB prioritizes the directory in <code>data_dirs</code> with the largest disk free space. To implement a custom strategy: 1. Inherit the <code>org.apache.iotdb.db.storageengine.rescon.disk.strategy.DirectoryStrategy </code>class and implement your own strategy method. 2. Fill in the configuration item with the fully qualified class name of your implementation (package name + class name, e.g., <code>UserDefineStrategyPackage</code>). 3. Add the JAR file containing your custom class to the project.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>SequenceStrategy</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><ul><li>dn_consensus_dir</li></ul><table><thead><tr><th>Name</th><th>dn_consensus_dir</th></tr></thead><tbody><tr><td>Description</td><td>Consensus log storage path for DataNode. By default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/consensus（Windows：data\datanode\consensus）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_wal_dirs</li></ul><table><thead><tr><th>Name</th><th>dn_wal_dirs</th></tr></thead><tbody><tr><td>Description</td><td>Write-ahead log (WAL) storage path for DataNode. By default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/wal（Windows：data\datanode\wal）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_tracing_dir</li></ul><table><thead><tr><th>Name</th><th>dn_tracing_dir</th></tr></thead><tbody><tr><td>Description</td><td>Tracing root directory for DataNode. By default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>datanode/tracing（Windows：datanode\tracing）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_sync_dir</li></ul><table><thead><tr><th>Name</th><th>dn_sync_dir</th></tr></thead><tbody><tr><td>Description</td><td>Sync storage path for <a href="http://DataNode.By" target="_blank" rel="noopener noreferrer">DataNode.By</a> default, it is stored in the data directory at the same level as the sbin directory. The starting directory of the relative path is related to the operating system. It is recommended to use an absolute path.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/sync（Windows：data\datanode\sync）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>sort_tmp_dir</li></ul><table><thead><tr><th>Name</th><th>sort_tmp_dir</th></tr></thead><tbody><tr><td>Description</td><td>Temporary directory for sorting operations.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/tmp（Windows：data\datanode\tmp）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>dn_pipe_receiver_file_dirs</li></ul><table><thead><tr><th>Name</th><th>dn_pipe_receiver_file_dirs</th></tr></thead><tbody><tr><td>Description</td><td>Directory for pipe receiver files in DataNode.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/system/pipe/receiver（Windows：data\datanode\system\pipe\receiver）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>iot_consensus_v2_receiver_file_dirs</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_v2_receiver_file_dirs</th></tr></thead><tbody><tr><td>Description</td><td>Directory for IoTConsensus V2 receiver files.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/system/pipe/consensus/receiver（Windows：data\datanode\system\pipe\consensus\receiver）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><ul><li>iot_consensus_v2_deletion_file_dir</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_v2_deletion_file_dir</th></tr></thead><tbody><tr><td>Description</td><td>Directory for IoTConsensus V2 deletion files.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/system/pipe/consensus/deletion（Windows：data\datanode\system\pipe\consensus\deletion）</td></tr><tr><td>Effective</td><td>Restart required</td></tr></tbody></table><h3 id="_4-6-metric-configuration" tabindex="-1"><a class="header-anchor" href="#_4-6-metric-configuration"><span>4.6 Metric Configuration</span></a></h3><ul><li>cn_metric_reporter_list</li></ul><table><thead><tr><th>Name</th><th>cn_metric_reporter_list</th></tr></thead><tbody><tr><td>Description</td><td>Systems for reporting ConfigNode metrics.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_metric_level</li></ul><table><thead><tr><th>Name</th><th>cn_metric_level</th></tr></thead><tbody><tr><td>Description</td><td>Level of detail for ConfigNode metrics.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>IMPORTANT</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_metric_async_collect_period</li></ul><table><thead><tr><th>Name</th><th>cn_metric_async_collect_period</th></tr></thead><tbody><tr><td>Description</td><td>Period for asynchronous metric collection in ConfigNode (in seconds).</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_metric_prometheus_reporter_port</li></ul><table><thead><tr><th>Name</th><th>cn_metric_prometheus_reporter_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for Prometheus metric reporting in ConfigNode.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>9091</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_metric_reporter_list</li></ul><table><thead><tr><th>Name</th><th>dn_metric_reporter_list</th></tr></thead><tbody><tr><td>Description</td><td>Systems for reporting DataNode metrics.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_metric_level</li></ul><table><thead><tr><th>Name</th><th>dn_metric_level</th></tr></thead><tbody><tr><td>Description</td><td>Level of detail for DataNode metrics.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>IMPORTANT</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_metric_async_collect_period</li></ul><table><thead><tr><th>Name</th><th>dn_metric_async_collect_period</th></tr></thead><tbody><tr><td>Description</td><td>Period for asynchronous metric collection in DataNode (in seconds).</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_metric_prometheus_reporter_port</li></ul><table><thead><tr><th>Name</th><th>dn_metric_prometheus_reporter_port</th></tr></thead><tbody><tr><td>Description</td><td>Port for Prometheus metric reporting in DataNode.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>9092</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_metric_internal_reporter_type</li></ul><table><thead><tr><th>Name</th><th>dn_metric_internal_reporter_type</th></tr></thead><tbody><tr><td>Description</td><td>Internal reporter types for DataNode metrics. For internal monitoring and checking that the data has been successfully written and refreshed.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>IOTDB</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-7-ssl-configuration" tabindex="-1"><a class="header-anchor" href="#_4-7-ssl-configuration"><span>4.7 SSL Configuration</span></a></h3><ul><li>enable_thrift_ssl</li></ul><table><thead><tr><th>Name</th><th>enable_thrift_ssl</th></tr></thead><tbody><tr><td>Description</td><td>Enables SSL encryption for RPC communication.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_https</li></ul><table><thead><tr><th>Name</th><th>enable_https</th></tr></thead><tbody><tr><td>Description</td><td>Enables SSL for REST services.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>key_store_path</li></ul><table><thead><tr><th>Name</th><th>key_store_path</th></tr></thead><tbody><tr><td>Description</td><td>Path to the SSL certificate.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>key_store_pwd</li></ul><table><thead><tr><th>Name</th><th>key_store_pwd</th></tr></thead><tbody><tr><td>Description</td><td>Password for the SSL certificate.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-8-connection-configuration" tabindex="-1"><a class="header-anchor" href="#_4-8-connection-configuration"><span>4.8 Connection Configuration</span></a></h3><ul><li>cn_rpc_thrift_compression_enable</li></ul><table><thead><tr><th>Name</th><th>cn_rpc_thrift_compression_enable</th></tr></thead><tbody><tr><td>Description</td><td>Enables Thrift compression for RPC.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_rpc_max_concurrent_client_num</li></ul><table><thead><tr><th>Name</th><th>cn_rpc_max_concurrent_client_num</th></tr></thead><tbody><tr><td>Description</td><td>Maximum number of concurrent RPC clients.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>3000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_connection_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>cn_connection_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>Connection timeout for ConfigNode (in milliseconds).</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>60000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_selector_thread_nums_of_client_manager</li></ul><table><thead><tr><th>Name</th><th>cn_selector_thread_nums_of_client_manager</th></tr></thead><tbody><tr><td>Description</td><td>Number of selector threads for client management in ConfigNode.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cn_max_client_count_for_each_node_in_client_manager</li></ul><table><thead><tr><th>Name</th><th>cn_max_client_count_for_each_node_in_client_manager</th></tr></thead><tbody><tr><td>Description</td><td>Maximum clients per node in ConfigNode client manager.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>300</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_session_timeout_threshold</li></ul><table><thead><tr><th>Name</th><th>dn_session_timeout_threshold</th></tr></thead><tbody><tr><td>Description</td><td>Maximum idle time for DataNode sessions.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.t required.</td></tr></tbody></table><ul><li>dn_rpc_thrift_compression_enable</li></ul><table><thead><tr><th>Name</th><th>dn_rpc_thrift_compression_enable</th></tr></thead><tbody><tr><td>Description</td><td>Enables Thrift compression for DataNode RPC.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_rpc_advanced_compression_enable</li></ul><table><thead><tr><th>Name</th><th>dn_rpc_advanced_compression_enable</th></tr></thead><tbody><tr><td>Description</td><td>Enables advanced Thrift compression for DataNode RPC.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_rpc_selector_thread_count</li></ul><table><thead><tr><th>Name</th><th>rpc_selector_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>Number of selector threads for DataNode RPC.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.t required.</td></tr></tbody></table><ul><li>dn_rpc_min_concurrent_client_num</li></ul><table><thead><tr><th>Name</th><th>rpc_min_concurrent_client_num</th></tr></thead><tbody><tr><td>Description</td><td>Minimum number of concurrent RPC clients for DataNode.</td></tr><tr><td>Type</td><td>Short Int : [0,65535]</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_rpc_max_concurrent_client_num</li></ul><table><thead><tr><th>Name</th><th>dn_rpc_max_concurrent_client_num</th></tr></thead><tbody><tr><td>Description</td><td>Maximum number of concurrent RPC clients for DataNode.</td></tr><tr><td>Type</td><td>Short Int : [0,65535]</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_thrift_max_frame_size</li></ul><table><thead><tr><th>Name</th><th>dn_thrift_max_frame_size</th></tr></thead><tbody><tr><td>Description</td><td>Maximum frame size for RPC requests/responses.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>Defaults to 0, which means the value is automatically calculated based on the DN JVM configuration parameters at startup:<br>a. min(64MB, dn_alloc_memory/64)<br>b. If the user manually configures <code>dn_thrift_max_frame_size</code>, the user-specified value will be used instead.</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_thrift_init_buffer_size</li></ul><table><thead><tr><th>Name</th><th>dn_thrift_init_buffer_size</th></tr></thead><tbody><tr><td>Description</td><td>Initial buffer size for Thrift RPC.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>1024</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_connection_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>dn_connection_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>Connection timeout for DataNode (in milliseconds).</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>60000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>dn_selector_thread_count_of_client_manager</li></ul><table><thead><tr><th>Name</th><th>dn_selector_thread_count_of_client_manager</th></tr></thead><tbody><tr><td>Description</td><td>selector thread (TAsyncClientManager) nums for async thread in a clientManager</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.t required.</td></tr></tbody></table><ul><li>dn_max_client_count_for_each_node_in_client_manager</li></ul><table><thead><tr><th>Name</th><th>dn_max_client_count_for_each_node_in_client_manager</th></tr></thead><tbody><tr><td>Description</td><td>Maximum clients per node in DataNode clientmanager.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>300</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-9-object-storage-management" tabindex="-1"><a class="header-anchor" href="#_4-9-object-storage-management"><span>4.9 Object storage management</span></a></h3><ul><li>remote_tsfile_cache_dirs</li></ul><table><thead><tr><th>Name</th><th>remote_tsfile_cache_dirs</th></tr></thead><tbody><tr><td>Description</td><td>Local cache directory for cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>data/datanode/data/cache</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>remote_tsfile_cache_page_size_in_kb</li></ul><table><thead><tr><th>Name</th><th>remote_tsfile_cache_page_size_in_kb</th></tr></thead><tbody><tr><td>Description</td><td>Block size for cached files in cloud storage.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>20480</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>remote_tsfile_cache_max_disk_usage_in_mb</li></ul><table><thead><tr><th>Name</th><th>remote_tsfile_cache_max_disk_usage_in_mb</th></tr></thead><tbody><tr><td>Description</td><td>Maximum disk usage for cloud storage cache.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>51200</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>object_storage_type</li></ul><table><thead><tr><th>Name</th><th>object_storage_type</th></tr></thead><tbody><tr><td>Description</td><td>Type of cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>AWS_S3</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>object_storage_endpoint</li></ul><table><thead><tr><th>Name</th><th>object_storage_endpoint</th></tr></thead><tbody><tr><td>Description</td><td>Endpoint for cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>object_storage_bucket</li></ul><table><thead><tr><th>Name</th><th>object_storage_bucket</th></tr></thead><tbody><tr><td>Description</td><td>Bucket name for cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>iotdb_data</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>object_storage_access_key</li></ul><table><thead><tr><th>Name</th><th>object_storage_access_key</th></tr></thead><tbody><tr><td>Description</td><td>Access key for cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>object_storage_access_secret</li></ul><table><thead><tr><th>Name</th><th>object_storage_access_secret</th></tr></thead><tbody><tr><td>Description</td><td>Access secret for cloud storage.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-10-tier-management" tabindex="-1"><a class="header-anchor" href="#_4-10-tier-management"><span>4.10 Tier management</span></a></h3><ul><li>dn_default_space_usage_thresholds</li></ul><table><thead><tr><th>Name</th><th>dn_default_space_usage_thresholds</th></tr></thead><tbody><tr><td>Description</td><td>Disk usage threshold, data will be moved to the next tier when the usage of the tier is higher than this threshold.If tiered storage is enabled, please separate thresholds of different tiers by semicolons ";".</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>0.85</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><ul><li>dn_tier_full_policy</li></ul><table><thead><tr><th>Name</th><th>dn_tier_full_policy</th></tr></thead><tbody><tr><td>Description</td><td>How to deal with the last tier's data when its used space has been higher than its dn_default_space_usage_thresholds.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>NULL</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><ul><li>migrate_thread_count</li></ul><table><thead><tr><th>Name</th><th>migrate_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>thread pool size for migrate operation in the DataNode's data directories.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><ul><li>tiered_storage_migrate_speed_limit_bytes_per_sec</li></ul><table><thead><tr><th>Name</th><th>tiered_storage_migrate_speed_limit_bytes_per_sec</th></tr></thead><tbody><tr><td>Description</td><td>The migrate speed limit of different tiers can reach per second</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10485760</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><h3 id="_4-11-rest-service-configuration" tabindex="-1"><a class="header-anchor" href="#_4-11-rest-service-configuration"><span>4.11 REST Service Configuration</span></a></h3><ul><li>enable_rest_service</li></ul><table><thead><tr><th>Name</th><th>enable_rest_service</th></tr></thead><tbody><tr><td>Description</td><td>Is the REST service enabled</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>rest_service_port</li></ul><table><thead><tr><th>Name</th><th>rest_service_port</th></tr></thead><tbody><tr><td>Description</td><td>the binding port of the REST service</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>18080</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_swagger</li></ul><table><thead><tr><th>Name</th><th>enable_swagger</th></tr></thead><tbody><tr><td>Description</td><td>Whether to display rest service interface information through swagger. eg: <a href="http://ip" target="_blank" rel="noopener noreferrer">http://ip</a>:port/swagger.json</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>rest_query_default_row_size_limit</li></ul><table><thead><tr><th>Name</th><th>rest_query_default_row_size_limit</th></tr></thead><tbody><tr><td>Description</td><td>the default row limit to a REST query response when the rowSize parameter is not given in request</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cache_expire_in_seconds</li></ul><table><thead><tr><th>Name</th><th>cache_expire_in_seconds</th></tr></thead><tbody><tr><td>Description</td><td>The expiration time of the user login information cache (in seconds)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>28800</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cache_max_num</li></ul><table><thead><tr><th>Name</th><th>cache_max_num</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of users can be stored in the user login cache.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cache_init_num</li></ul><table><thead><tr><th>Name</th><th>cache_init_num</th></tr></thead><tbody><tr><td>Description</td><td>The initial capacity of users can be stored in the user login cache.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>client_auth</li></ul><table><thead><tr><th>Name</th><th>client_auth</th></tr></thead><tbody><tr><td>Description</td><td>Is client authentication required</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>trust_store_path</li></ul><table><thead><tr><th>Name</th><th>trust_store_path</th></tr></thead><tbody><tr><td>Description</td><td>SSL trust store path</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>""</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>trust_store_pwd</li></ul><table><thead><tr><th>Name</th><th>trust_store_pwd</th></tr></thead><tbody><tr><td>Description</td><td>SSL trust store password.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>""</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>idle_timeout_in_seconds</li></ul><table><thead><tr><th>Name</th><th>idle_timeout_in_seconds</th></tr></thead><tbody><tr><td>Description</td><td>SSL timeout (in seconds)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>5000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-12-load-balancing-configuration" tabindex="-1"><a class="header-anchor" href="#_4-12-load-balancing-configuration"><span>4.12 Load balancing configuration</span></a></h3><ul><li>series_slot_num</li></ul><table><thead><tr><th>Name</th><th>series_slot_num</th></tr></thead><tbody><tr><td>Description</td><td>Number of SeriesPartitionSlots per Database</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>series_partition_executor_class</li></ul><table><thead><tr><th>Name</th><th>series_partition_executor_class</th></tr></thead><tbody><tr><td>Description</td><td>SeriesPartitionSlot executor class</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.commons.partition.executor.hash.BKDRHashExecutor</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>schema_region_group_extension_policy</li></ul><table><thead><tr><th>Name</th><th>schema_region_group_extension_policy</th></tr></thead><tbody><tr><td>Description</td><td>The policy of extension SchemaRegionGroup for each Database.</td></tr><tr><td>Type</td><td>string</td></tr><tr><td>Default</td><td>AUTO</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>default_schema_region_group_num_per_database</li></ul><table><thead><tr><th>Name</th><th>default_schema_region_group_num_per_database</th></tr></thead><tbody><tr><td>Description</td><td>When set schema_region_group_extension_policy=CUSTOM, this parameter is the default number of SchemaRegionGroups for each Database.When set schema_region_group_extension_policy=AUTO, this parameter is the default minimal number of SchemaRegionGroups for each Database.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_per_data_node</li></ul><table><thead><tr><th>Name</th><th>schema_region_per_data_node</th></tr></thead><tbody><tr><td>Description</td><td>It only takes effect when set schema_region_group_extension_policy=AUTO.This parameter is the maximum number of SchemaRegions expected to be managed by each DataNode.</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>1.0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_group_extension_policy</li></ul><table><thead><tr><th>Name</th><th>data_region_group_extension_policy</th></tr></thead><tbody><tr><td>Description</td><td>The policy of extension DataRegionGroup for each Database.</td></tr><tr><td>Type</td><td>string</td></tr><tr><td>Default</td><td>AUTO</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>default_data_region_group_num_per_database</li></ul><table><thead><tr><th>Name</th><th>default_data_region_group_per_database</th></tr></thead><tbody><tr><td>Description</td><td>When set data_region_group_extension_policy=CUSTOM, this parameter is the default number of DataRegionGroups for each Database.When set data_region_group_extension_policy=AUTO, this parameter is the default minimal number of DataRegionGroups for each Database.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>2</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_per_data_node</li></ul><table><thead><tr><th>Name</th><th>data_region_per_data_node</th></tr></thead><tbody><tr><td>Description</td><td>It only takes effect when set data_region_group_extension_policy=AUTO.This parameter is the maximum number of DataRegions expected to be managed by each DataNode.</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>5.0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_auto_leader_balance_for_ratis_consensus</li></ul><table><thead><tr><th>Name</th><th>enable_auto_leader_balance_for_ratis_consensus</th></tr></thead><tbody><tr><td>Description</td><td>Whether to enable auto leader balance for Ratis consensus protocol.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_auto_leader_balance_for_iot_consensus</li></ul><table><thead><tr><th>Name</th><th>enable_auto_leader_balance_for_iot_consensus</th></tr></thead><tbody><tr><td>Description</td><td>Whether to enable auto leader balance for IoTConsensus protocol.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-13-cluster-management" tabindex="-1"><a class="header-anchor" href="#_4-13-cluster-management"><span>4.13 Cluster management</span></a></h3><ul><li>time_partition_origin</li></ul><table><thead><tr><th>Name</th><th>time_partition_origin</th></tr></thead><tbody><tr><td>Description</td><td>Time partition origin in milliseconds, default is equal to zero.</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Unit</td><td>ms</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>time_partition_interval</li></ul><table><thead><tr><th>Name</th><th>time_partition_interval</th></tr></thead><tbody><tr><td>Description</td><td>Time partition interval in milliseconds, and partitioning data inside each data region, default is equal to one week</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Unit</td><td>ms</td></tr><tr><td>Default</td><td>604800000</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>heartbeat_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>heartbeat_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The heartbeat interval in milliseconds</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Unit</td><td>ms</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>disk_space_warning_threshold</li></ul><table><thead><tr><th>Name</th><th>disk_space_warning_threshold</th></tr></thead><tbody><tr><td>Description</td><td>Disk remaining threshold at which DataNode is set to ReadOnly status</td></tr><tr><td>Type</td><td>double(percentage)</td></tr><tr><td>Default</td><td>0.05</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-14-memory-control-configuration" tabindex="-1"><a class="header-anchor" href="#_4-14-memory-control-configuration"><span>4.14 Memory Control Configuration</span></a></h3><ul><li>datanode_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>datanode_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Memory Allocation Ratio: StorageEngine, QueryEngine, SchemaEngine, Consensus, StreamingEngine and Free Memory.</td></tr><tr><td>Type</td><td>Ratio</td></tr><tr><td>Default</td><td>3:3:1:1:1:1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>schema_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Schema Memory Allocation Ratio: SchemaRegion, SchemaCache, and PartitionCache.</td></tr><tr><td>Type</td><td>Ratio</td></tr><tr><td>Default</td><td>5:4:1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>storage_engine_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>storage_engine_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Memory allocation ratio in StorageEngine: Write, Compaction</td></tr><tr><td>Type</td><td>Ratio</td></tr><tr><td>Default</td><td>8:2</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>write_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>write_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Memory allocation ratio in writing: Memtable, TimePartitionInfo</td></tr><tr><td>Type</td><td>Ratio</td></tr><tr><td>Default</td><td>19:1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>primitive_array_size</li></ul><table><thead><tr><th>Name</th><th>primitive_array_size</th></tr></thead><tbody><tr><td>Description</td><td>primitive array size (length of each array) in array pool</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>64</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>chunk_metadata_size_proportion</li></ul><table><thead><tr><th>Name</th><th>chunk_metadata_size_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Ratio of compaction memory for chunk metadata maintains in memory when doing compaction</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>flush_proportion</li></ul><table><thead><tr><th>Name</th><th>flush_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Ratio of memtable memory for invoking flush disk, 0.4 by defaultIf you have extremely high write load (like batch=1000), it can be set lower than the default value like 0.2</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.4</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>buffered_arrays_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>buffered_arrays_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Ratio of memtable memory allocated for buffered arrays, 0.6 by default</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.6</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>reject_proportion</li></ul><table><thead><tr><th>Name</th><th>reject_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Ratio of memtable memory for rejecting insertion, 0.8 by defaultIf you have extremely high write load (like batch=1000) and the physical memory size is large enough, it can be set higher than the default value like 0.9</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.8</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>device_path_cache_proportion</li></ul><table><thead><tr><th>Name</th><th>device_path_cache_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Ratio of memtable memory for the DevicePathCache. DevicePathCache is the deviceId cache, keeping only one copy of the same deviceId in memory</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.05</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>write_memory_variation_report_proportion</li></ul><table><thead><tr><th>Name</th><th>write_memory_variation_report_proportion</th></tr></thead><tbody><tr><td>Description</td><td>If memory cost of data region increased more than proportion of allocated memory for writing, report to system. The default value is 0.001</td></tr><tr><td>Type</td><td>Double</td></tr><tr><td>Default</td><td>0.001</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>check_period_when_insert_blocked</li></ul><table><thead><tr><th>Name</th><th>check_period_when_insert_blocked</th></tr></thead><tbody><tr><td>Description</td><td>When an insertion is rejected, the waiting period (in ms) to check system again, 50 by default.If the insertion has been rejected and the read load is low, it can be set larger.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>50</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>io_task_queue_size_for_flushing</li></ul><table><thead><tr><th>Name</th><th>io_task_queue_size_for_flushing</th></tr></thead><tbody><tr><td>Description</td><td>size of ioTaskQueue. The default value is 10</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_query_memory_estimation</li></ul><table><thead><tr><th>Name</th><th>enable_query_memory_estimation</th></tr></thead><tbody><tr><td>Description</td><td>If true, we will estimate each query's possible memory footprint before executing it and deny it if its estimated memory exceeds current free memory</td></tr><tr><td>Type</td><td>bool</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload.</td></tr></tbody></table><h3 id="_4-15-schema-engine-configuration" tabindex="-1"><a class="header-anchor" href="#_4-15-schema-engine-configuration"><span>4.15 Schema Engine Configuration</span></a></h3><ul><li>schema_engine_mode</li></ul><table><thead><tr><th>Name</th><th>schema_engine_mode</th></tr></thead><tbody><tr><td>Description</td><td>The schema management mode of schema engine. Currently, support Memory and PBTree.This config of all DataNodes in one cluster must keep same.</td></tr><tr><td>Type</td><td>string</td></tr><tr><td>Default</td><td>Memory</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>partition_cache_size</li></ul><table><thead><tr><th>Name</th><th>partition_cache_size</th></tr></thead><tbody><tr><td>Description</td><td>cache size for partition.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>sync_mlog_period_in_ms</li></ul><table><thead><tr><th>Name</th><th>sync_mlog_period_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The cycle when metadata log is periodically forced to be written to disk(in milliseconds)If sync_mlog_period_in_ms=0 it means force metadata log to be written to disk after each refreshmentSetting this parameter to 0 may slow down the operation on slow disk.</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>100</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>tag_attribute_flush_interval</li></ul><table><thead><tr><th>Name</th><th>tag_attribute_flush_interval</th></tr></thead><tbody><tr><td>Description</td><td>interval num for tag and attribute records when force flushing to disk</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>tag_attribute_total_size</li></ul><table><thead><tr><th>Name</th><th>tag_attribute_total_size</th></tr></thead><tbody><tr><td>Description</td><td>max size for a storage block for tags and attributes of a one-time series</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>700</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>max_measurement_num_of_internal_request</li></ul><table><thead><tr><th>Name</th><th>max_measurement_num_of_internal_request</th></tr></thead><tbody><tr><td>Description</td><td>max measurement num of internal requestWhen creating timeseries with Session.createMultiTimeseries, the user input plan, the timeseries num ofwhich exceeds this num, will be split to several plans with timeseries no more than this num.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>datanode_schema_cache_eviction_policy</li></ul><table><thead><tr><th>Name</th><th>datanode_schema_cache_eviction_policy</th></tr></thead><tbody><tr><td>Description</td><td>Policy of DataNodeSchemaCache eviction.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>FIFO</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cluster_timeseries_limit_threshold</li></ul><table><thead><tr><th>Name</th><th>cluster_timeseries_limit_threshold</th></tr></thead><tbody><tr><td>Description</td><td>This configuration parameter sets the maximum number of time series allowed in the cluster.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cluster_device_limit_threshold</li></ul><table><thead><tr><th>Name</th><th>cluster_device_limit_threshold</th></tr></thead><tbody><tr><td>Description</td><td>This configuration parameter sets the maximum number of devices allowed in the cluster.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>database_limit_threshold</li></ul><table><thead><tr><th>Name</th><th>database_limit_threshold</th></tr></thead><tbody><tr><td>Description</td><td>This configuration parameter sets the maximum number of Cluster Databases allowed.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-16-configurations-for-creating-schema-automatically" tabindex="-1"><a class="header-anchor" href="#_4-16-configurations-for-creating-schema-automatically"><span>4.16 Configurations for creating schema automatically</span></a></h3><ul><li>enable_auto_create_schema</li></ul><table><thead><tr><th>Name</th><th>enable_auto_create_schema</th></tr></thead><tbody><tr><td>Description</td><td>Whether creating schema automatically is enabled</td></tr><tr><td>Value</td><td>true or false</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>default_storage_group_level</li></ul><table><thead><tr><th>Name</th><th>default_storage_group_level</th></tr></thead><tbody><tr><td>Description</td><td>Database level when creating schema automatically is enabled e.g. root.sg0.d1.s2We will set root.sg0 as the database if database level is 1If the incoming path is shorter than this value, the creation/insertion will fail.</td></tr><tr><td>Value</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>boolean_string_infer_type</li></ul><table><thead><tr><th>Name</th><th>boolean_string_infer_type</th></tr></thead><tbody><tr><td>Description</td><td>register time series as which type when receiving boolean string "true" or "false"</td></tr><tr><td>Value</td><td>BOOLEAN or TEXT</td></tr><tr><td>Default</td><td>BOOLEAN</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>integer_string_infer_type</li></ul><table><thead><tr><th>Name</th><th>integer_string_infer_type</th></tr></thead><tbody><tr><td>Description</td><td>register time series as which type when receiving an integer string and using float or double may lose precision</td></tr><tr><td>Value</td><td>INT32, INT64, FLOAT, DOUBLE, TEXT</td></tr><tr><td>Default</td><td>DOUBLE</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>floating_string_infer_type</li></ul><table><thead><tr><th>Name</th><th>floating_string_infer_type</th></tr></thead><tbody><tr><td>Description</td><td>register time series as which type when receiving a floating number string "6.7"</td></tr><tr><td>Value</td><td>DOUBLE, FLOAT or TEXT</td></tr><tr><td>Default</td><td>DOUBLE</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>nan_string_infer_type</li></ul><table><thead><tr><th>Name</th><th>nan_string_infer_type</th></tr></thead><tbody><tr><td>Description</td><td>register time series as which type when receiving the Literal NaN.</td></tr><tr><td>Value</td><td>DOUBLE, FLOAT or TEXT</td></tr><tr><td>Default</td><td>DOUBLE</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_boolean_encoding</li></ul><table><thead><tr><th>Name</th><th>default_boolean_encoding</th></tr></thead><tbody><tr><td>Description</td><td>BOOLEAN encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN, RLE</td></tr><tr><td>Default</td><td>RLE</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_int32_encoding</li></ul><table><thead><tr><th>Name</th><th>default_int32_encoding</th></tr></thead><tbody><tr><td>Description</td><td>INT32 encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN, RLE, TS_2DIFF, REGULAR, GORILLA</td></tr><tr><td>Default</td><td>TS_2DIFF</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_int64_encoding</li></ul><table><thead><tr><th>Name</th><th>default_int64_encoding</th></tr></thead><tbody><tr><td>Description</td><td>INT64 encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN, RLE, TS_2DIFF, REGULAR, GORILLA</td></tr><tr><td>Default</td><td>TS_2DIFF</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_float_encoding</li></ul><table><thead><tr><th>Name</th><th>default_float_encoding</th></tr></thead><tbody><tr><td>Description</td><td>FLOAT encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN, RLE, TS_2DIFF, GORILLA</td></tr><tr><td>Default</td><td>GORILLA</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_double_encoding</li></ul><table><thead><tr><th>Name</th><th>default_double_encoding</th></tr></thead><tbody><tr><td>Description</td><td>DOUBLE encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN, RLE, TS_2DIFF, GORILLA</td></tr><tr><td>Default</td><td>GORILLA</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>default_text_encoding</li></ul><table><thead><tr><th>Name</th><th>default_text_encoding</th></tr></thead><tbody><tr><td>Description</td><td>TEXT encoding when creating schema automatically is enabled</td></tr><tr><td>Value</td><td>PLAIN</td></tr><tr><td>Default</td><td>PLAIN</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>boolean_compressor</li></ul><table><thead><tr><th>Name</th><th>boolean_compressor</th></tr></thead><tbody><tr><td>Description</td><td>BOOLEAN compression when creating schema automatically is enabled (Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>int32_compressor</li></ul><table><thead><tr><th>Name</th><th>int32_compressor</th></tr></thead><tbody><tr><td>Description</td><td>INT32/DATE compression when creating schema automatically is enabled(Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>int64_compressor</li></ul><table><thead><tr><th>Name</th><th>int64_compressor</th></tr></thead><tbody><tr><td>Description</td><td>INT64/TIMESTAMP compression when creating schema automatically is enabled (Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>float_compressor</li></ul><table><thead><tr><th>Name</th><th>float_compressor</th></tr></thead><tbody><tr><td>Description</td><td>FLOAT compression when creating schema automatically is enabled (Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>double_compressor</li></ul><table><thead><tr><th>Name</th><th>double_compressor</th></tr></thead><tbody><tr><td>Description</td><td>DOUBLE compression when creating schema automatically is enabled (Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>text_compressor</li></ul><table><thead><tr><th>Name</th><th>text_compressor</th></tr></thead><tbody><tr><td>Description</td><td>TEXT/BINARY/BLOB compression when creating schema automatically is enabled (Supports from V2.0.6)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><h3 id="_4-17-query-configurations" tabindex="-1"><a class="header-anchor" href="#_4-17-query-configurations"><span>4.17 Query Configurations</span></a></h3><ul><li>read_consistency_level</li></ul><table><thead><tr><th>Name</th><th>read_consistency_level</th></tr></thead><tbody><tr><td>Description</td><td>The read consistency levelThese consistency levels are currently supported:strong(Default, read from the leader replica)weak(Read from a random replica)</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>strong</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>meta_data_cache_enable</li></ul><table><thead><tr><th>Name</th><th>meta_data_cache_enable</th></tr></thead><tbody><tr><td>Description</td><td>Whether to cache meta data (BloomFilter, ChunkMetadata and TimeSeriesMetadata) or not.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>chunk_timeseriesmeta_free_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>chunk_timeseriesmeta_free_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>Read memory Allocation Ratio: BloomFilterCache : ChunkCache : TimeSeriesMetadataCache : Coordinator : Operators : DataExchange : timeIndex in TsFileResourceList : others.The parameter form is a🅱️c:d:e:f:g:h, where a, b, c, d, e, f, g and h are integers. for example: 1:1:1:1:1:1:1:1 , 1💯200:50:200:200:200:50</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>1 : 100 : 200 : 300 : 400</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_last_cache</li></ul><table><thead><tr><th>Name</th><th>enable_last_cache</th></tr></thead><tbody><tr><td>Description</td><td>Whether to enable LAST cache</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>mpp_data_exchange_core_pool_size</li></ul><table><thead><tr><th>Name</th><th>mpp_data_exchange_core_pool_size</th></tr></thead><tbody><tr><td>Description</td><td>Core size of ThreadPool of MPP data exchange</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>mpp_data_exchange_max_pool_size</li></ul><table><thead><tr><th>Name</th><th>mpp_data_exchange_max_pool_size</th></tr></thead><tbody><tr><td>Description</td><td>Max size of ThreadPool of MPP data exchange</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>mpp_data_exchange_keep_alive_time_in_ms</li></ul><table><thead><tr><th>Name</th><th>mpp_data_exchange_keep_alive_time_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Max waiting time for MPP data exchange</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>driver_task_execution_time_slice_in_ms</li></ul><table><thead><tr><th>Name</th><th>driver_task_execution_time_slice_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The max execution time of a DriverTask</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>200</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>max_tsblock_size_in_bytes</li></ul><table><thead><tr><th>Name</th><th>max_tsblock_size_in_bytes</th></tr></thead><tbody><tr><td>Description</td><td>The max capacity of a TsBlock</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>131072</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>max_tsblock_line_numbers</li></ul><table><thead><tr><th>Name</th><th>max_tsblock_line_numbers</th></tr></thead><tbody><tr><td>Description</td><td>The max number of lines in a single TsBlock</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>slow_query_threshold</li></ul><table><thead><tr><th>Name</th><th>slow_query_threshold</th></tr></thead><tbody><tr><td>Description</td><td>Time cost(ms) threshold for slow query</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>3000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>query_cost_stat_window</li></ul><table><thead><tr><th>Name</th><th>query_cost_stat_window</th></tr></thead><tbody><tr><td>Description</td><td>Time window threshold(min) for record of history queries.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>query_timeout_threshold</li></ul><table><thead><tr><th>Name</th><th>query_timeout_threshold</th></tr></thead><tbody><tr><td>Description</td><td>The max executing time of query. unit: ms</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>60000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>max_allowed_concurrent_queries</li></ul><table><thead><tr><th>Name</th><th>max_allowed_concurrent_queries</th></tr></thead><tbody><tr><td>Description</td><td>The maximum allowed concurrently executing queries</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>query_thread_count</li></ul><table><thead><tr><th>Name</th><th>query_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>How many threads can concurrently execute query statement. When <= 0, use CPU core number.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>degree_of_query_parallelism</li></ul><table><thead><tr><th>Name</th><th>degree_of_query_parallelism</th></tr></thead><tbody><tr><td>Description</td><td>How many pipeline drivers will be created for one fragment instance. When <= 0, use CPU core number / 2.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>mode_map_size_threshold</li></ul><table><thead><tr><th>Name</th><th>mode_map_size_threshold</th></tr></thead><tbody><tr><td>Description</td><td>The threshold of count map size when calculating the MODE aggregation function</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>batch_size</li></ul><table><thead><tr><th>Name</th><th>batch_size</th></tr></thead><tbody><tr><td>Description</td><td>The amount of data iterate each time in server (the number of data strips, that is, the number of different timestamps.)</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>100000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>sort_buffer_size_in_bytes</li></ul><table><thead><tr><th>Name</th><th>sort_buffer_size_in_bytes</th></tr></thead><tbody><tr><td>Description</td><td>The memory for external sort in sort operator, when the data size is smaller than sort_buffer_size_in_bytes, the sort operator will use in-memory sort.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>1048576(Before V2.0.6) <br> 0(Supports from V2.0.6), if <code>sort_buffer_size_in_bytes <= 0</code>, default value will be used, <code>default value = min(32MB, memory for query operators / query_thread_count / 2)</code>, if <code>sort_buffer_size_in_bytes > 0</code>, the specified value will be used.</td></tr><tr><td>Effective</td><td>Hot_reload</td></tr></tbody></table><ul><li>merge_threshold_of_explain_analyze</li></ul><table><thead><tr><th>Name</th><th>merge_threshold_of_explain_analyze</th></tr></thead><tbody><tr><td>Description</td><td>The threshold of operator count in the result set of EXPLAIN ANALYZE, if the number of operator in the result set is larger than this threshold, operator will be merged.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-18-ttl-configuration" tabindex="-1"><a class="header-anchor" href="#_4-18-ttl-configuration"><span>4.18 TTL Configuration</span></a></h3><ul><li>ttl_check_interval</li></ul><table><thead><tr><th>Name</th><th>ttl_check_interval</th></tr></thead><tbody><tr><td>Description</td><td>The interval of TTL check task in each database. The TTL check task will inspect and select files with a higher volume of expired data for compaction. Default is 2 hours.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>7200000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>max_expired_time</li></ul><table><thead><tr><th>Name</th><th>max_expired_time</th></tr></thead><tbody><tr><td>Description</td><td>The maximum expiring time of device which has a ttl. Default is 1 month.If the data elapsed time (current timestamp minus the maximum data timestamp of the device in the file) of such devices exceeds this value, then the file will be cleaned by compaction.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>2592000000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>expired_data_ratio</li></ul><table><thead><tr><th>Name</th><th>expired_data_ratio</th></tr></thead><tbody><tr><td>Description</td><td>The expired device ratio. If the ratio of expired devices in one file exceeds this value, then expired data of this file will be cleaned by compaction.</td></tr><tr><td>Type</td><td>float</td></tr><tr><td>Default</td><td>0.3</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-19-storage-engine-configuration" tabindex="-1"><a class="header-anchor" href="#_4-19-storage-engine-configuration"><span>4.19 Storage Engine Configuration</span></a></h3><ul><li>timestamp_precision</li></ul><table><thead><tr><th>Name</th><th>timestamp_precision</th></tr></thead><tbody><tr><td>Description</td><td>Use this value to set timestamp precision as "ms", "us" or "ns".</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ms</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>timestamp_precision_check_enabled</li></ul><table><thead><tr><th>Name</th><th>timestamp_precision_check_enabled</th></tr></thead><tbody><tr><td>Description</td><td>When the timestamp precision check is enabled, the timestamps those are over 13 digits for ms precision, or over 16 digits for us precision are not allowed to be inserted.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>max_waiting_time_when_insert_blocked</li></ul><table><thead><tr><th>Name</th><th>max_waiting_time_when_insert_blocked</th></tr></thead><tbody><tr><td>Description</td><td>When the waiting time (in ms) of an inserting exceeds this, throw an exception. 10000 by default.</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>handle_system_error</li></ul><table><thead><tr><th>Name</th><th>handle_system_error</th></tr></thead><tbody><tr><td>Description</td><td>What will the system do when unrecoverable error occurs.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>CHANGE_TO_READ_ONLY</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_timed_flush_seq_memtable</li></ul><table><thead><tr><th>Name</th><th>enable_timed_flush_seq_memtable</th></tr></thead><tbody><tr><td>Description</td><td>Whether to timed flush sequence tsfiles' memtables.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>seq_memtable_flush_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>seq_memtable_flush_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>If a memTable's last update time is older than current time minus this, the memtable will be flushed to disk.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>600000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>seq_memtable_flush_check_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>seq_memtable_flush_check_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The interval to check whether sequence memtables need flushing.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>30000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_timed_flush_unseq_memtable</li></ul><table><thead><tr><th>Name</th><th>enable_timed_flush_unseq_memtable</th></tr></thead><tbody><tr><td>Description</td><td>Whether to timed flush unsequence tsfiles' memtables.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>unseq_memtable_flush_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>unseq_memtable_flush_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>If a memTable's last update time is older than current time minus this, the memtable will be flushed to disk.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>600000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>unseq_memtable_flush_check_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>unseq_memtable_flush_check_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The interval to check whether unsequence memtables need flushing.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>30000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>tvlist_sort_algorithm</li></ul><table><thead><tr><th>Name</th><th>tvlist_sort_algorithm</th></tr></thead><tbody><tr><td>Description</td><td>The sort algorithms used in the memtable's TVList</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>TIM</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>avg_series_point_number_threshold</li></ul><table><thead><tr><th>Name</th><th>avg_series_point_number_threshold</th></tr></thead><tbody><tr><td>Description</td><td>When the average point number of timeseries in memtable exceeds this, the memtable is flushed to disk.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>flush_thread_count</li></ul><table><thead><tr><th>Name</th><th>flush_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>How many threads can concurrently flush. When <= 0, use CPU core number.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_partial_insert</li></ul><table><thead><tr><th>Name</th><th>enable_partial_insert</th></tr></thead><tbody><tr><td>Description</td><td>In one insert (one device, one timestamp, multiple measurements), if enable partial insert, one measurement failure will not impact other measurements</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>recovery_log_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>recovery_log_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>the interval to log recover progress of each vsg when starting iotdb</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>5000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>0.13_data_insert_adapt</li></ul><table><thead><tr><th>Name</th><th>0.13_data_insert_adapt</th></tr></thead><tbody><tr><td>Description</td><td>If using a v0.13 client to insert data, please set this configuration to true.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_tsfile_validation</li></ul><table><thead><tr><th>Name</th><th>enable_tsfile_validation</th></tr></thead><tbody><tr><td>Description</td><td>Verify that TSfiles generated by Flush, Load, and Compaction are correct.</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>tier_ttl_in_ms</li></ul><table><thead><tr><th>Name</th><th>tier_ttl_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Default tier TTL. When the survival time of the data exceeds the threshold, it will be migrated to the next tier.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-20-compaction-configurations" tabindex="-1"><a class="header-anchor" href="#_4-20-compaction-configurations"><span>4.20 Compaction Configurations</span></a></h3><ul><li>enable_seq_space_compaction</li></ul><table><thead><tr><th>Name</th><th>enable_seq_space_compaction</th></tr></thead><tbody><tr><td>Description</td><td>sequence space compaction: only compact the sequence files</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_unseq_space_compaction</li></ul><table><thead><tr><th>Name</th><th>enable_unseq_space_compaction</th></tr></thead><tbody><tr><td>Description</td><td>unsequence space compaction: only compact the unsequence files</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_cross_space_compaction</li></ul><table><thead><tr><th>Name</th><th>enable_cross_space_compaction</th></tr></thead><tbody><tr><td>Description</td><td>cross space compaction: compact the unsequence files into the overlapped sequence files</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_auto_repair_compaction</li></ul><table><thead><tr><th>Name</th><th>enable_auto_repair_compaction</th></tr></thead><tbody><tr><td>Description</td><td>enable auto repair unsorted file by compaction</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>cross_selector</li></ul><table><thead><tr><th>Name</th><th>cross_selector</th></tr></thead><tbody><tr><td>Description</td><td>the selector of cross space compaction task</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>rewrite</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>cross_performer</li></ul><table><thead><tr><th>Name</th><th>cross_performer</th></tr></thead><tbody><tr><td>Description</td><td>the compaction performer of cross space compaction task, Options: read_point, fast</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>fast</td></tr><tr><td>Effective</td><td>Hot reload .</td></tr></tbody></table><ul><li>inner_seq_selector</li></ul><table><thead><tr><th>Name</th><th>inner_seq_selector</th></tr></thead><tbody><tr><td>Description</td><td>the selector of inner sequence space compaction task, Options: size_tiered_single_target,size_tiered_multi_target</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>size_tiered_multi_target</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_seq_performer</li></ul><table><thead><tr><th>Name</th><th>inner_seq_performer</th></tr></thead><tbody><tr><td>Description</td><td>the performer of inner sequence space compaction task, Options: read_chunk, fast</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>read_chunk</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_unseq_selector</li></ul><table><thead><tr><th>Name</th><th>inner_unseq_selector</th></tr></thead><tbody><tr><td>Description</td><td>the selector of inner unsequence space compaction task, Options: size_tiered_single_target,size_tiered_multi_target</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>size_tiered_multi_target</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_unseq_performer</li></ul><table><thead><tr><th>Name</th><th>inner_unseq_performer</th></tr></thead><tbody><tr><td>Description</td><td>the performer of inner unsequence space compaction task, Options: read_point, fast</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>fast</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_priority</li></ul><table><thead><tr><th>Name</th><th>compaction_priority</th></tr></thead><tbody><tr><td>Description</td><td>The priority of compaction executionINNER_CROSS: prioritize inner space compaction, reduce the number of files firstCROSS_INNER: prioritize cross space compaction, eliminate the unsequence files firstBALANCE: alternate two compaction types</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>INNER_CROSS</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>candidate_compaction_task_queue_size</li></ul><table><thead><tr><th>Name</th><th>candidate_compaction_task_queue_size</th></tr></thead><tbody><tr><td>Description</td><td>The size of candidate compaction task queue.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>50</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>target_compaction_file_size</li></ul><table><thead><tr><th>Name</th><th>target_compaction_file_size</th></tr></thead><tbody><tr><td>Description</td><td>This parameter is used in two places:The target tsfile size of inner space compaction.The candidate size of seq tsfile in cross space compaction will be smaller than target_compaction_file_size * <a href="http://1.5.In" target="_blank" rel="noopener noreferrer">1.5.In</a> most cases, the target file size of cross compaction won't exceed this threshold, and if it does, it will not be much larger than it.</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>2147483648</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_compaction_total_file_size_threshold</li></ul><table><thead><tr><th>Name</th><th>inner_compaction_total_file_size_threshold</th></tr></thead><tbody><tr><td>Description</td><td>The total file size limit in inner space compaction.</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>10737418240</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_compaction_total_file_num_threshold</li></ul><table><thead><tr><th>Name</th><th>inner_compaction_total_file_num_threshold</th></tr></thead><tbody><tr><td>Description</td><td>The total file num limit in inner space compaction.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>max_level_gap_in_inner_compaction</li></ul><table><thead><tr><th>Name</th><th>max_level_gap_in_inner_compaction</th></tr></thead><tbody><tr><td>Description</td><td>The max level gap in inner compaction selection</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>target_chunk_size</li></ul><table><thead><tr><th>Name</th><th>target_chunk_size</th></tr></thead><tbody><tr><td>Description</td><td>The target chunk size in flushing and compaction. If the size of a timeseries in memtable exceeds this, the data will be flushed to multiple chunks.</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>1600000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>target_chunk_point_num</li></ul><table><thead><tr><th>Name</th><th>target_chunk_point_num</th></tr></thead><tbody><tr><td>Description</td><td>The target point nums in one chunk in flushing and compaction. If the point number of a timeseries in memtable exceeds this, the data will be flushed to multiple chunks.</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>100000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>chunk_size_lower_bound_in_compaction</li></ul><table><thead><tr><th>Name</th><th>chunk_size_lower_bound_in_compaction</th></tr></thead><tbody><tr><td>Description</td><td>If the chunk size is lower than this threshold, it will be deserialized into points</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>chunk_point_num_lower_bound_in_compaction</li></ul><table><thead><tr><th>Name</th><th>chunk_point_num_lower_bound_in_compaction</th></tr></thead><tbody><tr><td>Description</td><td>If the chunk point num is lower than this threshold, it will be deserialized into points</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>100</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>inner_compaction_candidate_file_num</li></ul><table><thead><tr><th>Name</th><th>inner_compaction_candidate_file_num</th></tr></thead><tbody><tr><td>Description</td><td>The file num requirement when selecting inner space compaction candidate files</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>30</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>max_cross_compaction_candidate_file_num</li></ul><table><thead><tr><th>Name</th><th>max_cross_compaction_candidate_file_num</th></tr></thead><tbody><tr><td>Description</td><td>The max file when selecting cross space compaction candidate files</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>500</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>max_cross_compaction_candidate_file_size</li></ul><table><thead><tr><th>Name</th><th>max_cross_compaction_candidate_file_size</th></tr></thead><tbody><tr><td>Description</td><td>The max total size when selecting cross space compaction candidate files</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>5368709120</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>min_cross_compaction_unseq_file_level</li></ul><table><thead><tr><th>Name</th><th>min_cross_compaction_unseq_file_level</th></tr></thead><tbody><tr><td>Description</td><td>The min inner compaction level of unsequence file which can be selected as candidate</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_thread_count</li></ul><table><thead><tr><th>Name</th><th>compaction_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>How many threads will be set up to perform compaction, 10 by default.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_max_aligned_series_num_in_one_batch</li></ul><table><thead><tr><th>Name</th><th>compaction_max_aligned_series_num_in_one_batch</th></tr></thead><tbody><tr><td>Description</td><td>How many chunk will be compacted in aligned series compaction, 10 by default.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_schedule_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>compaction_schedule_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The interval of compaction task schedule</td></tr><tr><td>Type</td><td>Int64</td></tr><tr><td>Default</td><td>60000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>compaction_write_throughput_mb_per_sec</li></ul><table><thead><tr><th>Name</th><th>compaction_write_throughput_mb_per_sec</th></tr></thead><tbody><tr><td>Description</td><td>The limit of write throughput merge can reach per second</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>16</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>compaction_read_throughput_mb_per_sec</li></ul><table><thead><tr><th>Name</th><th>compaction_read_throughput_mb_per_sec</th></tr></thead><tbody><tr><td>Description</td><td>The limit of read throughput merge can reach per second</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_read_operation_per_sec</li></ul><table><thead><tr><th>Name</th><th>compaction_read_operation_per_sec</th></tr></thead><tbody><tr><td>Description</td><td>The limit of read operation merge can reach per second</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>sub_compaction_thread_count</li></ul><table><thead><tr><th>Name</th><th>sub_compaction_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>The number of sub compaction threads to be set up to perform compaction.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_compaction_task_selection_disk_redundancy</li></ul><table><thead><tr><th>Name</th><th>inner_compaction_task_selection_disk_redundancy</th></tr></thead><tbody><tr><td>Description</td><td>Redundancy value of disk availability, only use for inner compaction.</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>0.05</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>inner_compaction_task_selection_mods_file_threshold</li></ul><table><thead><tr><th>Name</th><th>inner_compaction_task_selection_mods_file_threshold</th></tr></thead><tbody><tr><td>Description</td><td>Mods file size threshold, only use for inner compaction.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>131072</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compaction_schedule_thread_num</li></ul><table><thead><tr><th>Name</th><th>compaction_schedule_thread_num</th></tr></thead><tbody><tr><td>Description</td><td>The number of threads to be set up to select compaction task.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-21-write-ahead-log-configuration" tabindex="-1"><a class="header-anchor" href="#_4-21-write-ahead-log-configuration"><span>4.21 Write Ahead Log Configuration</span></a></h3><ul><li>wal_mode</li></ul><table><thead><tr><th>Name</th><th>wal_mode</th></tr></thead><tbody><tr><td>Description</td><td>The details of these three modes are as follows:DISABLE: the system will disable wal.SYNC: the system will submit wal synchronously, write request will not return until its wal is fsynced to the disk successfully.ASYNC: the system will submit wal asynchronously, write request will return immediately no matter its wal is fsynced to the disk successfully.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ASYNC</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>max_wal_nodes_num</li></ul><table><thead><tr><th>Name</th><th>max_wal_nodes_num</th></tr></thead><tbody><tr><td>Description</td><td>each node corresponds to one wal directory The default value 0 means the number is determined by the system, the number is in the range of [data region num / 2, data region num].</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>wal_async_mode_fsync_delay_in_ms</li></ul><table><thead><tr><th>Name</th><th>wal_async_mode_fsync_delay_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Duration a wal flush operation will wait before calling fsync in the async mode</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>wal_sync_mode_fsync_delay_in_ms</li></ul><table><thead><tr><th>Name</th><th>wal_sync_mode_fsync_delay_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Duration a wal flush operation will wait before calling fsync in the sync mode</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>3</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>wal_buffer_size_in_byte</li></ul><table><thead><tr><th>Name</th><th>wal_buffer_size_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>Buffer size of each wal node</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>33554432</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>wal_buffer_queue_capacity</li></ul><table><thead><tr><th>Name</th><th>wal_buffer_queue_capacity</th></tr></thead><tbody><tr><td>Description</td><td>Buffer capacity of each wal queue</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>500</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>wal_file_size_threshold_in_byte</li></ul><table><thead><tr><th>Name</th><th>wal_file_size_threshold_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>Size threshold of each wal file</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>31457280</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>wal_min_effective_info_ratio</li></ul><table><thead><tr><th>Name</th><th>wal_min_effective_info_ratio</th></tr></thead><tbody><tr><td>Description</td><td>Minimum ratio of effective information in wal files</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>0.1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>wal_memtable_snapshot_threshold_in_byte</li></ul><table><thead><tr><th>Name</th><th>wal_memtable_snapshot_threshold_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>MemTable size threshold for triggering MemTable snapshot in wal</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>8388608</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>max_wal_memtable_snapshot_num</li></ul><table><thead><tr><th>Name</th><th>max_wal_memtable_snapshot_num</th></tr></thead><tbody><tr><td>Description</td><td>MemTable's max snapshot number in wal</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>delete_wal_files_period_in_ms</li></ul><table><thead><tr><th>Name</th><th>delete_wal_files_period_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The period when outdated wal files are periodically deleted</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>20000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>wal_throttle_threshold_in_byte</li></ul><table><thead><tr><th>Name</th><th>wal_throttle_threshold_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>The minimum size of wal files when throttle down in IoTConsensus</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>53687091200</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>iot_consensus_cache_window_time_in_ms</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_cache_window_time_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Maximum wait time of write cache in IoTConsensus</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_wal_compression</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_cache_window_time_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>Enable Write Ahead Log compression.</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-22-iotconsensus-configuration" tabindex="-1"><a class="header-anchor" href="#_4-22-iotconsensus-configuration"><span>4.22 <strong>IoTConsensus Configuration</strong></span></a></h3><ul><li>data_region_iot_max_log_entries_num_per_batch</li></ul><table><thead><tr><th>Name</th><th>data_region_iot_max_log_entries_num_per_batch</th></tr></thead><tbody><tr><td>Description</td><td>The maximum log entries num in IoTConsensus Batch</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1024</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_iot_max_size_per_batch</li></ul><table><thead><tr><th>Name</th><th>data_region_iot_max_size_per_batch</th></tr></thead><tbody><tr><td>Description</td><td>The maximum size in IoTConsensus Batch</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>16777216</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_iot_max_pending_batches_num</li></ul><table><thead><tr><th>Name</th><th>data_region_iot_max_pending_batches_num</th></tr></thead><tbody><tr><td>Description</td><td>The maximum pending batches num in IoTConsensus</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_iot_max_memory_ratio_for_queue</li></ul><table><thead><tr><th>Name</th><th>data_region_iot_max_memory_ratio_for_queue</th></tr></thead><tbody><tr><td>Description</td><td>The maximum memory ratio for queue in IoTConsensus</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>0.6</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>region_migration_speed_limit_bytes_per_second</li></ul><table><thead><tr><th>Name</th><th>region_migration_speed_limit_bytes_per_second</th></tr></thead><tbody><tr><td>Description</td><td>The maximum transit size in byte per second for region migration</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>33554432</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-23-tsfile-configurations" tabindex="-1"><a class="header-anchor" href="#_4-23-tsfile-configurations"><span>4.23 TsFile Configurations</span></a></h3><ul><li>group_size_in_byte</li></ul><table><thead><tr><th>Name</th><th>group_size_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of bytes written to disk each time the data in memory is written to disk</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>134217728</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>page_size_in_byte</li></ul><table><thead><tr><th>Name</th><th>page_size_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>The memory size for each series writer to pack page, default value is 64KB</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>65536</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>max_number_of_points_in_page</li></ul><table><thead><tr><th>Name</th><th>max_number_of_points_in_page</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of data points in a page</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>pattern_matching_threshold</li></ul><table><thead><tr><th>Name</th><th>pattern_matching_threshold</th></tr></thead><tbody><tr><td>Description</td><td>The threshold for pattern matching in regex</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>float_precision</li></ul><table><thead><tr><th>Name</th><th>float_precision</th></tr></thead><tbody><tr><td>Description</td><td>Floating-point precision of query results.Only effective for RLE and TS_2DIFF encodings.Due to the limitation of machine precision, some values may not be interpreted strictly.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>value_encoder</li></ul><table><thead><tr><th>Name</th><th>value_encoder</th></tr></thead><tbody><tr><td>Description</td><td>Encoder of value series. default value is PLAIN.</td></tr><tr><td>Type</td><td>For int, long data type, also supports TS_2DIFF and RLE(run-length encoding), GORILLA and ZIGZAG.</td></tr><tr><td>Default</td><td>PLAIN</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>compressor</li></ul><table><thead><tr><th>Name</th><th>compressor</th></tr></thead><tbody><tr><td>Description</td><td>Compression configuration And it is also used as the default compressor of time column in aligned timeseries.</td></tr><tr><td>Type</td><td>Data compression method, supports UNCOMPRESSED, SNAPPY, ZSTD, LZMA2 or LZ4. Default value is LZ4</td></tr><tr><td>Default</td><td>LZ4</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>encrypt_flag</li></ul><table><thead><tr><th>Name</th><th>encrypt_flag</th></tr></thead><tbody><tr><td>Description</td><td>Enable data encryption</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>encrypt_type</li></ul><table><thead><tr><th>Name</th><th>encrypt_type</th></tr></thead><tbody><tr><td>Description</td><td>The method of data encrytion</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.tsfile.encrypt.UNENCRYPTED</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>encrypt_key_path</li></ul><table><thead><tr><th>Name</th><th>encrypt_key_path</th></tr></thead><tbody><tr><td>Description</td><td>The path of key for data encryption</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-24-authorization-configuration" tabindex="-1"><a class="header-anchor" href="#_4-24-authorization-configuration"><span>4.24 Authorization Configuration</span></a></h3><ul><li>authorizer_provider_class</li></ul><table><thead><tr><th>Name</th><th>authorizer_provider_class</th></tr></thead><tbody><tr><td>Description</td><td>which class to serve for authorization.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.commons.auth.authorizer.LocalFileAuthorizer</td></tr><tr><td>Effective</td><td>Restart required.</td></tr><tr><td>其他可选值</td><td>org.apache.iotdb.commons.auth.authorizer.OpenIdAuthorizer</td></tr></tbody></table><ul><li>openID_url</li></ul><table><thead><tr><th>Name</th><th>openID_url</th></tr></thead><tbody><tr><td>Description</td><td>The url of openID server If OpenIdAuthorizer is enabled, then openID_url must be set.</td></tr><tr><td>Type</td><td>String（a http link）</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>iotdb_server_encrypt_decrypt_provider</li></ul><table><thead><tr><th>Name</th><th>iotdb_server_encrypt_decrypt_provider</th></tr></thead><tbody><tr><td>Description</td><td>encryption provider class</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>org.apache.iotdb.commons.security.encrypt.MessageDigestEncrypt</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>iotdb_server_encrypt_decrypt_provider_parameter</li></ul><table><thead><tr><th>Name</th><th>iotdb_server_encrypt_decrypt_provider_parameter</th></tr></thead><tbody><tr><td>Description</td><td>encryption provided class parameter</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>None</td></tr><tr><td>Effective</td><td>Modify before the first startup.</td></tr></tbody></table><ul><li>author_cache_size</li></ul><table><thead><tr><th>Name</th><th>author_cache_size</th></tr></thead><tbody><tr><td>Description</td><td>Cache size of user and role</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>author_cache_expire_time</li></ul><table><thead><tr><th>Name</th><th>author_cache_expire_time</th></tr></thead><tbody><tr><td>Description</td><td>Cache expire time of user and role</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>30</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-25-udf-configuration" tabindex="-1"><a class="header-anchor" href="#_4-25-udf-configuration"><span>4.25 UDF Configuration</span></a></h3><ul><li>udf_initial_byte_array_length_for_memory_control</li></ul><table><thead><tr><th>Name</th><th>udf_initial_byte_array_length_for_memory_control</th></tr></thead><tbody><tr><td>Description</td><td>Used to estimate the memory usage of text fields in a UDF <a href="http://query.It" target="_blank" rel="noopener noreferrer">query.It</a> is recommended to set this value to be slightly larger than the average length of all text records.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>48</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>udf_memory_budget_in_mb</li></ul><table><thead><tr><th>Name</th><th>udf_memory_budget_in_mb</th></tr></thead><tbody><tr><td>Description</td><td>How much memory may be used in ONE UDF query (in MB). The upper limit is 20% of allocated memory for read.</td></tr><tr><td>Type</td><td>Float</td></tr><tr><td>Default</td><td>30.0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>udf_reader_transformer_collector_memory_proportion</li></ul><table><thead><tr><th>Name</th><th>udf_reader_transformer_collector_memory_proportion</th></tr></thead><tbody><tr><td>Description</td><td>UDF memory allocation ratio.The parameter form is a🅱️c, where a, b, and c are integers.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>1:1:1</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>udf_lib_dir</li></ul><table><thead><tr><th>Name</th><th>udf_lib_dir</th></tr></thead><tbody><tr><td>Description</td><td>the udf lib directory</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ext/udf（Windows：ext\udf）</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-26-trigger-configuration" tabindex="-1"><a class="header-anchor" href="#_4-26-trigger-configuration"><span>4.26 Trigger Configuration</span></a></h3><ul><li>trigger_lib_dir</li></ul><table><thead><tr><th>Name</th><th>trigger_lib_dir</th></tr></thead><tbody><tr><td>Description</td><td>the trigger lib directory</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ext/trigger</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>stateful_trigger_retry_num_when_not_found</li></ul><table><thead><tr><th>Name</th><th>stateful_trigger_retry_num_when_not_found</th></tr></thead><tbody><tr><td>Description</td><td>How many times will we retry to found an instance of stateful trigger on DataNodes</td></tr><tr><td>Type</td><td>Int32</td></tr><tr><td>Default</td><td>3</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-27-select-into-configuration" tabindex="-1"><a class="header-anchor" href="#_4-27-select-into-configuration"><span>4.27 <strong>Select-Into Configuration</strong></span></a></h3><ul><li>into_operation_buffer_size_in_byte</li></ul><table><thead><tr><th>Name</th><th>into_operation_buffer_size_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>The maximum memory occupied by the data to be written when executing select-into statements.</td></tr><tr><td>Type</td><td>long</td></tr><tr><td>Default</td><td>104857600</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>select_into_insert_tablet_plan_row_limit</li></ul><table><thead><tr><th>Name</th><th>select_into_insert_tablet_plan_row_limit</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of rows can be processed in insert-tablet-plan when executing select-into statements.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>into_operation_execution_thread_count</li></ul><table><thead><tr><th>Name</th><th>into_operation_execution_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>The number of threads in the thread pool that execute insert-tablet tasks</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-28-continuous-query-configuration" tabindex="-1"><a class="header-anchor" href="#_4-28-continuous-query-configuration"><span>4.28 Continuous Query Configuration</span></a></h3><ul><li>continuous_query_submit_thread_count</li></ul><table><thead><tr><th>Name</th><th>continuous_query_execution_thread</th></tr></thead><tbody><tr><td>Description</td><td>The number of threads in the scheduled thread pool that submit continuous query tasks periodically</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>continuous_query_min_every_interval_in_ms</li></ul><table><thead><tr><th>Name</th><th>continuous_query_min_every_interval_in_ms</th></tr></thead><tbody><tr><td>Description</td><td>The minimum value of the continuous query execution time interval</td></tr><tr><td>Type</td><td>long (duration)</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-29-pipe-configuration" tabindex="-1"><a class="header-anchor" href="#_4-29-pipe-configuration"><span>4.29 Pipe Configuration</span></a></h3><ul><li>pipe_lib_dir</li></ul><table><thead><tr><th>Name</th><th>pipe_lib_dir</th></tr></thead><tbody><tr><td>Description</td><td>the pipe lib directory.</td></tr><tr><td>Type</td><td>string</td></tr><tr><td>Default</td><td>ext/pipe</td></tr><tr><td>Effective</td><td>Not support modify</td></tr></tbody></table><ul><li>pipe_subtask_executor_max_thread_num</li></ul><table><thead><tr><th>Name</th><th>pipe_subtask_executor_max_thread_num</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of threads that can be used to execute the pipe subtasks in PipeSubtaskExecutor. The actual value will be min(pipe_subtask_executor_max_thread_num, max(1, CPU core number / 2)).</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_sink_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>pipe_sink_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>The connection timeout (in milliseconds) for the thrift client.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>900000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_sink_selector_number</li></ul><table><thead><tr><th>Name</th><th>pipe_sink_selector_number</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of selectors that can be used in the sink.Recommend to set this value to less than or equal to pipe_sink_max_client_number.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>4</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_sink_max_client_number</li></ul><table><thead><tr><th>Name</th><th>pipe_sink_max_client_number</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of clients that can be used in the sink.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>16</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_air_gap_receiver_enabled</li></ul><table><thead><tr><th>Name</th><th>pipe_air_gap_receiver_enabled</th></tr></thead><tbody><tr><td>Description</td><td>Whether to enable receiving pipe data through air gap.The receiver can only return 0 or 1 in TCP mode to indicate whether the data is received successfully.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_air_gap_receiver_port</li></ul><table><thead><tr><th>Name</th><th>pipe_air_gap_receiver_port</th></tr></thead><tbody><tr><td>Description</td><td>The port for the server to receive pipe data through air gap.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>9780</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>pipe_all_sinks_rate_limit_bytes_per_second</li></ul><table><thead><tr><th>Name</th><th>pipe_all_sinks_rate_limit_bytes_per_second</th></tr></thead><tbody><tr><td>Description</td><td>The total bytes that all pipe sinks can transfer per second.When given a value less than or equal to 0, it means no limit. default value is -1, which means no limit.</td></tr><tr><td>Type</td><td>double</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-30-ratisconsensus-configuration" tabindex="-1"><a class="header-anchor" href="#_4-30-ratisconsensus-configuration"><span>4.30 RatisConsensus Configuration</span></a></h3><ul><li>config_node_ratis_log_appender_buffer_size_max</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_log_appender_buffer_size_max</th></tr></thead><tbody><tr><td>Description</td><td>max payload size for a single log-sync-RPC from leader to follower of ConfigNode (in byte, by default 16MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>16777216</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_log_appender_buffer_size_max</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_log_appender_buffer_size_max</th></tr></thead><tbody><tr><td>Description</td><td>max payload size for a single log-sync-RPC from leader to follower of SchemaRegion (in byte, by default 16MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>16777216</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_log_appender_buffer_size_max</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_appender_buffer_size_max</th></tr></thead><tbody><tr><td>Description</td><td>max payload size for a single log-sync-RPC from leader to follower of DataRegion (in byte, by default 16MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>16777216</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_snapshot_trigger_threshold</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_snapshot_trigger_threshold</th></tr></thead><tbody><tr><td>Description</td><td>max numbers of snapshot_trigger_threshold logs to trigger a snapshot of Confignode</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>400,000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_snapshot_trigger_threshold</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_snapshot_trigger_threshold</th></tr></thead><tbody><tr><td>Description</td><td>max numbers of snapshot_trigger_threshold logs to trigger a snapshot of SchemaRegion</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>400,000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_snapshot_trigger_threshold</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_snapshot_trigger_threshold</th></tr></thead><tbody><tr><td>Description</td><td>max numbers of snapshot_trigger_threshold logs to trigger a snapshot of DataRegion</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>400,000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_log_unsafe_flush_enable</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_log_unsafe_flush_enable</th></tr></thead><tbody><tr><td>Description</td><td>Is confignode allowed flushing Raft Log asynchronously</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_log_unsafe_flush_enable</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_log_unsafe_flush_enable</th></tr></thead><tbody><tr><td>Description</td><td>Is schemaregion allowed flushing Raft Log asynchronously</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_log_unsafe_flush_enable</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_unsafe_flush_enable</th></tr></thead><tbody><tr><td>Description</td><td>Is dataregion allowed flushing Raft Log asynchronously</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_log_segment_size_max_in_byte</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_log_segment_size_max_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>max capacity of a RaftLog segment file of confignode (in byte, by default 24MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>25165824</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_log_segment_size_max_in_byte</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_log_segment_size_max_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>max capacity of a RaftLog segment file of schemaregion (in byte, by default 24MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>25165824</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_log_segment_size_max_in_byte</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_segment_size_max_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>max capacity of a RaftLog segment file of dataregion(in byte, by default 24MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>25165824</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_simple_consensus_log_segment_size_max_in_byte</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_segment_size_max_in_byte</th></tr></thead><tbody><tr><td>Description</td><td>max capacity of a simple log segment file of confignode(in byte, by default 24MB)</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>25165824</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_grpc_flow_control_window</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_grpc_flow_control_window</th></tr></thead><tbody><tr><td>Description</td><td>confignode flow control window for ratis grpc log appender</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4194304</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_grpc_flow_control_window</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_grpc_flow_control_window</th></tr></thead><tbody><tr><td>Description</td><td>schema region flow control window for ratis grpc log appender</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4194304</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_grpc_flow_control_window</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_grpc_flow_control_window</th></tr></thead><tbody><tr><td>Description</td><td>data region flow control window for ratis grpc log appender</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4194304</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_grpc_leader_outstanding_appends_max</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_grpc_leader_outstanding_appends_max</th></tr></thead><tbody><tr><td>Description</td><td>config node grpc line concurrency threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_grpc_leader_outstanding_appends_max</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_grpc_leader_outstanding_appends_max</th></tr></thead><tbody><tr><td>Description</td><td>schema region grpc line concurrency threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_grpc_leader_outstanding_appends_max</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_grpc_leader_outstanding_appends_max</th></tr></thead><tbody><tr><td>Description</td><td>data region grpc line concurrency threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_log_force_sync_num</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_log_force_sync_num</th></tr></thead><tbody><tr><td>Description</td><td>config node fsync threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_log_force_sync_num</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_log_force_sync_num</th></tr></thead><tbody><tr><td>Description</td><td>schema region fsync threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_log_force_sync_num</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_force_sync_num</th></tr></thead><tbody><tr><td>Description</td><td>data region fsync threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>128</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_rpc_leader_election_timeout_min_ms</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_rpc_leader_election_timeout_min_ms</th></tr></thead><tbody><tr><td>Description</td><td>confignode leader min election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_rpc_leader_election_timeout_min_ms</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_rpc_leader_election_timeout_min_ms</th></tr></thead><tbody><tr><td>Description</td><td>schema region leader min election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_rpc_leader_election_timeout_min_ms</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_rpc_leader_election_timeout_min_ms</th></tr></thead><tbody><tr><td>Description</td><td>data region leader min election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>2000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_rpc_leader_election_timeout_max_ms</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_rpc_leader_election_timeout_max_ms</th></tr></thead><tbody><tr><td>Description</td><td>confignode leader max election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_rpc_leader_election_timeout_max_ms</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_rpc_leader_election_timeout_max_ms</th></tr></thead><tbody><tr><td>Description</td><td>schema region leader max election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_rpc_leader_election_timeout_max_ms</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_rpc_leader_election_timeout_max_ms</th></tr></thead><tbody><tr><td>Description</td><td>data region leader max election timeout</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4000ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_request_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_request_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>confignode ratis client retry threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_request_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_request_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>schema region ratis client retry threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_request_timeout_ms</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_request_timeout_ms</th></tr></thead><tbody><tr><td>Description</td><td>data region ratis client retry threshold</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_max_retry_attempts</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_max_retry_attempts</th></tr></thead><tbody><tr><td>Description</td><td>confignode ratis client retry times</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_initial_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_initial_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>confignode ratis client initial sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_max_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_max_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>confignode ratis client max retry sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_max_retry_attempts</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_max_retry_attempts</th></tr></thead><tbody><tr><td>Description</td><td>schema region ratis client max retry times</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_initial_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_initial_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>schema region ratis client init sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_max_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_max_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>schema region ratis client max sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_max_retry_attempts</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_max_retry_attempts</th></tr></thead><tbody><tr><td>Description</td><td>data region ratis client max retry sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>10</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_initial_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_initial_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>data region ratis client init sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>100ms</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_max_sleep_time_ms</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_max_sleep_time_ms</th></tr></thead><tbody><tr><td>Description</td><td>data region ratis client max retry sleep time</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>ratis_first_election_timeout_min_ms</li></ul><table><thead><tr><th>Name</th><th>ratis_first_election_timeout_min_ms</th></tr></thead><tbody><tr><td>Description</td><td>Ratis first election min timeout</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>50 (ms)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>ratis_first_election_timeout_max_ms</li></ul><table><thead><tr><th>Name</th><th>ratis_first_election_timeout_max_ms</th></tr></thead><tbody><tr><td>Description</td><td>Ratis first election max timeout</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>150 (ms)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_preserve_logs_num_when_purge</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_preserve_logs_num_when_purge</th></tr></thead><tbody><tr><td>Description</td><td>confignode snapshot preserves certain logs when taking snapshot and purge</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_preserve_logs_num_when_purge</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_preserve_logs_num_when_purge</th></tr></thead><tbody><tr><td>Description</td><td>schema region snapshot preserves certain logs when taking snapshot and purge</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_preserve_logs_num_when_purge</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_preserve_logs_num_when_purge</th></tr></thead><tbody><tr><td>Description</td><td>data region snapshot preserves certain logs when taking snapshot and purge</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1000</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_log_max_size</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_log_max_size</th></tr></thead><tbody><tr><td>Description</td><td>config node Raft Log disk size control</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>2147483648 (2GB)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_log_max_size</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_log_max_size</th></tr></thead><tbody><tr><td>Description</td><td>schema region Raft Log disk size control</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>2147483648 (2GB)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_log_max_size</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_log_max_size</th></tr></thead><tbody><tr><td>Description</td><td>data region Raft Log disk size control</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>21474836480 (20GB)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>config_node_ratis_periodic_snapshot_interval</li></ul><table><thead><tr><th>Name</th><th>config_node_ratis_periodic_snapshot_interval</th></tr></thead><tbody><tr><td>Description</td><td>config node Raft periodic snapshot interval</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>86400 (s)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>schema_region_ratis_periodic_snapshot_interval</li></ul><table><thead><tr><th>Name</th><th>schema_region_ratis_preserve_logs_num_when_purge</th></tr></thead><tbody><tr><td>Description</td><td>schema region Raft periodic snapshot interval</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>86400 (s)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>data_region_ratis_periodic_snapshot_interval</li></ul><table><thead><tr><th>Name</th><th>data_region_ratis_preserve_logs_num_when_purge</th></tr></thead><tbody><tr><td>Description</td><td>data region Raft periodic snapshot interval</td></tr><tr><td>Type</td><td>int64</td></tr><tr><td>Default</td><td>86400 (s)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-31-iotconsensusv2-configuration" tabindex="-1"><a class="header-anchor" href="#_4-31-iotconsensusv2-configuration"><span>4.31 IoTConsensusV2 Configuration</span></a></h3><ul><li>iot_consensus_v2_pipeline_size</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_v2_pipeline_size</th></tr></thead><tbody><tr><td>Description</td><td>Default event buffer size for connector and receiver in iot consensus v2</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>iot_consensus_v2_mode</li></ul><table><thead><tr><th>Name</th><th>iot_consensus_v2_pipeline_size</th></tr></thead><tbody><tr><td>Description</td><td>IoTConsensusV2 mode.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>batch</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-32-procedure-configuration" tabindex="-1"><a class="header-anchor" href="#_4-32-procedure-configuration"><span>4.32 Procedure Configuration</span></a></h3><ul><li>procedure_core_worker_thread_count</li></ul><table><thead><tr><th>Name</th><th>procedure_core_worker_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>Default number of worker thread count</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>4</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>procedure_completed_clean_interval</li></ul><table><thead><tr><th>Name</th><th>procedure_completed_clean_interval</th></tr></thead><tbody><tr><td>Description</td><td>Default time interval of completed procedure cleaner work in, time unit is second</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>30(s)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>procedure_completed_evict_ttl</li></ul><table><thead><tr><th>Name</th><th>procedure_completed_evict_ttl</th></tr></thead><tbody><tr><td>Description</td><td>Default ttl of completed procedure, time unit is second</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>60(s)</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-33-mqtt-broker-configuration" tabindex="-1"><a class="header-anchor" href="#_4-33-mqtt-broker-configuration"><span>4.33 MQTT Broker Configuration</span></a></h3><ul><li>enable_mqtt_service</li></ul><table><thead><tr><th>Name</th><th>enable_mqtt_service。</th></tr></thead><tbody><tr><td>Description</td><td>whether to enable the mqtt service.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>mqtt_host</li></ul><table><thead><tr><th>Name</th><th>mqtt_host</th></tr></thead><tbody><tr><td>Description</td><td>the mqtt service binding host.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>127.0.0.1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>mqtt_port</li></ul><table><thead><tr><th>Name</th><th>mqtt_port</th></tr></thead><tbody><tr><td>Description</td><td>the mqtt service binding port.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1883</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>mqtt_handler_pool_size</li></ul><table><thead><tr><th>Name</th><th>mqtt_handler_pool_size</th></tr></thead><tbody><tr><td>Description</td><td>the handler pool size for handing the mqtt messages.</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>mqtt_payload_formatter</li></ul><table><thead><tr><th>Name</th><th>mqtt_payload_formatter</th></tr></thead><tbody><tr><td>Description</td><td>the mqtt message payload formatter.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>json</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>mqtt_max_message_size</li></ul><table><thead><tr><th>Name</th><th>mqtt_max_message_size</th></tr></thead><tbody><tr><td>Description</td><td>max length of mqtt message in byte</td></tr><tr><td>Type</td><td>int32</td></tr><tr><td>Default</td><td>1048576</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-34-audit-log-configuration" tabindex="-1"><a class="header-anchor" href="#_4-34-audit-log-configuration"><span>4.34 Audit log Configuration</span></a></h3><ul><li>enable_audit_log</li></ul><table><thead><tr><th>Name</th><th>enable_audit_log</th></tr></thead><tbody><tr><td>Description</td><td>whether to enable the audit log.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>audit_log_storage</li></ul><table><thead><tr><th>Name</th><th>audit_log_storage</th></tr></thead><tbody><tr><td>Description</td><td>Output location of audit logs</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>IOTDB,LOGGER</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>audit_log_operation</li></ul><table><thead><tr><th>Name</th><th>audit_log_operation</th></tr></thead><tbody><tr><td>Description</td><td>whether enable audit log for DML operation of datawhether enable audit log for DDL operation of schemawhether enable audit log for QUERY operation of data and schema</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>DML,DDL,QUERY</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>enable_audit_log_for_native_insert_api</li></ul><table><thead><tr><th>Name</th><th>enable_audit_log_for_native_insert_api</th></tr></thead><tbody><tr><td>Description</td><td>whether the local write api records audit logs</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-35-white-list-configuration" tabindex="-1"><a class="header-anchor" href="#_4-35-white-list-configuration"><span>4.35 White List Configuration</span></a></h3><ul><li>enable_white_list</li></ul><table><thead><tr><th>Name</th><th>enable_white_list</th></tr></thead><tbody><tr><td>Description</td><td>whether enable white list</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><h3 id="_4-36-iotdb-ai-configuration" tabindex="-1"><a class="header-anchor" href="#_4-36-iotdb-ai-configuration"><span>4.36 IoTDB-AI Configuration</span></a></h3><ul><li>model_inference_execution_thread_count</li></ul><table><thead><tr><th>Name</th><th>model_inference_execution_thread_count</th></tr></thead><tbody><tr><td>Description</td><td>The thread count which can be used for model inference operation.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><h3 id="_4-37-load-tsfile-configuration" tabindex="-1"><a class="header-anchor" href="#_4-37-load-tsfile-configuration"><span>4.37 Load TsFile Configuration</span></a></h3><ul><li>load_clean_up_task_execution_delay_time_seconds</li></ul><table><thead><tr><th>Name</th><th>load_clean_up_task_execution_delay_time_seconds</th></tr></thead><tbody><tr><td>Description</td><td>Load clean up task is used to clean up the unsuccessful loaded tsfile after a certain period of time.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>1800</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>load_write_throughput_bytes_per_second</li></ul><table><thead><tr><th>Name</th><th>load_write_throughput_bytes_per_second</th></tr></thead><tbody><tr><td>Description</td><td>The maximum bytes per second of disk write throughput when loading tsfile.</td></tr><tr><td>Type</td><td>int</td></tr><tr><td>Default</td><td>-1</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>load_active_listening_enable</li></ul><table><thead><tr><th>Name</th><th>load_active_listening_enable</th></tr></thead><tbody><tr><td>Description</td><td>Whether to enable the active listening mode for tsfile loading.</td></tr><tr><td>Type</td><td>Boolean</td></tr><tr><td>Default</td><td>true</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>load_active_listening_dirs</li></ul><table><thead><tr><th>Name</th><th>load_active_listening_dirs</th></tr></thead><tbody><tr><td>Description</td><td>The directory to be actively listened for tsfile loading.Multiple directories should be separated by a ','.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ext/load/pending</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>load_active_listening_fail_dir</li></ul><table><thead><tr><th>Name</th><th>load_active_listening_fail_dir</th></tr></thead><tbody><tr><td>Description</td><td>The directory where tsfiles are moved if the active listening mode fails to load them.</td></tr><tr><td>Type</td><td>String</td></tr><tr><td>Default</td><td>ext/load/failed</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>load_active_listening_max_thread_num</li></ul><table><thead><tr><th>Name</th><th>load_active_listening_max_thread_num</th></tr></thead><tbody><tr><td>Description</td><td>The maximum number of threads that can be used to load tsfile actively.The default value, when this parameter is commented out or <= 0, use CPU core number.</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Default</td><td>0</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>load_active_listening_check_interval_seconds</li></ul><table><thead><tr><th>Name</th><th>load_active_listening_check_interval_seconds</th></tr></thead><tbody><tr><td>Description</td><td>The interval specified in seconds for the active listening mode to check the directory specified in <code>load_active_listening_dirs</code>.The active listening mode will check the directory every <code>load_active_listening_check_interval_seconds seconds</code>.</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Default</td><td>5</td></tr><tr><td>Effective</td><td>Restart required.</td></tr></tbody></table><ul><li>last_cache_operation_on_load</li></ul><table><thead><tr><th style="text-align:center;">Name</th><th style="text-align:left;">last_cache_operation_on_load</th></tr></thead><tbody><tr><td style="text-align:center;">Description</td><td style="text-align:left;">The operation performed to LastCache when a TsFile is successfully loaded. <code>UPDATE</code>: use the data in the TsFile to update LastCache; <code>UPDATE_NO_BLOB</code>: similar to UPDATE, but will invalidate LastCache for blob series; <code>CLEAN_DEVICE</code>: invalidate LastCache of devices contained in the TsFile; <code>CLEAN_ALL</code>: clean the whole LastCache.</td></tr><tr><td style="text-align:center;">Type</td><td style="text-align:left;">String</td></tr><tr><td style="text-align:center;">Default</td><td style="text-align:left;">UPDATE_NO_BLOB</td></tr><tr><td style="text-align:center;">Effective</td><td style="text-align:left;">Effective after restart</td></tr></tbody></table><ul><li>cache_last_values_for_load</li></ul><table><thead><tr><th style="text-align:center;">Name</th><th style="text-align:left;">cache_last_values_for_load</th></tr></thead><tbody><tr><td style="text-align:center;">Description</td><td style="text-align:left;">Whether to cache last values before loading a TsFile. Only effective when <code>last_cache_operation_on_load=UPDATE_NO_BLOB</code> or <code>last_cache_operation_on_load=UPDATE</code>. When set to true, blob series will be ignored even with <code>last_cache_operation_on_load=UPDATE</code>. Enabling this will increase the memory footprint during loading TsFiles.</td></tr><tr><td style="text-align:center;">Type</td><td style="text-align:left;">Boolean</td></tr><tr><td style="text-align:center;">Default</td><td style="text-align:left;">true</td></tr><tr><td style="text-align:center;">Effective</td><td style="text-align:left;">Effective after restart</td></tr></tbody></table><ul><li>cache_last_values_memory_budget_in_byte</li></ul><table><thead><tr><th style="text-align:center;">Name</th><th style="text-align:left;">cache_last_values_memory_budget_in_byte</th></tr></thead><tbody><tr><td style="text-align:center;">Description</td><td style="text-align:left;">When <code>cache_last_values_for_load=true</code>, the maximum memory that can be used to cache last values. If this value is exceeded, the cached values will be abandoned and last values will be read from the TsFile in a streaming manner.</td></tr><tr><td style="text-align:center;">Type</td><td style="text-align:left;">int32</td></tr><tr><td style="text-align:center;">Default</td><td style="text-align:left;">4194304</td></tr><tr><td style="text-align:center;">Effective</td><td style="text-align:left;">Effective after restart</td></tr></tbody></table><h3 id="_4-38-dispatch-retry-configuration" tabindex="-1"><a class="header-anchor" href="#_4-38-dispatch-retry-configuration"><span>4.38 Dispatch Retry Configuration</span></a></h3><ul><li>enable_retry_for_unknown_error</li></ul><table><thead><tr><th>Name</th><th>enable_retry_for_unknown_error</th></tr></thead><tbody><tr><td>Description</td><td>The maximum retrying time for write request remotely dispatching, time unit is milliseconds.</td></tr><tr><td>Type</td><td>Long</td></tr><tr><td>Default</td><td>60000</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table><ul><li>enable_retry_for_unknown_error</li></ul><table><thead><tr><th>Name</th><th>enable_retry_for_unknown_error</th></tr></thead><tbody><tr><td>Description</td><td>Whether retrying for unknown errors.</td></tr><tr><td>Type</td><td>boolean</td></tr><tr><td>Default</td><td>false</td></tr><tr><td>Effective</td><td>Hot reload</td></tr></tbody></table></div><!----><!----><!----></div><footer class="vp-page-meta"><div class="vp-meta-item edit-link"><a class="auto-link external-link vp-meta-label" href="https://github.com/apache/iotdb-docs/edit/main/src/UserGuide/latest-Table/Reference/System-Config-Manual_apache.md" aria-label="Found Error? Edit this page on GitHub" rel="noopener noreferrer" target="_blank"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon edit-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="edit icon" name="edit"><path d="M430.818 653.65a60.46 60.46 0 0 1-50.96-93.281l71.69-114.012 7.773-10.365L816.038 80.138A60.46 60.46 0 0 1 859.225 62a60.46 60.46 0 0 1 43.186 18.138l43.186 43.186a60.46 60.46 0 0 1 0 86.373L588.879 565.55l-8.637 8.637-117.466 68.234a60.46 60.46 0 0 1-31.958 11.229z"></path><path d="M728.802 962H252.891A190.883 190.883 0 0 1 62.008 771.98V296.934a190.883 190.883 0 0 1 190.883-192.61h267.754a60.46 60.46 0 0 1 0 120.92H252.891a69.962 69.962 0 0 0-69.098 69.099V771.98a69.962 69.962 0 0 0 69.098 69.098h475.911A69.962 69.962 0 0 0 797.9 771.98V503.363a60.46 60.46 0 1 1 120.922 0V771.98A190.883 190.883 0 0 1 728.802 962z"></path></svg><!--]-->Found Error? Edit this page on GitHub<!----></a></div><div class="vp-meta-item git-info"><div class="update-time"><span class="vp-meta-label">Last Updated: </span><time class="vp-meta-info" datetime="2026-04-15T10:39:00.000Z" data-allow-mismatch>4/15/26, 10:39 AM</time></div><!----></div></footer><nav class="vp-page-nav"><a class="route-link auto-link prev" href="/UserGuide/latest-Table/Reference/Sample-Data.html" aria-label="Sample Data"><div class="hint"><span class="arrow start"></span>Prev</div><div class="link"><!---->Sample Data</div></a><a class="route-link auto-link next" href="/UserGuide/latest-Table/Reference/Status-Codes.html" aria-label="Status Codes"><div class="hint">Next<span class="arrow end"></span></div><div class="link">Status Codes<!----></div></a></nav><!----><!----><!--]--></main><!--]--><footer class="site-footer"><span id="doc-version" style="display:none;">latest-Table</span><p class="copyright-text">Copyright © 2026 The Apache Software Foundation. |
