监控mysql启动情况并检测表错误修复代码,Shell代码库,德仔网

代码语言

代码分类

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

作者:蓝宝石的傻话 / 发布于2013/9/13/ 1026


	#!/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
	 exit 1
	 fi
	 sleep 10
	done
	if [ $num -gt 0 ] ; then
	 mysqlsamchk
	fi
	}
	mysqlsamchk(){
	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"|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
	# day="$(date +%Y%m%d|cut -b 3-8) $(date +%H)"
	# grep "is marked as crashed and should be repaired" /var/log/mysql.err
	}

	mysqllive

试试其它关键字

　监控mysql　

同语言下

可能有用的

蓝宝石的傻话贡献的其它代码(2)