为了限制查询时长,为用户zy1_zhang设置了策略
create workload policy zy1
conditions(username='zy1_zhang')
actions(set_session_variable 'workload_group=analysis_g1') ;
而这个workload_group
create workload group if not exists analysis_g1
properties (
"cpu_share"="60",
"memory_limit"="60%",
"enable_memory_overcommit"="false",
"max_concurrency"="2000",
"max_queue_size"="2000",
"queue_timeout"="30000"
);
为什么当这个zy1_zhang用户执行查询的时候,还是走的normal组呢?
以下是日志:
2024-12-10 14:48:33,764 [query] |Client=192.1.1.28:57450|User=zy1_zhang|Ctl=internal|Db=new_pro|State=EOF|ErrorCode=0|Err
orMessage=|Time(ms)=34|ScanBytes=3514368|ScanRows=44704|ReturnRows=200|StmtId=1557558|QueryId=95f0af53c35e4955-a5337188d1048c4b|IsQuery
=true|isNereids=true|feIp=192.1.1.144|Stmt=/* ApplicationName=DBeaver 23.3.0 - SQLEditor <Script-1.sql> */ select rowkey uid,mobile_pho
ne phone from ods_user WHERE rowkey >=8000000 and rowkey < 9000000 and mobile_phone is not null ^M LIMIT 0, 200|CpuTimeMS=284|ShuffleS
endBytes=41639|ShuffleSendRows=800|SqlHash=c321393c2c1917df2f2a6f1628b696b6|peakMemoryBytes=6434976|SqlDigest=|TraceId=|WorkloadGroup=n
ormal|FuzzyVariables=