#!/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
