Linux监控mysqld占用内存大小、超标了然后重启mysql的shell脚本

2013-09-28 03:32 系统架构狂奔的蜗牛

```shell
#!/bin/bash
function get
{
   case "$2" in
       mem)   
       echo `ps aux |grep $1|awk '{c=split($11,n,"/");if(name == n[c]){print $4;}}' name=$1`
       ;;     
       pid)   
       echo `ps aux |grep $1|awk '{c=split($11,n,"/");if(name == n[c]){print $2;}}' name=$1`
       ;;     
   esac
}
printf "\n----- ----- %s ----- -----\n\n" $(date "+%Y-%m-%d_%H:%M:%S")
mem=`get mysqld mem`
echo $mem
if [ "$mem" != "" ];then
  if [ `echo "$mem > 60.0"|bc` -eq 1 ];then
     echo "Mysqld use too many memory:$mem"
     echo "Now restart it..."
     pid1=`get mysqld pid`
     service mysqld restart &
     sleep 20
     pid2=`get mysqld pid`
     if [ "$pid1" == "$pid2" ];then
        kill %1
        killall -9 mysqld
        killall -9 mysqld_safe
        sleep 2
        service mysqld start
        sleep 5
     fi
     pid=`get mysqld pid`
     if [ "$pid" != "" ];then
         echo  "start mysql success,PID:$pid"
     else   
         echo "start mysql fail"
     fi
  fi
else
  echo "mysqld not running."
  echo "Now start it..."
  service mysqld start
fi
printf "\n----- ----- %s ----- -----\n\n" $(date "+%Y-%m-%d_%H:%M:%S")
```

作者：狂奔的蜗牛 出处： http://www.host900.com/

本文版权归作者所有，欢迎转载。未经作者同意下，必须在文章页面明显标出原文链接及作者，否则保留追究法律责任的权利。

如果您认为这篇文章还不错或者有所收获，可以分享给您的小伙伴，因为你的支持是我继续写作，分享的最大动力！

上一篇linux mint 15 pppoe拨号上网手记

下一篇pure-ftpd安装笔记