监控mysql启动情况并检测表错误修复

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

#!/bin/env bash
###############################################################################
# NOTE:
# The test system is Ubuntu12.04
# This Scripts all rights reserved deserved by MickeyZZC
# Copyright  2013
#
###############################################################################
PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin:~/bin
export PATH
clear

username=
passwd=
mysqlhost=""

mysqllive(){
	num=0
	while [[ `pidof mysqld` == "" ]] ; do
		echo "$(date +%Y%m%d%H%m),MYSQL IS DOWN" >> /var/log/mysqlstat.log
		service mysql start
		num=`expr $num + 1`
			if [[ $num -gt 11 ]] ; then
				echo "$(date +%Y%m%d%H%m),MYSQL NO UP" >> /var/log/mysqlstat.log
				exit 1
			fi
		sleep 10
	done
	if [[ $num -gt 0 ]] ; then
		mysqlsamchk
	fi
}
mysqlsamchk(){
	if [[ `which mysqlcheck` == "" ]] ;then
		mysqldata=`mysql -h$mysqlhost -u$username -p$passwd -e"show databases"|grep -vE "mysql|information_schema|performance_schema|Database"`
		for i in ${mysqldata[@]} ; do
			mytables=`mysql -h$mysqlhost -u$username -p$passwd -e"use $i;show tables;"|grep -vE "Tables_in_"`
			for j in ${mytables[@]} ; do
				table_status=`mysql -h$mysqlhost -u$username -p$passwd -e"check table $i.$j"|awk 'BEGIN{IFS='t'}{print $3}'|grep "error"`
				if [ ! "$table_status" == "" ] ; then
					mysql -h$mysqlhost -u$username -p$passwd -e"repair table $i.$j"
					echo "$(date +%Y%m%d%H%M),$i.$j be repair" >> /var/log/mysqlstat.log
				fi
			done
		done
	else
		mysqlcheck --all-databases --auto-repair -u$username -p$passwd |awk '!/OK/ {printf "datetime,%sn",$1}'|sed "s/datetime/$(date +%Y%m%d%H%M)/g" >> /var/log/mysqlstat.log
#	day="$(date +%Y%m%d|cut -b 3-8) $(date +%H)"
#	grep "is marked as crashed and should be repaired" /var/log/mysql.err
	fi
}

if [[ $1 = 'check' ]] ; then
	mysqlsamchk
else
	mysqllive
fi

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!