mysql日志 logrotate_使用logrotate来进行轮换mysql的慢日志

#!/bin/bash

SLOWCFG=/etc/my.cnf

DATADIR=`awk /^datadir/ $SLOWCFG|awk -F"=" '{print $2}'`

SLOWDIR=`cat $SLOWCFG|grep "^slow_query_log_file"|awk -F"=" '{ print $2 }'`

SLOWNAME=`echo $SLOWDIR|awk -F"/" '{print $5}'`

SLOWUSER=root

SLOWPASS=shiyiwen

SLOWSCRIPT=/data/mysql-slow-ratate

NEWSLOWDIR=`find $DATADIR -name "$SLOWNAME*"|xargs ls -lt|awk 'NR==1 { print $9 }'`

OLDDIR=/var/log/old_log

if [[ -z $SLOWDIR || -z $NEWSLOWDIR || -z $SLOWNAME || -z $DATADIR ]];then

echo "Please check configure...."

exit 1

fi

if [ ! -d $OLDDIR ];then

mkdir -p $OLDDIR

fi

cat >$SLOWSCRIPT<

$NEWSLOWDIR {

create 600 mysql mysql

notifempty

dateext

daily

rotate 7

missingok

copytruncate

olddir $OLDDIR

#compress

postrotate

# just if mysqld is really running

if test -x /usr/bin/mysqladmin &&

/usr/bin/mysqladmin ping &>/dev/null

then

/usr/bin/mysqladmin -u$SLOWUSER -p$SLOWPASS flush-logs

fi

endscript

}

EOF

if [ $UID -ne 0 ];then

echo "Please use root running.."

exit 1

fi

echo "59 23 * * * /usr/sbin/logrotate -f $SLOWSCRIPT">>/var/spool/cron/root

/etc/init.d/crond restart

echo -e "\033[34m OK! Sucess\033[0m"