doris查询优化-内存调整

• 内存不足错误 Memory limit exceeded

EROR 185 (t08): errcode = 2, detailvessape = emory limit exceded:<conswmine tracker:<0eryId-ca2fc9947734a51-97f87c78576ee3>, failed alloc size 2.2 M, exc
eded tracker:0eryId-ca2fc947734a51-97f87c780576ee3>, limit 2.08 6, peak used 2.48 6B, curent used 2.84 68>, executine mse:x<execute:<scamner0weryId-c8a2fc9947
34a51-97f8e7c78576e3>>. 

解决方法：
1.查看exec_mem_limit大小，默认为不超过2G

SHOW VARIABLES LIKE "%mem_limit%";

2.修改exec_mem_limit

SET exec_mem_limit = 8589934592; //只在当前session有效

SET GLOBAL  exec_mem_limit = 8589934592; //设置8G永久生效