#!/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,%s\n",$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