Mysqltest：slow_cut_log

#/bin/bash
datetime1=`date -d "1 days ago" +"%Y%m"`
datetime2=`date -d "6 months ago" +"%Y%m"`

slowlog='ehrdb01-slow.log'
logfile="/var/lib/mysql/${slowlog}"
workdir='/data/mysql_slow_logs'
archive="${workdir}/${datetime1}"
#自定义
logtime=`date -d "1 days ago" +"%Y%m%d"`
rootid='test'
env='test'
logname="${rootid}_${logtime}_${env}_${slowlog}"

mkdir -p ${archive}
cd ${archive}
cp ${logfile} ${logname}
sleep 1
zip -r ${logname}.zip ${logname}
sleep 1
rm -f ${logname}

echo > ${logfile}

rm -rf ${workdir}/${datetime2}
find ${workdir} -type f -name '*log*' -mtime +180 -exec rm -f {} \;
chmod 644 ${logfile}