| "use strict";(self.webpackChunkdoris_website=self.webpackChunkdoris_website||[]).push([[84629],{15680:(e,n,t)=>{t.d(n,{xA:()=>u,yg:()=>d});var a=t(296540);function i(e,n,t){return n in e?Object.defineProperty(e,n,{value:t,enumerable:!0,configurable:!0,writable:!0}):e[n]=t,e}function r(e,n){var t=Object.keys(e);if(Object.getOwnPropertySymbols){var a=Object.getOwnPropertySymbols(e);n&&(a=a.filter((function(n){return Object.getOwnPropertyDescriptor(e,n).enumerable}))),t.push.apply(t,a)}return t}function l(e){for(var n=1;n<arguments.length;n++){var t=null!=arguments[n]?arguments[n]:{};n%2?r(Object(t),!0).forEach((function(n){i(e,n,t[n])})):Object.getOwnPropertyDescriptors?Object.defineProperties(e,Object.getOwnPropertyDescriptors(t)):r(Object(t)).forEach((function(n){Object.defineProperty(e,n,Object.getOwnPropertyDescriptor(t,n))}))}return e}function o(e,n){if(null==e)return{};var t,a,i=function(e,n){if(null==e)return{};var t,a,i={},r=Object.keys(e);for(a=0;a<r.length;a++)t=r[a],n.indexOf(t)>=0||(i[t]=e[t]);return i}(e,n);if(Object.getOwnPropertySymbols){var r=Object.getOwnPropertySymbols(e);for(a=0;a<r.length;a++)t=r[a],n.indexOf(t)>=0||Object.prototype.propertyIsEnumerable.call(e,t)&&(i[t]=e[t])}return i}var m=a.createContext({}),p=function(e){var n=a.useContext(m),t=n;return e&&(t="function"==typeof e?e(n):l(l({},n),e)),t},u=function(e){var n=p(e.components);return a.createElement(m.Provider,{value:n},e.children)},s="mdxType",y={inlineCode:"code",wrapper:function(e){var n=e.children;return a.createElement(a.Fragment,{},n)}},g=a.forwardRef((function(e,n){var t=e.components,i=e.mdxType,r=e.originalType,m=e.parentName,u=o(e,["components","mdxType","originalType","parentName"]),s=p(t),g=i,d=s["".concat(m,".").concat(g)]||s[g]||y[g]||r;return t?a.createElement(d,l(l({ref:n},u),{},{components:t})):a.createElement(d,l({ref:n},u))}));function d(e,n){var t=arguments,i=n&&n.mdxType;if("string"==typeof e||i){var r=t.length,l=new Array(r);l[0]=g;var o={};for(var m in n)hasOwnProperty.call(n,m)&&(o[m]=n[m]);o.originalType=e,o[s]="string"==typeof e?e:i,l[1]=o;for(var p=2;p<r;p++)l[p]=t[p];return a.createElement.apply(null,l)}return a.createElement.apply(null,t)}g.displayName="MDXCreateElement"},880455:(e,n,t)=>{t.r(n),t.d(n,{assets:()=>m,contentTitle:()=>l,default:()=>y,frontMatter:()=>r,metadata:()=>o,toc:()=>p});var a=t(58168),i=(t(296540),t(15680));const r={title:"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6",language:"zh-CN"},l=void 0,o={unversionedId:"admin-manual/audit-plugin",id:"admin-manual/audit-plugin",title:"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6",description:"\x3c!--",source:"@site/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/audit-plugin.md",sourceDirName:"admin-manual",slug:"/admin-manual/audit-plugin",permalink:"/zh-CN/docs/dev/admin-manual/audit-plugin",draft:!1,tags:[],version:"current",frontMatter:{title:"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6",language:"zh-CN"},sidebar:"docs",previous:{title:"tables",permalink:"/zh-CN/docs/dev/admin-manual/system-tables/tables"},next:{title:"Config Action",permalink:"/zh-CN/docs/dev/admin-manual/fe/config-action"}},m={},p=[{value:"\u4f7f\u7528\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6",id:"\u4f7f\u7528\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6",level:2},{value:"\u5f00\u542f\u63d2\u4ef6",id:"\u5f00\u542f\u63d2\u4ef6",level:3},{value:"\u76f8\u5173\u914d\u7f6e",id:"\u76f8\u5173\u914d\u7f6e",level:3},{value:"\u7f16\u8bd1\u3001\u914d\u7f6e\u548c\u90e8\u7f72",id:"\u7f16\u8bd1\u914d\u7f6e\u548c\u90e8\u7f72",level:2},{value:"FE \u914d\u7f6e",id:"fe-\u914d\u7f6e",level:3},{value:"AuditLoader \u914d\u7f6e",id:"auditloader-\u914d\u7f6e",level:3},{value:"\u521b\u5efa\u5e93\u8868",id:"\u521b\u5efa\u5e93\u8868",level:3},{value:"\u90e8\u7f72",id:"\u90e8\u7f72",level:3},{value:"\u5b89\u88c5",id:"\u5b89\u88c5",level:3},{value:"FAQ",id:"faq",level:2}],u={toc:p},s="wrapper";function y(e){let{components:n,...t}=e;return(0,i.yg)(s,(0,a.A)({},u,t,{components:n,mdxType:"MDXLayout"}),(0,i.yg)("h1",{id:"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6"},"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6"),(0,i.yg)("p",null,"Doris \u7684\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\u662f\u5728 FE \u7684\u63d2\u4ef6\u6846\u67b6\u57fa\u7840\u4e0a\u5f00\u53d1\u7684\u3002\u662f\u4e00\u4e2a\u53ef\u9009\u63d2\u4ef6\u3002\u7528\u6237\u53ef\u4ee5\u5728\u8fd0\u884c\u65f6\u5b89\u88c5\u6216\u5378\u8f7d\u8fd9\u4e2a\u63d2\u4ef6\u3002"),(0,i.yg)("p",null,"\u8be5\u63d2\u4ef6\u53ef\u4ee5\u5c06 FE \u7684\u5ba1\u8ba1\u65e5\u5fd7\u5b9a\u671f\u7684\u5bfc\u5165\u5230\u6307\u5b9a\u7684\u7cfb\u7edf\u8868\u4e2d\uff0c\u4ee5\u65b9\u4fbf\u7528\u6237\u901a\u8fc7 SQL \u5bf9\u5ba1\u8ba1\u65e5\u5fd7\u8fdb\u884c\u67e5\u770b\u548c\u5206\u6790\u3002"),(0,i.yg)("h2",{id:"\u4f7f\u7528\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6"},"\u4f7f\u7528\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6"),(0,i.yg)("p",null,"\u4ece Doris 2.1 \u7248\u672c\u5f00\u59cb\uff0c\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\u4f5c\u4e3a\u5185\u7f6e\u63d2\u4ef6\uff0c\u76f4\u63a5\u96c6\u6210\u5230\u4e86 Doris \u5185\u6838\u4e2d\u3002\u7528\u6237\u65e0\u9700\u5728\u989d\u5916\u5b89\u88c5\u63d2\u4ef6\u3002"),(0,i.yg)("p",null,"\u96c6\u7fa4\u542f\u52a8\u540e\uff0c\u4f1a\u5728 ",(0,i.yg)("inlineCode",{parentName:"p"},"__internal_schema")," \u5e93\u4e0b\u521b\u5efa\u540d\u4e3a ",(0,i.yg)("inlineCode",{parentName:"p"},"audit_log")," \u7684\u7cfb\u7edf\u8868\uff0c\u7528\u4e8e\u5b58\u50a8\u5ba1\u8ba1\u65e5\u5fd7\u3002"),(0,i.yg)("blockquote",null,(0,i.yg)("ol",{parentName:"blockquote"},(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u5982\u679c\u662f\u4ece\u8001\u7248\u672c\u5347\u7ea7\u4e0a\u6765\u7684\u7528\u6237\uff0c\u53ef\u4ee5\u7ee7\u7eed\u4f7f\u7528\u4e4b\u524d\u7684\u65b9\u5f0f\u3002\u4e5f\u53ef\u4ee5\u5378\u8f7d\u4e4b\u524d\u7684\u63d2\u4ef6\uff0c\u4f7f\u7528\u5185\u7f6e\u63d2\u4ef6\u3002\u4f46\u6ce8\u610f\u5185\u7f6e\u63d2\u4ef6\u4f1a\u5c06\u65b0\u7684\u5ba1\u8ba1\u65e5\u5fd7\u5199\u5165\u5230\u65b0\u7684\u8868\u4e2d\uff0c\u800c\u4e0d\u662f\u539f\u6709\u7684\u5ba1\u8ba1\u65e5\u5fd7\u8868\u4e2d\u3002")),(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u5982\u679c\u662f Doris 2.1 \u4e4b\u524d\u7684\u7248\u672c\uff0c\u8bf7\u53c2\u9605\u4e4b\u540e\u7684 ",(0,i.yg)("strong",{parentName:"p"},"\u7f16\u8bd1\u3001\u914d\u7f6e\u548c\u90e8\u7f72")," \u7ae0\u8282\u3002")))),(0,i.yg)("h3",{id:"\u5f00\u542f\u63d2\u4ef6"},"\u5f00\u542f\u63d2\u4ef6"),(0,i.yg)("p",null,"\u901a\u8fc7\u5168\u5c40\u53d8\u91cf ",(0,i.yg)("inlineCode",{parentName:"p"},"enable_audit_plugin")," \u53ef\u4ee5\u968f\u65f6\u5f00\u542f\u6216\u5173\u95ed\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\uff08\u9ed8\u8ba4\u4e3a\u5173\u95ed\u72b6\u6001\uff09\uff0c\u5982\uff1a"),(0,i.yg)("p",null,(0,i.yg)("inlineCode",{parentName:"p"},"set global enable_audit_plugin = true;")),(0,i.yg)("p",null,"\u5f00\u542f\u540e\uff0cDoris \u4f1a\u5c06\u5f00\u542f\u540e\u7684\u5ba1\u8ba1\u65e5\u5fd7\u5199\u5165 ",(0,i.yg)("inlineCode",{parentName:"p"},"audit_log")," \u8868\u3002"),(0,i.yg)("p",null,"\u53ef\u4ee5\u968f\u65f6\u5173\u95ed\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\uff1a"),(0,i.yg)("p",null,(0,i.yg)("inlineCode",{parentName:"p"},"set global enable_audit_plugin = false;")),(0,i.yg)("p",null,"\u5173\u95ed\u540e\uff0cDoris \u5c06\u4f1a\u505c\u6b62 ",(0,i.yg)("inlineCode",{parentName:"p"},"audit_log")," \u8868\u7684\u5199\u5165\u3002\u5df2\u5199\u5165\u7684\u5ba1\u8ba1\u65e5\u5fd7\u4e0d\u4f1a\u53d8\u5316\u3002"),(0,i.yg)("h3",{id:"\u76f8\u5173\u914d\u7f6e"},"\u76f8\u5173\u914d\u7f6e"),(0,i.yg)("p",null,"\u5ba1\u8ba1\u65e5\u5fd7\u8868\u662f\u4e00\u5f20\u52a8\u6001\u5206\u533a\u8868\uff0c\u6309\u5929\u5206\u533a\uff0c\u9ed8\u8ba4\u4fdd\u7559\u6700\u8fd1 30 \u5929\u7684\u6570\u636e\u3002"),(0,i.yg)("p",null,"\u4ee5\u4e0b 3 \u4e2a\u5168\u5c40\u53d8\u91cf\u53ef\u4ee5\u63a7\u5236\u5ba1\u8ba1\u65e5\u5fd7\u8868\u7684\u4e00\u4e9b\u5199\u5165\u884c\u4e3a\uff1a"),(0,i.yg)("ul",null,(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("inlineCode",{parentName:"li"},"audit_plugin_max_batch_interval_sec"),"\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u7684\u6700\u5927\u5199\u5165\u95f4\u9694\u3002\u9ed8\u8ba4 60 \u79d2\u3002"),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("inlineCode",{parentName:"li"},"audit_plugin_max_batch_bytes"),"\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u6bcf\u6279\u6b21\u6700\u5927\u5199\u5165\u6570\u636e\u91cf\u3002\u9ed8\u8ba4 50MB\u3002"),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("inlineCode",{parentName:"li"},"audit_plugin_max_sql_length"),"\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u91cc\u8bb0\u5f55\u7684\u8bed\u53e5\u7684\u6700\u5927\u957f\u5ea6\u3002\u9ed8\u8ba4 4096\u3002"),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("inlineCode",{parentName:"li"},"audit_plugin_load_timeout"),": \u5ba1\u8ba1\u65e5\u5fd7\u5bfc\u5165\u4f5c\u4e1a\u7684\u9ed8\u8ba4\u8d85\u65f6\u65f6\u95f4\u3002\u9ed8\u8ba4 600 \u79d2\u3002")),(0,i.yg)("p",null,"\u53ef\u4ee5\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"set global xxx=yyy")," \u8fdb\u884c\u8bbe\u7f6e\u3002"),(0,i.yg)("h2",{id:"\u7f16\u8bd1\u914d\u7f6e\u548c\u90e8\u7f72"},"\u7f16\u8bd1\u3001\u914d\u7f6e\u548c\u90e8\u7f72"),(0,i.yg)("p",null,"Doris 2.1 \u7248\u672c\u4e4b\u524d\u7684\u7528\u6237\uff0c\u8bf7\u53c2\u9605\u5982\u4e0b\u65b9\u5f0f\u4f7f\u7528\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\u3002"),(0,i.yg)("h3",{id:"fe-\u914d\u7f6e"},"FE \u914d\u7f6e"),(0,i.yg)("p",null,"\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u4ef6\u6846\u67b6\u5728 Doris \u4e2d\u662f\u9ed8\u8ba4\u5f00\u542f\u7684\u7684\uff0c\u7531 FE \u7684\u914d\u7f6e ",(0,i.yg)("inlineCode",{parentName:"p"},"plugin_enable")," \u63a7\u5236"),(0,i.yg)("h3",{id:"auditloader-\u914d\u7f6e"},"AuditLoader \u914d\u7f6e"),(0,i.yg)("ol",null,(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u4e0b\u8f7d Audit Loader \u63d2\u4ef6"),(0,i.yg)("p",{parentName:"li"},"Audit Loader \u63d2\u4ef6\u5728 Doris \u7684\u53d1\u884c\u7248\u4e2d\u9ed8\u8ba4\u63d0\u4f9b\uff0c\u901a\u8fc7 ",(0,i.yg)("a",{parentName:"p",href:"https://doris.apache.org/zh-CN/download"},"DOWNLOAD")," \u4e0b\u8f7d Doris \u5b89\u88c5\u5305\u89e3\u538b\u5e76\u8fdb\u5165\u76ee\u5f55\u540e\u5373\u53ef\u5728 extensions/audit_loader \u5b50\u76ee\u5f55\u4e0b\u627e\u5230 auditloader.zip \u6587\u4ef6\u3002")),(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u89e3\u538b\u5b89\u88c5\u5305"),(0,i.yg)("pre",{parentName:"li"},(0,i.yg)("code",{parentName:"pre",className:"language-shell"},"unzip auditloader.zip\n")),(0,i.yg)("p",{parentName:"li"},"\u89e3\u538b\u751f\u6210\u4ee5\u4e0b\u6587\u4ef6\uff1a"),(0,i.yg)("ul",{parentName:"li"},(0,i.yg)("li",{parentName:"ul"},"auditloader.jar\uff1a\u63d2\u4ef6\u4ee3\u7801\u5305\u3002"),(0,i.yg)("li",{parentName:"ul"},"plugin.properties\uff1a\u63d2\u4ef6\u5c5e\u6027\u6587\u4ef6\u3002"),(0,i.yg)("li",{parentName:"ul"},"plugin.conf\uff1a\u63d2\u4ef6\u914d\u7f6e\u6587\u4ef6\u3002")))),(0,i.yg)("p",null,"\u60a8\u53ef\u4ee5\u5c06\u8fd9\u4e2a\u6587\u4ef6\u653e\u7f6e\u5728\u4e00\u4e2a http \u670d\u52a1\u5668\u4e0a\uff0c\u6216\u8005\u62f7\u8d1d",(0,i.yg)("inlineCode",{parentName:"p"},"auditloader.zip"),"(\u6216\u8005\u89e3\u538b",(0,i.yg)("inlineCode",{parentName:"p"},"auditloader.zip"),") \u5230\u6240\u6709 FE \u7684\u6307\u5b9a\u76ee\u5f55\u4e0b\u3002\u8fd9\u91cc\u6211\u4eec\u4f7f\u7528\u540e\u8005\u3002",(0,i.yg)("br",{parentName:"p"}),"\n","\u8be5\u63d2\u4ef6\u7684\u5b89\u88c5\u53ef\u4ee5\u53c2\u9605 ",(0,i.yg)("a",{parentName:"p",href:"/zh-CN/docs/dev/sql-manual/sql-statements/Database-Administration-Statements/INSTALL-PLUGIN"},"INSTALL"),(0,i.yg)("br",{parentName:"p"}),"\n","\u6267\u884c install \u540e\u4f1a\u81ea\u52a8\u751f\u6210 AuditLoader \u76ee\u5f55"),(0,i.yg)("ol",{start:3},(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u4fee\u6539 plugin.conf "),(0,i.yg)("p",{parentName:"li"},"\u4ee5\u4e0b\u914d\u7f6e\u53ef\u4f9b\u4fee\u6539\uff1a"),(0,i.yg)("ul",{parentName:"li"},(0,i.yg)("li",{parentName:"ul"},"frontend_host_port\uff1aFE \u8282\u70b9 IP \u5730\u5740\u548c HTTP \u7aef\u53e3\uff0c\u683c\u5f0f\u4e3a <fe_ip>:<fe_http_port>\u3002\u9ed8\u8ba4\u503c\u4e3a 127.0.0.1:8030\u3002"),(0,i.yg)("li",{parentName:"ul"},"database\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u5e93\u540d\u3002"),(0,i.yg)("li",{parentName:"ul"},"audit_log_table\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u540d\u3002"),(0,i.yg)("li",{parentName:"ul"},"slow_log_table\uff1a\u6162\u67e5\u8be2\u65e5\u5fd7\u8868\u540d\u3002"),(0,i.yg)("li",{parentName:"ul"},"enable_slow_log\uff1a\u662f\u5426\u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7\u5bfc\u5165\u529f\u80fd\u3002\u9ed8\u8ba4\u503c\u4e3a false\u3002\u53ef\u4ee5\u5728 FE \u914d\u7f6e\u9879\u4e2d\u914d\u7f6e\u6162\u67e5\u8be2\u7684\u9608\u503c\uff0c\u53c2\u6570\u4e3a qe_slow_log_ms\uff0c\u9ed8\u8ba4 5s\u3002"),(0,i.yg)("li",{parentName:"ul"},"user\uff1a\u96c6\u7fa4\u7528\u6237\u540d\u3002\u8be5\u7528\u6237\u5fc5\u987b\u5177\u6709\u5bf9\u5e94\u8868\u7684 INSERT \u6743\u9650\u3002"),(0,i.yg)("li",{parentName:"ul"},"password\uff1a\u96c6\u7fa4\u7528\u6237\u5bc6\u7801\u3002"))),(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u91cd\u65b0\u6253\u5305 Audit Loader \u63d2\u4ef6"),(0,i.yg)("pre",{parentName:"li"},(0,i.yg)("code",{parentName:"pre",className:"language-shell"},"zip -r -q -m auditloader.zip auditloader.jar plugin.properties plugin.conf\n")))),(0,i.yg)("h3",{id:"\u521b\u5efa\u5e93\u8868"},"\u521b\u5efa\u5e93\u8868"),(0,i.yg)("p",null,"\u5728 Doris \u4e2d\uff0c\u9700\u8981\u521b\u5efa\u5ba1\u8ba1\u65e5\u5fd7\u7684\u5e93\u548c\u8868\uff0c\u8868\u7ed3\u6784\u5982\u4e0b\uff1a"),(0,i.yg)("p",null,"\u82e5\u9700\u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7\u5bfc\u5165\u529f\u80fd\uff0c\u8fd8\u9700\u8981\u989d\u5916\u521b\u5efa\u6162\u8868 ",(0,i.yg)("inlineCode",{parentName:"p"},"doris_slow_log_tbl__"),"\uff0c\u5176\u8868\u7ed3\u6784\u4e0e ",(0,i.yg)("inlineCode",{parentName:"p"},"doris_audit_log_tbl__")," \u4e00\u81f4\u3002"),(0,i.yg)("p",null,"\u5176\u4e2d ",(0,i.yg)("inlineCode",{parentName:"p"},"dynamic_partition")," \u5c5e\u6027\u6839\u636e\u81ea\u5df1\u7684\u9700\u8981\uff0c\u9009\u62e9\u5ba1\u8ba1\u65e5\u5fd7\u4fdd\u7559\u7684\u5929\u6570\u3002"),(0,i.yg)("pre",null,(0,i.yg)("code",{parentName:"pre",className:"language-sql"},'create database doris_audit_db__;\n\ncreate table doris_audit_db__.doris_audit_log_tbl__\n(\n query_id varchar(48) comment "Unique query id",\n `time` datetime not null comment "Query start time",\n client_ip varchar(32) comment "Client IP",\n user varchar(64) comment "User name",\n db varchar(96) comment "Database of this query",\n state varchar(8) comment "Query result state. EOF, ERR, OK",\n error_code int comment "Error code of failing query.",\n error_message string comment "Error message of failing query.",\n query_time bigint comment "Query execution time in millisecond",\n scan_bytes bigint comment "Total scan bytes of this query",\n scan_rows bigint comment "Total scan rows of this query",\n return_rows bigint comment "Returned rows of this query",\n stmt_id int comment "An incremental id of statement",\n is_query tinyint comment "Is this statemt a query. 1 or 0",\n frontend_ip varchar(32) comment "Frontend ip of executing this statement",\n cpu_time_ms bigint comment "Total scan cpu time in millisecond of this query",\n sql_hash varchar(48) comment "Hash value for this query",\n sql_digest varchar(48) comment "Sql digest of this query, will be empty if not a slow query",\n peak_memory_bytes bigint comment "Peak memory bytes used on all backends of this query",\n stmt string comment "The original statement, trimed if longer than 2G"\n) engine=OLAP\nduplicate key(query_id, `time`, client_ip)\npartition by range(`time`) ()\ndistributed by hash(query_id) buckets 1\nproperties(\n "dynamic_partition.time_unit" = "DAY",\n "dynamic_partition.start" = "-30",\n "dynamic_partition.end" = "3",\n "dynamic_partition.prefix" = "p",\n "dynamic_partition.buckets" = "1",\n "dynamic_partition.enable" = "true",\n "replication_num" = "3"\n);\n\ncreate table doris_audit_db__.doris_slow_log_tbl__\n(\n query_id varchar(48) comment "Unique query id",\n `time` datetime not null comment "Query start time",\n client_ip varchar(32) comment "Client IP",\n user varchar(64) comment "User name",\n db varchar(96) comment "Database of this query",\n state varchar(8) comment "Query result state. EOF, ERR, OK",\n error_code int comment "Error code of failing query.",\n error_message string comment "Error message of failing query.",\n query_time bigint comment "Query execution time in millisecond",\n scan_bytes bigint comment "Total scan bytes of this query",\n scan_rows bigint comment "Total scan rows of this query",\n return_rows bigint comment "Returned rows of this query",\n stmt_id int comment "An incremental id of statement",\n is_query tinyint comment "Is this statemt a query. 1 or 0",\n frontend_ip varchar(32) comment "Frontend ip of executing this statement",\n cpu_time_ms bigint comment "Total scan cpu time in millisecond of this query",\n sql_hash varchar(48) comment "Hash value for this query",\n sql_digest varchar(48) comment "Sql digest of a slow query",\n peak_memory_bytes bigint comment "Peak memory bytes used on all backends of this query",\n stmt string comment "The original statement, trimed if longer than 2G "\n) engine=OLAP\nduplicate key(query_id, `time`, client_ip)\npartition by range(`time`) ()\ndistributed by hash(query_id) buckets 1\nproperties(\n "dynamic_partition.time_unit" = "DAY",\n "dynamic_partition.start" = "-30",\n "dynamic_partition.end" = "3",\n "dynamic_partition.prefix" = "p",\n "dynamic_partition.buckets" = "1",\n "dynamic_partition.enable" = "true",\n "replication_num" = "3"\n);\n')),(0,i.yg)("blockquote",null,(0,i.yg)("p",{parentName:"blockquote"},(0,i.yg)("strong",{parentName:"p"},"\u6ce8\u610f")),(0,i.yg)("p",{parentName:"blockquote"},"\u4e0a\u9762\u8868\u7ed3\u6784\u4e2d\uff1astmt string\uff0c\u8fd9\u4e2a\u53ea\u80fd\u5728 0.15 \u53ca\u4e4b\u540e\u7248\u672c\u4e2d\u4f7f\u7528\uff0c\u4e4b\u524d\u7248\u672c\uff0c\u5b57\u6bb5\u7c7b\u578b\u4f7f\u7528 varchar")),(0,i.yg)("h3",{id:"\u90e8\u7f72"},"\u90e8\u7f72"),(0,i.yg)("p",null,"\u60a8\u53ef\u4ee5\u5c06\u6253\u5305\u597d\u7684 auditloader.zip \u653e\u7f6e\u5728\u4e00\u4e2a http \u670d\u52a1\u5668\u4e0a\uff0c\u6216\u8005\u62f7\u8d1d ",(0,i.yg)("inlineCode",{parentName:"p"},"auditloader.zip")," \u5230\u6240\u6709 FE \u7684\u76f8\u540c\u6307\u5b9a\u76ee\u5f55\u4e0b\u3002"),(0,i.yg)("h3",{id:"\u5b89\u88c5"},"\u5b89\u88c5"),(0,i.yg)("p",null,"\u901a\u8fc7\u4ee5\u4e0b\u8bed\u53e5\u5b89\u88c5 Audit Loader \u63d2\u4ef6\uff1a"),(0,i.yg)("pre",null,(0,i.yg)("code",{parentName:"pre",className:"language-sql"},'INSTALL PLUGIN FROM [source] [PROPERTIES ("key"="value", ...)]\n')),(0,i.yg)("p",null,"\u8be6\u7ec6\u547d\u4ee4\u53c2\u8003\uff1a",(0,i.yg)("a",{parentName:"p",href:"../sql-manual/sql-statements/Database-Administration-Statements/INSTALL-PLUGIN"},"INSTALL-PLUGIN")),(0,i.yg)("p",null,"\u5b89\u88c5\u6210\u529f\u540e\uff0c\u53ef\u4ee5\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"SHOW PLUGINS")," \u770b\u5230\u5df2\u7ecf\u5b89\u88c5\u7684\u63d2\u4ef6\uff0c\u5e76\u4e14\u72b6\u6001\u4e3a ",(0,i.yg)("inlineCode",{parentName:"p"},"INSTALLED"),"\u3002"),(0,i.yg)("p",null,"\u5b8c\u6210\u540e\uff0c\u63d2\u4ef6\u4f1a\u4e0d\u65ad\u7684\u4ee5\u6307\u5b9a\u7684\u65f6\u95f4\u95f4\u9694\u5c06\u5ba1\u8ba1\u65e5\u5fd7\u63d2\u5165\u5230\u8fd9\u4e2a\u8868\u4e2d\u3002"),(0,i.yg)("h2",{id:"faq"},"FAQ"),(0,i.yg)("ol",null,(0,i.yg)("li",{parentName:"ol"},(0,i.yg)("p",{parentName:"li"},"\u5ba1\u8ba1\u65e5\u5fd7\u8868\u4e2d\u6ca1\u6709\u6570\u636e\uff0c\u6216\u8fd0\u884c\u4e00\u6bb5\u65f6\u95f4\u540e\uff0c\u4e0d\u518d\u8fdb\u5165\u65b0\u7684\u6570\u636e"),(0,i.yg)("p",{parentName:"li"},"\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u6b65\u9aa4\u6392\u67e5\uff1a"),(0,i.yg)("ul",{parentName:"li"},(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("p",{parentName:"li"},"\u68c0\u67e5\u5206\u533a\u662f\u5426\u88ab\u6b63\u5e38\u521b\u5efa"),(0,i.yg)("p",{parentName:"li"}," \u5ba1\u8ba1\u65e5\u5fd7\u8868\u662f\u4e00\u5f20\u6309\u5929\u5206\u533a\u7684\u52a8\u6001\u5206\u533a\u8868\uff0c\u9ed8\u8ba4\u4f1a\u521b\u5efa\u672a\u6765 3 \u5929\u7684\u5206\u533a\uff0c\u5e76\u4fdd\u7559\u5386\u53f2 30 \u5929\u7684\u5206\u533a\u3002\u53ea\u6709\u5206\u533a\u88ab\u6b63\u786e\u521b\u5efa\u540e\uff0c\u624d\u80fd\u6b63\u5e38\u5199\u5165\u5ba1\u8ba1\u65e5\u5fd7\u3002"),(0,i.yg)("p",{parentName:"li"}," \u53ef\u4ee5\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"show dynamic partition tables from __internal_schema")," \u67e5\u770b\u52a8\u6001\u5206\u533a\u7684\u8c03\u5ea6\u60c5\u51b5\uff0c\u5e76\u6839\u636e\u9519\u8bef\u539f\u56e0\u6392\u67e5\u3002\u53ef\u80fd\u5f97\u9519\u8bef\u539f\u56e0\u5305\u62ec\uff1a"),(0,i.yg)("ul",{parentName:"li"},(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("p",{parentName:"li"},"\u8282\u70b9\u6570\u5c0f\u4e8e\u6240\u9700\u526f\u672c\u6570\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u9ed8\u8ba4 3 \u526f\u672c\uff0c\u6240\u4ee5\u81f3\u5c11\u9700\u8981 3 \u53f0 BE \u8282\u70b9\u3002\u6216\u8005\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"alter table")," \u8bed\u53e5\u4fee\u6539\u526f\u672c\u6570\uff0c\u5982\uff1a"),(0,i.yg)("p",{parentName:"li"}," ",(0,i.yg)("inlineCode",{parentName:"p"},'alter table __internal_schema.audit_log set ("dynamic_partition.replication_num" = "2")'))),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("p",{parentName:"li"},"\u6ca1\u6709\u5408\u9002\u7684\u5b58\u50a8\u4ecb\u8d28\uff1a\u53ef\u4ee5\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"show create table __internal_schema.audit_log")," \u67e5\u770b ",(0,i.yg)("inlineCode",{parentName:"p"},"storage_medium")," \u5c5e\u6027\uff0c\u5982\u679c BE \u6ca1\u6709\u5bf9\u5e94\u7684\u5b58\u50a8\u4ecb\u8d28\uff0c\u5219\u5206\u533a\u53ef\u80fd\u521b\u5efa\u5931\u8d25\u3002")),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("p",{parentName:"li"},"\u6ca1\u6709\u5408\u9002\u7684\u8d44\u6e90\u7ec4\uff1a\u5ba1\u8ba1\u65e5\u5fd7\u8868\u9ed8\u8ba4\u5728 default \u8d44\u6e90\u7ec4\u3002\u53ef\u4ee5\u901a\u8fc7 ",(0,i.yg)("inlineCode",{parentName:"p"},"show backends")," \u547d\u4ee4\u67e5\u770b\u8be5\u8d44\u6e90\u81ea\u662f\u5426\u6709\u8db3\u591f\u7684\u8282\u70b9\u8d44\u6e90\u3002")))),(0,i.yg)("li",{parentName:"ul"},(0,i.yg)("p",{parentName:"li"},"\u5728 Master FE \u7684 ",(0,i.yg)("inlineCode",{parentName:"p"},"fe.log")," \u4e2d\u641c\u7d22 ",(0,i.yg)("inlineCode",{parentName:"p"},"AuditLoad")," \u5b57\u6837\uff0c\u67e5\u770b\u662f\u5426\u6709\u76f8\u5173\u9519\u8bef\u65e5\u5fd7"),(0,i.yg)("p",{parentName:"li"}," \u5ba1\u8ba1\u65e5\u5fd7\u662f\u901a\u8fc7\u5185\u90e8\u7684 stream load \u64cd\u4f5c\u5bfc\u5165\u5230\u8868\u4e2d\u7684\uff0c\u6709\u53ef\u80fd\u662f\u5bfc\u5165\u6d41\u7a0b\u51fa\u73b0\u4e86\u95ee\u9898\uff0c\u8fd9\u4e9b\u95ee\u9898\u4f1a\u5728 ",(0,i.yg)("inlineCode",{parentName:"p"},"fe.log")," \u4e2d\u6253\u5370\u9519\u8bef\u65e5\u5fd7\u3002"))))))}y.isMDXComponent=!0}}]); |