每日shell脚本之mysql健康查询

每日shell脚本之mysql健康查询

#!/usr/bin/bash                #CSDN :M乔木 #Email:2776617348@qq.com #解释器:这是一个shell脚本    cat/dev/null | awk '/Com_insert/{print }'`sm=`mysql -p0  -e "SHOW STATUS LIKE 'Com_delete';" 2>/dev/null | awk '/Com_delete/{print }'`gm=`mysql -p0  -e "SHOW STATUS LIKE 'Com_update';" 2>/dev/null | awk '/Com_update/{print }'` zm=`mysql -p0  -e "SHOW STATUS LIKE 'Com_select';" 2>/dev/null | awk '/Com_select/{print }'`echo "mysql增删改查分别为:"echo "插入[${cm}]删除[${sm}]更新[${gm}]查询[${zm}]";;3)mu=`mysql -p0  -e "SHOW GLOBAL STATUS LIKE 'Uptime';" 2>/dev/null | awk '/Uptime/{print }'` echo "mysql已运行[${mu}秒]";;4)zz=`ssh 192.168.219.128 "mysql -p0 -e 'show slave status\G'" 2>/dev/null | awk '/Slave_IO_Running/{print }' | cut -d':' -f2 `if [ $zz = "yes" ];thenecho "mysql状态:0"elseecho "mysql状态:1"fi;;5)ym=`mysql -p0  -e "SHOW FULL PROCESSLIST;" 2>/dev/null | awk '/root/{print }'`echo "mysql当前有${ym}个sql运行";;6)cat /var/lib/mysql/atguigu-slow.log ;;q)exit 0esac

（）（）