mysql监控脚本

ps -ef|grep mysqld|grep mysql|grep basedir|awk -F mysqld '{print $2}'|awk '{print $1  "=" $7}'|awk -F = '{print $2"/bin/mysql  "$4  }' > tmp001  2>&1


while read Line
do


echo "[client]
port=$(echo $Line|awk '{print $2}')
host=`hostname`
user=mysqluser
password=mysqluser " > /tmp/my.password
    
    #echo $(echo  "$(echo $Line|awk '{print $1}')" --defaults-extra-file=/tmp/my.password  -e  \"SHOW SLAVE STATUS \\G\"  )
    vvv=$(echo   "$(echo $Line|awk '{print $1}')" --defaults-extra-file=/tmp/my.password -e  \"SHOW SLAVE STATUS \\G\"  ) 
    Slave_IO_Running=$(echo $vvv|sh|grep Slave_IO_Running|awk '{print $2}') > /tmp/01  2>&1
    echo $(echo $Line|awk '{print $2}')  ""`hostname`" "   ${Slave_IO_Running:-NO}


done < tmp001