将INFORMIX里连接超过半个小时里没有动作的进程KILL掉

字数 3231阅读 2880评论 0赞 0

informix 经常因为连接数的限制和其他的原因，一些用户长期占用资源，但是不操作；而其他的用户则连接不上，导致资源分配的不合理。以下脚本将连接超过30分钟，而没有操作的进程kill掉，释放出资源。<div>以下是脚本的内容：</div><div><div>#!/bin/ksh</div><div>#设置INFORMIX环境信息</div><div>INFORMIXSERVER=on_shm01;export INFORMIXSERVER ONCONFIG=onconfig.on_01;export ONCONFIG DB_LOCALE=zh_tw.big5;export DB_LOCALE SERVER_LOCALE=zh_tw.big5;export SERVER_LOCALE CLIENT_LOCALE=zh_tw.big5;export CLIENT_LOCALE LANG=zh_tw.big5;export LANG</div><div><br></div><div>echo "INFORMIXSERVER=$INFORMIXSERVER"</div><div>echo "ONCONFIG=$ONCONFIG"</div><div><br></div><div>INFORMIXDIR=/u1/informix;export INFORMIXDIR PATH=$INFORMIXDIR/bin:$PATH;export PATH DBDATE=Y4MD/;export DBDATE DBCENTURY=C;export DBCENTURY DBDELIMITER='^A';export DBDELIMITER</div><div><br></div><div>#检查参数</div><div>if [ $# -ne 1 ] ; then</div><div>echo "Usage: killidle.sh idletime "</div><div>echo "Ex: killidle.sh 1800 "</div><div>exit</div><div>fi</div><div><br></div><div>idle=$1</div><div>now=`date | awk '{ print $4 }'`</div><div>kill_time=`date '+%y/%m/%d-%H:%M:%S'`</div><div>echo "kill_time:$kill_time"</div><div>tsNow=0</div><div>hhn=`echo $now | cut -d':' -f 1`</div><div>mmn=`echo $now | cut -d':' -f 2`</div><div>ssn=`echo $now | cut -d':' -f 3`</div><div>tsNow=`expr $hhn * 3600 + $mmn * 60 + $ssn`</div><div><br></div><div>ToSec() {</div><div># $1 : opentime</div><div>hh1=`echo $1 | cut -d':' -f 1`</div><div>mm1=`echo $1 | cut -d':' -f 2`</div><div>ss1=`echo $1 | cut -d':' -f 3`</div><div>ts1=`expr $hh1 * 3600 + $mm1 * 60 + $ss1 ` </div><div># $2 : writetime </div><div>hh2=`echo $2 | cut -d':' -f 1` </div><div>mm2=`echo $2 | cut -d':' -f 2` </div><div>ss2=`echo $2 | cut -d':' -f 3` </div><div>ts2=`expr $hh2 * 3600 + $mm2 * 60 + $ss2 ` if [ ts1 -gt ts2 ] ;</div><div>then</div><div>ts=`expr $tsNow - $ts1`</div><div>else</div><div>ts=`expr $tsNow - $ts2`</div><div>fi</div><div>#echo $ts</div><div>}</div><div><br></div><div>i=0</div><div>cnt=1</div><div>sesID=""</div><div>opnetime=""</div><div>readtime=""</div><div>writetime=""</div><div><br></div><div>#获取informix sesion</div><div>onstat -g ses > t1.tmp</div><div>tail +6 t1.tmp>ifx_u.tmp</div><div>rm t1.tmp</div><div>ps -ef|awk '{print $1 $2}' > ps_ef.tmp</div><div><br></div><div>#获取每个session的开始连接和最后1次读写时间</div><div>for f in `onstat -g ntt | grep sqlexec | awk '{ print $3,$4,$5,$6 }'` do</div><div>i=`expr $i + 1`</div><div>case $i in</div><div>1) sesID=$f</div><div>;;</div><div>2) opentime=$f</div><div>;;</div><div>3) readtime=$f</div><div>;;</div><div>4) writetime=$f</div><div>ToSec $readtime $writetime</div><div># echo "Session ID:$sesID , opentime:$opentime , readtime:$readtime , writetime:$writetime , idle time:$ts Sec. "</div><div>if [ $ts -gt $idle ] ; # 比较 idle time</div><div>then</div><div>echo "$cnt)SeID:$sesID,OTime:$opentime,RTime:$readtime,WTime:$writetime,IdleTime:$ts Sec."</div><div>while read L1</div><div>do</div><div>t_ses=`echo $L1 | awk '{ print $1 }'`</div><div># echo "$L1,t_ses is: $t_ses -sesID is :$sesID"</div><div>if [ $t_ses -eq $sesID ] ;</div><div>then</div><div>t_uname=`echo $L1 | awk '{ print $2 }'` # session woner</div><div>t_kill=`grep $t_uname $INFORMIXDIR/top_nokill.list | grep -v grep | wc | awk '{ print $1 }'`</div><div>if [ t_kill -eq 0 ]; # pGb top_nokill.list,NnR</div><div>then</div><div>t_pid=`echo $L1 | awk '{ print $4 }'`</div><div>## t_pid_no=`ps -ef | grep $t_pid | grep -v grep | wc | awk '{ print $1 }'`</div><div>t_pid_no=`grep $t_pid ps_ef.tmp|wc -l`</div><div>t_tty=`echo $L1 | awk '{ print "pts/",$3 }' | tr -d ' '`</div><div>t_host=`echo $L1 | awk '{ print $5 }'`</div><div>kill_time=`date '+%H:%M:%S'`</div><div>if [ $t_pid_no -eq 1 ] ;</div><div>then</div><div>echo "Kill:PID:$t_pid,Uname:$t_uname,Tty:$t_tty,pid_no:$t_pid_no,time:$kill_time"</div><div><br></div><div>onmode -z $t_ses</div><div>kill -9 $t_pid</div><div>else</div><div>echo "Keep(1):PID:$t_pid ,Uname:$t_uname ,tty:$t_tty,pid_no:$t_pid_no"</div><div><br></div><div>fi</div><div>else</div><div>echo "Keep(2):PID:$t_pid ,Uname:$t_uname ,tty:$t_tty"</div><div>fi</div><div>break;</div><div>fi</div><div>done < ifx_u.tmp</div><div>cnt=`expr $cnt + 1`</div><div>fi</div><div>i=0;;</div><div>esac</div><div>done</div><div>kill_time=`date '+%y/%m/%d-%H:%M:%S'`</div><div>echo "kill_time:$kill_time"</div><div>rm ifx_u.tmp</div><div>rm ps_ef.tmp</div></div><div>-------------------------</div><div><br></div><div>将此脚本放入crontab中 设置成每30分钟执行次。</div><div>但是一定是root用户，因为其他的用户无法kill非自己的用户的进程</div><div><br></div><div><div># crontab -l</div><div>0,30 8,9,10,11,12,13,14,15,16,17 * * * sh /u1/informix/killidle.sh 1800 >>killidle.log 2>&1</div></div><div><br></div>

数据库

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！

添加新评论0 条评论

Ctrl+Enter 发表

匿名评论

将INFORMIX里连接超过半个小时里没有动作的进程KILL掉

添加新评论0 条评论

作者其他文章

相关文章

相关问题

相关资料