1"use strict";(self.webpackChunkmy_seagm_tech_site=self.webpackChunkmy_seagm_tech_site||[]).push([[7982],{9255:(e,n,r)=>{r.r(n),r.d(n,{assets:()=>d,contentTitle:()=>l,default:()=>u,frontMatter:()=>o,metadata:()=>s,toc:()=>i});const s=JSON.parse('{"id":"tech/MySQL/ali_sls_sql-query","title":"Ali SLS\u65e5\u5fd7 SQL \u67e5\u8be2","description":"\u65e5\u5fd7\u6574\u4f53\u7edf\u8ba1\u5206\u6790","source":"@site/docs/tech/MySQL/ali_sls_sql-query.md","sourceDirName":"tech/MySQL","slug":"/tech/MySQL/ali_sls_sql-query","permalink":"/docs/tech/MySQL/ali_sls_sql-query","draft":false,"unlisted":false,"editUrl":"https://gitea.seagm.tech/jihong/my-seagm-tech-site/src/branch/main/docs/tech/MySQL/ali_sls_sql-query.md","tags":[{"inline":true,"label":"sql\u4f18\u5316","permalink":"/docs/tags/sql\u4f18\u5316"},{"inline":true,"label":"\u963f\u91cc\u4e91\u65e5\u5fd7","permalink":"/docs/tags/\u963f\u91cc\u4e91\u65e5\u5fd7"},{"inline":true,"label":"\u62a5\u8868","permalink":"/docs/tags/\u62a5\u8868"}],"version":"current","frontMatter":{"title":"Ali SLS\u65e5\u5fd7 SQL \u67e5\u8be2","tags":["sql\u4f18\u5316","\u963f\u91cc\u4e91\u65e5\u5fd7","\u62a5\u8868"]},"sidebar":"techSidebar","previous":{"title":"MySQL\u7b14\u8bb0","permalink":"/docs/tech/MySQL/"},"next":{"title":"Mac Mariadb|Mysql8 \u5b89\u88c5|\u914d\u7f6e|\u5907\u4efd|\u8fd8\u539f","permalink":"/docs/tech/MySQL/mac-homebrew-insstall-mariadb"}}');var a=r(4848),t=r(8453);const o={title:"Ali SLS\u65e5\u5fd7 SQL \u67e5\u8be2",tags:["sql\u4f18\u5316","\u963f\u91cc\u4e91\u65e5\u5fd7","\u62a5\u8868"]},l="Ali SLS\u65e5\u5fd7 SQL \u67e5\u8be2",d={},i=[{value:"\u65e5\u5fd7\u6574\u4f53\u7edf\u8ba1\u5206\u6790",id:"\u65e5\u5fd7\u6574\u4f53\u7edf\u8ba1\u5206\u6790",level:2},{value:"\u7528\u6237\u65e5\u5fd7\u67e5\u8be2\u5206\u6790",id:"\u7528\u6237\u65e5\u5fd7\u67e5\u8be2\u5206\u6790",level:2},{value:"\u5168\u6587\u67e5\u8be2",id:"\u5168\u6587\u67e5\u8be2",level:2},{value:"\u5b57\u6bb5\u67e5\u8be2",id:"\u5b57\u6bb5\u67e5\u8be2",level:2},{value:"\u963f\u91ccSLS \u6587\u6863",id:"\u963f\u91ccsls-\u6587\u6863",level:2},{value:"group by",id:"group-by",level:3},{value:"\u65f6\u95f4\u8f6c\u6362\uff1a",id:"\u65f6\u95f4\u8f6c\u6362",level:3}];function c(e){const n={a:"a",code:"code",h1:"h1",h2:"h2",h3:"h3",header:"header",li:"li",pre:"pre",ul:"ul",...(0,t.R)(),...e.components};return(0,a.jsxs)(a.Fragment,{children:[(0,a.jsx)(n.header,{children:(0,a.jsx)(n.h1,{id:"ali-sls\u65e5\u5fd7-sql-\u67e5\u8be2",children:"Ali SLS\u65e5\u5fd7 SQL \u67e5\u8be2"})}),"\n",(0,a.jsx)(n.h2,{id:"\u65e5\u5fd7\u6574\u4f53\u7edf\u8ba1\u5206\u6790",children:"\u65e5\u5fd7\u6574\u4f53\u7edf\u8ba1\u5206\u6790"}),"\n",(0,a.jsx)(n.pre,{children:(0,a.jsx)(n.code,{className:"language-sql",children:"########################### resource \u5206\u7ec4\u7edf\u8ba1 ###########################\n* | SELECT count(resource) as count ,resource ,date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day,resource order by day,count desc LIMIT 1000000\n########################### resource \u5206\u7ec4\u7edf\u8ba1 ###########################\n\n########################### user operation \u5206\u7ec4\u7edf\u8ba1 ###########################\n* and resource: user | SELECT count(resource) as count, operation, date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day,operation order by day, count desc LIMIT 1000000\n########################### user operation \u5206\u7ec4\u7edf\u8ba1 ###########################\n\n########################### \u7279\u5b9aIP operation \u5206\u7ec4\u7edf\u8ba1 ###########################\n * and (ip :23.22.35.162 or ip: 3.224.220.101) | SELECT count(resource) as count, resource, operation, date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day, resource, operation order by day, count desc LIMIT 1000000\n########################### \u7279\u5b9aIP operation \u5206\u7ec4\u7edf\u8ba1 ###########################\n\n########################### user \u8d26\u53f7\u98ce\u63a7 \u5206\u7ec4\u7edf\u8ba1 ###########################\n* and resource: user and (operation : login* OR operation register*) | SELECT count(resource) as count, operation, date_trunc('month', created) AS day WHERE relative_id IS NOT null group by day,operation order by day, count desc LIMIT 1000000\n########################### user \u8d26\u53f7\u98ce\u63a7 \u5206\u7ec4\u7edf\u8ba1 ###########################\n\n"})}),"\n",(0,a.jsx)(n.h2,{id:"\u7528\u6237\u65e5\u5fd7\u67e5\u8be2\u5206\u6790",children:"\u7528\u6237\u65e5\u5fd7\u67e5\u8be2\u5206\u6790"}),"\n",(0,a.jsx)(n.pre,{children:(0,a.jsx)(n.code,{className:"language-sql",children:"########################### \u767b\u5f55\u6210\u529f\u65e5\u5fd7 ###########################\n# \u6e05\u5355\n* and resource: user and operation: login-result and message: success* | SELECT created,operation,relative_id,ip,resource,message WHERE relative_id IS NOT null LIMIT 1000000\n# app\u6e05\u5355\n* and resource: user and operation: login-result and message: success* | SELECT created,operation,relative_id,ip,resource,message WHERE message like '%app%' LIMIT 1000000\n# web\u6e05\u5355\n* and resource: user and operation: login-result and message: success* | SELECT created,operation,relative_id,ip,resource,message WHERE message like '%web%' LIMIT 1000000\n# \u6570\u91cf\u7edf\u8ba1\uff08\u6309\u5929\u5206\u7ec4\u7edf\u8ba1\uff09\n* and resource: user and operation: login-result and message: success* | SELECT count(resource) ,message,date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day,message order by day LIMIT 1000000\n########################### \u767b\u5f55\u6210\u529f\u65e5\u5fd7 ###########################\n\n########################### \u767b\u5f55\u5931\u8d25\u65e5\u5fd7 ###########################\n# \u6e05\u5355\n* and resource: user and operation: login-result and message: Wrong* | SELECT created,operation,relative_id,ip,resource,message WHERE relative_id IS NOT null LIMIT 1000000\n# \u6570\u91cf\u7edf\u8ba1\uff08\u6309\u5929\u5206\u7ec4\u7edf\u8ba1\uff09\n* and resource: user and operation: login-result and message: Wrong* | SELECT count(resource) as count ,date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day order by day LIMIT 1000000\n########################### \u767b\u5f55\u5931\u8d25\u65e5\u5fd7 ###########################\n\n\n########################### \u65e0\u6548\u90ae\u7bb1\u65e5\u5fd7 ###########################\n# \u6e05\u5355\n* and resource: user and operation: login-result and message: Email* | SELECT created,operation,relative_id,ip,resource,message WHERE relative_id IS NOT null LIMIT 1000000\n# \u6570\u91cf\u7edf\u8ba1\uff08\u6309\u5929\u5206\u7ec4\u7edf\u8ba1\uff09\n* and resource: user and operation: login-result and message: Email* | SELECT count(resource) as count ,date_trunc('day', created) AS day WHERE relative_id IS NOT null group by day order by day LIMIT 1000000\n########################### \u65e0\u6548\u90ae\u7bb1\u65e5\u5fd7 ###########################\n\n"})}),"\n",(0,a.jsx)(n.h2,{id:"\u5168\u6587\u67e5\u8be2",children:"\u5168\u6587\u67e5\u8be2"}),"\n",(0,a.jsx)(n.pre,{children:(0,a.jsx)(n.code,{className:"language-sql",children:"########################### \u5168\u6587\u67e5\u8be2\u8bed\u6cd5 ###########################\nkeyword1 [ [ and | or | not ] keywords2 ] ...\n\n# \u5168\u6587\u67e5\u8be2\u4e0d\u9488\u5bf9\u5177\u4f53\u7684\u5b57\u6bb5\u8fdb\u884c\u67e5\u8be2\uff0c\u5176\u67e5\u8be2\u8bed\u6cd5\u4e3a\uff1a\n# - keywords1 \u662f\u9700\u8981\u67e5\u8be2\u7684\u5173\u952e\u8bcd\uff0c\u53ef\u4ee5\u4f7f\u7528 *\u3001\uff1f\u8fdb\u884c\u6a21\u7cca\u5339\u914d\uff0c\u4e5f\u53ef\u4ee5\u7ed3\u5408\u8fd0\u7b97\u7b26\u5982 and\u3001or \u7b49\u8054\u5408\u5176\u4ed6\u67e5\u8be2\u6761\u4ef6\u4e00\u8d77\u67e5\u8be2\u3002\n# - \u6848\u4f8b1\uff1a\u5e0c\u671b\u67e5\u8be2\u5173\u952e\u8bcd\u4e3a Nginx \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u53e5\uff1aNginx\u3002\n# - \u6848\u4f8b2\uff1a\u67e5\u8be2\u5173\u952e\u8bcd\u4e3a Nginx \u6216 Tomcat \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u53e5\uff1aNginx or Tomcat\u3002\n# - \u6848\u4f8b3\uff1a\u671f\u671b\u67e5\u8be2\u57df\u540d\u4e3a aliyun.com \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u53e5\u4e3a\uff1a*.aliyun.com\u3002\n########################### \u5168\u6587\u67e5\u8be2\u8bed\u6cd5 ###########################\n"})}),"\n",(0,a.jsx)(n.h2,{id:"\u5b57\u6bb5\u67e5\u8be2",children:(0,a.jsx)(n.a,{href:"https://www.alibabacloud.com/help/zh/sls/user-guide/search-syntax?spm=5176.2020520112.help.dexternal.42a13efdDoB4Rf#section-k4z-jsc-ry",children:"\u5b57\u6bb5\u67e5\u8be2"})}),"\n",(0,a.jsx)(n.pre,{children:(0,a.jsx)(n.code,{className:"language-sql",children:'########################### \u5b57\u6bb5\u67e5\u8be2\u8bed\u6cd5 ###########################\nindexname1 [ : | > | >= | < | <= | = | in ] keyword1 [ [ and | or | not ] indexname2 ... ]\n\n# \u5b57\u6bb5\u67e5\u8be2\u5bf9\u5e94\u7684\u5b57\u6bb5\u7c7b\u578b\u5305\u542btext\u3001long\u3001double\u3001JSON\uff0c\u4e14\u9488\u5bf9\u5177\u4f53\u7684\u5b57\u6bb5\u8fdb\u884c\u67e5\u8be2\uff0c\u5176\u67e5\u8be2\u8bed\u6cd5\u4e3a\uff1a\n# - indexname1 \u662f\u9700\u8981\u67e5\u8be2\u7684\u5b57\u6bb5\u540d\uff0c\u5f53\u5b57\u6bb5\u540d\u3001\u8868\u540d\u7b49\u4e13\u6709\u540d\u8bcd\u4e2d\u5b58\u5728\u7279\u6b8a\u5b57\u7b26\uff08\u7a7a\u683c\u3001\u4e2d\u6587\u7b49\uff09\u3001\u8bed\u6cd5\u5173\u952e\u8bcd\uff08and\u3001or\u7b49\uff09\u7b49\u5185\u5bb9\u65f6\uff0c\u5219\u9700\u8981\u4f7f\u7528""\uff08\u53cc\u5f15\u53f7\uff09\u5305\u88f9\u3002\u5728\u67e5\u8be2\u4e2d\u4f7f\u7528\u5f15\u53f7\uff0c\u8bf7\u53c2\u89c1\u5982\u4f55\u5728\u67e5\u8be2\u548c\u5206\u6790\u8bed\u53e5\u4e2d\u4f7f\u7528\u5f15\u53f7\u3002\n# - \u5b57\u6bb5\u7d22\u5f15\u6d89\u53calong\u3001double\u7c7b\u578b\uff0c\u53ef\u4ee5\u4f7f\u7528\u6bd4\u8f83\u8fd0\u7b97\u7b26>\u3001>=\u3001<\u3001<=\u3001=\u3001in\u3002\n# - \u6848\u4f8b1\uff1a\u5e0c\u671b\u67e5\u8be2 requestMethod \u4e3a GET \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u6cd5\u4e3a\uff1arequestMethod: GET\u3002\n# - \u6848\u4f8b2\uff1a\u5e0c\u671b\u67e5\u8be2 requestTimeSpend \u5927\u4e8e 500ms \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u6cd5\u4e3arequestTimeSpend > 500\uff08\u8be5\u5b57\u6bb5\u7d22\u5f15\u7c7b\u578b\u4e3along\uff09\u3002\n# - \u6848\u4f8b3\uff1a\u5e0c\u671b\u67e5\u8be2 requestMethod \u4e3a GET \u4e14 requestTimeSpend \u5927\u4e8e 500ms \u76f8\u5173\u7684\u65e5\u5fd7\u3002\u5219\u67e5\u8be2\u8bed\u6cd5\u4e3a\uff1arequestMethod: GET and requestTimeSpend > 500\n########################### \u5b57\u6bb5\u67e5\u8be2\u8bed\u6cd5 ###########################\n'})}),"\n",(0,a.jsx)(n.h2,{id:""}),"\n",(0,a.jsx)(n.h2,{id:"\u963f\u91ccsls-\u6587\u6863",children:"\u963f\u91ccSLS \u
16587\u6863"}),"\n",(0,a.jsx)(n.h3,{id:"group-by",children:(0,a.jsx)(n.a,{href:"https://www.alibabacloud.com/help/zh/sls/user-guide/group-by-clause",children:"group by"})}),"\n",(0,a.jsx)(n.pre,{children:(0,a.jsx)(n.code,{className:"language-sql",children:"SELECT \n key,\n ...\n aggregate function \n GROUP BY \n key,...\n"})}),"\n",(0,a.jsx)(n.h3,{id:"\u65f6\u95f4\u8f6c\u6362",children:"\u65f6\u95f4\u8f6c\u6362\uff1a"}),"\n",(0,a.jsxs)(n.ul,{children:["\n",(0,a.jsx)(n.li,{children:(0,a.jsx)(n.a,{href:"https://www.alibabacloud.com/help/zh/sls/user-guide/date-and-time-functions-1#section-rnl-y4a-oxz",children:"\u4e00\u5e74\u7684\u5468\u6570\uff08year of week\uff09\uff1ayow\u51fd\u6570"})}),"\n",(0,a.jsx)(n.li,{children:(0,a.jsx)(n.a,{href:"https://www.alibabacloud.com/help/zh/sls/user-guide/date-and-time-functions-1#section-zpc-jv2-4fb",children:"\u65f6\u95f4\u6233\u8f6c\u5e74\u6708\u65e5\uff1adate_trunc\u51fd\u6570"})}),"\n"]})]})}function u(e={}){const{wrapper:n}={...(0,t.R)(),...e.components};return n?(0,a.jsx)(n,{...e,children:(0,a.jsx)(c,{...e})}):c(e)}},8453:(e,n,r)=>{r.d(n,{R:()=>o,x:()=>l});var s=r(6540);const a={},t=s.createContext(a);function o(e){const n=s.useContext(t);return s.useMemo((function(){return"function"==typeof e?e(n):{...n,...e}}),[n,e])}function l(e){let n;return n=e.disableParentContext?"function"==typeof e.components?e.components(a):e.components||a:o(e.components),s.createElement(t.Provider,{value:n},e.children)}}}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.