简单的MYSQL检测

2015/05/20 35026

清华大佬耗费三个月吐血整理的几百G的资源，免费分享！....>>>

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
# !bin/bash
MYSQLPID='/var/run/mysqld/mysqld.pid';
 
if [ ! -f $MYSQLPID ] ; then
    service mysqld start &>> mysql.error.log;
 
    if [ $? -ne 0 ] ; then
        for i in $(ps -ef|grep mysqld | grep -v grep | awk '{print $2}')
        do
            kill -9 $i;
        done
 
        service mysqld start &>> mysql.error.log;
    fi  
    exit;
fi
              
PID=$(tail $MYSQLPID);
 
if [[ X$PID -eq X ]] ; then
    rm -rf $MYSQLPID;
     
    if [ $? -eq 0 ] ; then
        for i in $(ps -ef|grep mysqld | grep -v grep| awk '{print $2}')
        do
            kill -9 $i;
        done
     
        service mysqld stop  &>> mysql.error.log;
        service mysqld start &>> mysql.error.log;
    else
        echo "MYSQL PID 文件删除失败. " 1>> mysql.error.log
    fi
fi