mysql延时检查脚本

#!/bin/bash

# Name: collectBehind.sh

# Version: 1.0

# Date: 2021-05-19

user='***' 

password='****' 

port=9001
sock='/tmp/mysqld.9001_mdowntest.sock'

#mysql=`/usr/local/mysql/bin/mysql  -u$user -p$password  -S $sock` 

date=`date '+%Y%m%d %H:%M:%S'`

for i in `seq 60` 
do

date_time=`date +%Y%m%d%H%M%S`

behind_t=`/usr/local/mysql/bin/mysql  -u$user -p$password  -S $sock  -e "show slave status\G;"|grep -i "Seconds_Behind_Master"|awk -F":" '{print $2}'`
mkdir -p /data1/dbatemp/

#echo -e "$date_time Seconds_Behind_Master:$behind_t" >> /data1/dbatemp/${port}_${date}_behind.log  

if [ $behind_t -gt 3 ];then    

echo -e "\n$date_time Seconds_Behind_Master:$behind_t\n" >> /data1/dbatemp/${port}_${date}_processlist.log   

/usr/local/mysql/bin/mysql  -u$user -p$password  -S $sock  -e  "show full processlist;"  >> /data1/dbatemp/${port}_${date}_processlist.log

fi

sleep 1 

done