| import{_ as e,o as t,c as o,e as a}from"./app-Bx8hKGcu.js";const n={},r=a(`<h1 id="慢查询管理" tabindex="-1"><a class="header-anchor" href="#慢查询管理"><span>慢查询管理</span></a></h1><p>IoTDB 会将慢查询输出到单独的日志文件 log_datanode_slow_sql.log 中，并记录其执行耗时。</p><h2 id="配置慢查询的阈值" tabindex="-1"><a class="header-anchor" href="#配置慢查询的阈值"><span>配置慢查询的阈值</span></a></h2><p>IoTDB 在 <code>iotdb-common.properties</code> 提供了 <code>slow_query_threshold</code> 配置项，单位是毫秒，默认是30秒，超过此参数指定的阈值，便会被判断为慢查询，待其查询执行结束后，将其记录在 log_datanode_slow_sql.log 中。</p><h2 id="慢查询日志示例" tabindex="-1"><a class="header-anchor" href="#慢查询日志示例"><span>慢查询日志示例</span></a></h2><div class="language-text line-numbers-mode" data-ext="text" data-title="text"><pre class="language-text"><code>2023-07-31 20:15:00,533 [pool-27-IoTDB-ClientRPC-Processor-1$20230731_121500_00003_1] INFO o.a.i.d.q.p.Coordinator:225 - Cost: 42593 ms, sql is select * from root.db.** | |
| </code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div></div></div>`,6),i=[r];function l(s,d){return t(),o("div",null,i)}const p=e(n,[["render",l],["__file","Slow-Query-Management.html.vue"]]),m=JSON.parse('{"path":"/zh/UserGuide/V1.1.x/Maintenance-Tools/Slow-Query-Management.html","title":"慢查询管理","lang":"zh-CN","frontmatter":{"description":"慢查询管理 IoTDB 会将慢查询输出到单独的日志文件 log_datanode_slow_sql.log 中，并记录其执行耗时。 配置慢查询的阈值 IoTDB 在 iotdb-common.properties 提供了 slow_query_threshold 配置项，单位是毫秒，默认是30秒，超过此参数指定的阈值，便会被判断为慢查询，待其查询执行结...","head":[["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/V1.1.x/Maintenance-Tools/Slow-Query-Management.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"慢查询管理"}],["meta",{"property":"og:description","content":"慢查询管理 IoTDB 会将慢查询输出到单独的日志文件 log_datanode_slow_sql.log 中，并记录其执行耗时。 配置慢查询的阈值 IoTDB 在 iotdb-common.properties 提供了 slow_query_threshold 配置项，单位是毫秒，默认是30秒，超过此参数指定的阈值，便会被判断为慢查询，待其查询执行结..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2023-07-31T13:49:08.000Z"}],["meta",{"property":"article:modified_time","content":"2023-07-31T13:49:08.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"慢查询管理\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-07-31T13:49:08.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"配置慢查询的阈值","slug":"配置慢查询的阈值","link":"#配置慢查询的阈值","children":[]},{"level":2,"title":"慢查询日志示例","slug":"慢查询日志示例","link":"#慢查询日志示例","children":[]}],"git":{"createdTime":1688958677000,"updatedTime":1690811348000,"contributors":[{"name":"Jackie Tien","email":"jackietien97@gmail.com","commits":1}]},"readingTime":{"minutes":0.8,"words":241},"filePathRelative":"zh/UserGuide/V1.1.x/Maintenance-Tools/Slow-Query-Management.md","localizedDate":"2023年7月10日","autoDesc":true}');export{p as comp,m as data}; |