超好用的MySQL巡检工具

#!/bin/bash
#这个脚本的功能是对MySQL进行巡检
#Written by LiHui
#Version 1.1
#Data:2017-01-19

echo -e “\033[33m========================= 硬件检查 =========================\033[0m”

echo -e “\033[31m=显示开机信息= \033[0m”
dmesg | tail -20

echo -e “\033[31m=查看RAID阵列信息= \033[0m”
/opt/MegaRAID/MegaCli/MegaCli64 -LDInfo -Lall -aALL

echo -e “\033[31m=检查物理磁盘SMART信息= \033[0m”
/opt/MegaRAID/MegaCli/MegaCli64 -PDList -aALL|egrep ‘Slot|S.M.A.R.T’

echo -e “\033[31m=检查RAID电池状态= \033[0m”
/opt/MegaRAID/MegaCli/MegaCli64 -AdpBbuCmd -a0|grep -E ‘Charger|isSOHGood|Cycle Count|Max Error’

echo -e “\033[33m========================= 操作系统检查 =========================\033[0m”

echo -e “\033[31m=启动项检查= \033[0m”
chkconfig --list |grep -E “lvs|iptables|zabbix_agentd”

echo -e “\033[31m=MySQL启动项检查= \033[0m”
cat /etc/rc.d/rc.local |grep mysql

echo -e “\033[31m=IO性能检查= \033[0m”
vmstat 1 5