tidb集群,单个sql会话查询超过参数限制,并没有报出OOM,内存达到37G时,才发生OOM

我一般都是脚本kill

for list in /server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p'PASSWORD' -vvv -e " select id from INFORMATION_SCHEMA.processlist a where a.info is not null and (mem >=11474836480 or time >600);" |grep -Ev 'id|ID|iD|Id' |awk -F "|" '{print $2}'
do
echo $list
/server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p’PASSWORD’ -vvv -e “select id,time,info,mem from INFORMATION_SCHEMA.processlist a where id=$list and a.info is not null;;” >/sh/killtestlog/date +%s.log
/server/mysql5.7/bin/mysql -hXXX.XXX.XXX.XXX-p’PASSWORD’ -vvv -e " kill tidb $list ;"
done;

1 个赞