| (window.webpackJsonp=window.webpackJsonp||[]).push([[424],{992:function(s,e,t){"use strict";t.r(e);var a=t(70),r=Object(a.a)({},(function(){var s=this,e=s.$createElement,t=s._self._c||e;return t("ContentSlotsDistributor",{attrs:{"slot-key":s.$parent.slotKey}},[t("h1",{attrs:{id:"运维命令"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#运维命令"}},[s._v("#")]),s._v(" 运维命令")]),s._v(" "),t("h2",{attrs:{id:"flush"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#flush"}},[s._v("#")]),s._v(" FLUSH")]),s._v(" "),t("p",[s._v("将指定存储组的内存缓存区Memory Table的数据持久化到磁盘上，并将数据文件封口。")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("IoTDB> FLUSH \nIoTDB> FLUSH root.ln\nIoTDB> FLUSH root.sg1,root.sg2\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br"),t("span",{staticClass:"line-number"},[s._v("3")]),t("br")])]),t("h2",{attrs:{id:"merge"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#merge"}},[s._v("#")]),s._v(" MERGE")]),s._v(" "),t("p",[s._v("触发层级合并和乱序合并。当前IoTDB支持使用如下两种SQL手动触发数据文件的合并：")]),s._v(" "),t("ul",[t("li",[t("code",[s._v("MERGE")]),s._v(" 先触发层级合并，等层级合并执行完后，再触发乱序合并。在乱序合并中，仅重写重复的Chunk，整理速度快，但是最终磁盘会存在多余数据。")]),s._v(" "),t("li",[t("code",[s._v("FULL MERGE")]),s._v(" 先触发层级合并，等层级合并执行完后，再触发乱序合并。在乱序合并中，将需要合并的顺序和乱序文件的所有数据都重新写一份，整理速度慢，最终磁盘将不存在无用的数据。")])]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("IoTDB> MERGE\nIoTDB> FULL MERGE\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br")])]),t("h2",{attrs:{id:"clear-cache"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#clear-cache"}},[s._v("#")]),s._v(" CLEAR CACHE")]),s._v(" "),t("p",[s._v("手动清除chunk, chunk metadata和timeseries metadata的缓存，在内存资源紧张时，可以通过此命令，释放查询时缓存所占的内存空间。")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("IoTDB> CLEAR CACHE\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("h2",{attrs:{id:"schema-snapshot"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#schema-snapshot"}},[s._v("#")]),s._v(" SCHEMA SNAPSHOT")]),s._v(" "),t("p",[s._v("为了加快 IoTDB 重启速度，用户可以手动触发创建 schema 的快照，从而避免服务器从 mlog 文件中恢复。")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("IoTDB> CREATE SNAPSHOT FOR SCHEMA\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("h2",{attrs:{id:"超时"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#超时"}},[s._v("#")]),s._v(" 超时")]),s._v(" "),t("p",[s._v("IoTDB 支持 Session 超时和查询超时。")]),s._v(" "),t("h3",{attrs:{id:"session-超时"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#session-超时"}},[s._v("#")]),s._v(" Session 超时")]),s._v(" "),t("p",[s._v("Session 超时控制何时关闭空闲 Session。空闲 Session 指在一段时间内没有发起任何操作的 Session。")]),s._v(" "),t("p",[s._v("Session 超时默认未开启。可以在配置文件中通过 "),t("code",[s._v("session_timeout_threshold")]),s._v(" 参数进行配置。")]),s._v(" "),t("h3",{attrs:{id:"查询超时"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#查询超时"}},[s._v("#")]),s._v(" 查询超时")]),s._v(" "),t("p",[s._v("对于执行时间过长的查询，IoTDB 将强行中断该查询，并抛出超时异常，如下所示：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("IoTDB> select * from root;\nMsg: 701 Current query is time out, please check your statement or modify timeout parameter.\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br")])]),t("p",[s._v("系统默认的超时时间为 60000 ms，可以在配置文件中通过 "),t("code",[s._v("query_timeout_threshold")]),s._v(" 参数进行自定义配置。")]),s._v(" "),t("p",[s._v("如果您使用 JDBC 或 Session，还支持对单个查询设置超时时间（单位为 ms）：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("E.g. ((IoTDBStatement) statement).executeQuery(String sql, long timeoutInMS)\nE.g. session.executeQueryStatement(String sql, long timeout)\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br"),t("span",{staticClass:"line-number"},[s._v("2")]),t("br")])]),t("p",[s._v("如果不配置超时时间参数或将超时时间设置为 0，将使用服务器端默认的超时时间.")]),s._v(" "),t("h3",{attrs:{id:"查询中止"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#查询中止"}},[s._v("#")]),s._v(" 查询中止")]),s._v(" "),t("p",[s._v("除了被动地等待查询超时外，IoTDB 还支持主动地中止查询，命令为：")]),s._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[s._v("KILL QUERY <queryId>\n")])]),s._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[s._v("1")]),t("br")])]),t("p",[s._v("通过指定 "),t("code",[s._v("queryId")]),s._v(" 可以中止指定的查询，而如果不指定 "),t("code",[s._v("queryId")]),s._v("，将中止所有正在执行的查询。")]),s._v(" "),t("p",[s._v("为了获取正在执行的查询 id，用户可以使用 "),t("code",[s._v("show query processlist")]),s._v(" 命令，该命令将显示所有正在执行的查询列表，结果形式如下：")]),s._v(" "),t("table",[t("thead",[t("tr",[t("th",[s._v("Time")]),s._v(" "),t("th",[s._v("queryId")]),s._v(" "),t("th",[s._v("statement")])])]),s._v(" "),t("tbody",[t("tr",[t("td"),s._v(" "),t("td"),s._v(" "),t("td")])])]),s._v(" "),t("p",[s._v("其中 statement 最大显示长度为 64 字符。对于超过 64 字符的查询语句，将截取部分进行显示。")])])}),[],!1,null,null,null);e.default=r.exports}}]); |