shell指令碼，如何監控mysql資料庫。

標籤：

[[email protected] wyb]# cat jkmysql #!/bin/bashstatus=`/etc/init.d/mysqld status|grep running|wc -l`process=`ps -ef |grep mysqld|grep -v grep|wc -l`port=`lsof -i:3306|grep -i listen|wc -l`mysql -uroot -p‘test‘ -e "show databases;" >/dev/null 2>/dev/nulla=$?[ $a -eq 0 ] && [ $port -ne 0 ] && [ $process -ne 0 ] && [ $status -ne 0 ] echo "mysql is running" || echo "mysql is not running"[[email protected] wyb]# bash jkmysql mysql is running[[email protected] wyb]# 

 

shell指令碼，如何監控mysql資料庫。