shell脚本之监控mysql数据库。

  1 #!/bin/bash
  2 #grep -v grep 就是查找不含有 grep 字段的行
  3 status=`/etc/init.d/mysql status | grep running | wc -l`
  4 process=`ps -ef | grep mysql | grep -v grep | wc -l`
  5 
  6 port=`lsof -i:3306 | grep -i listen | wc -l`
  7 
  8 mysql -uroot -p'123456' -e "show databases;" > /dev/null 2>/dev/null
  9 
 10 a=$?
 11 
 12 #[ $a -eq 0 ] && [ $port -ne 0 ] && [ $process -ne 0 ] && [ $status -ne 0 ] echo "mysql is running " || 
 13 [ $a -eq 0 ] && [ $port -ne 0 ] && [ $process -ne 0 ] && [ $status -ne 0 ] \
 14 
 15 echo "mysql is running" || echo "mysql is not running"