tidb节点内存不释放导致节点重启

🪐 TiDB 技术问题
13

超过内存限制或者时间限制的SQL直接干掉的脚本，这个比设置参数有效

for list in /server/mysql5.7/bin/mysql -hXX.XX.XX.XX -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 -hXX.XX.XX.XX -p’password’ -vvv -e “select id,time,info,mem from INFORMATION_SCHEMA.processlist a where id=$list and a.info is not null;;” > /sh/killlog/date +%s.log
/server/mysql5.7/bin/mysql -hXX.XX.XX.XX -p’password’ -vvv -e " kill tidb $list ;"
done;