#!/bin/bash
####split mysql slow-query-log#######
LOG=/u01/mysql/5310/log/slow
DATE=`date +"%Y-%m-%d"`
user=root
passwd=root01
#stop slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log=0"
#reset the filename of slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log_file='${LOG}/slow_query_${DATE}.log'"
#enable slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log=1"
#remove slow_query_log 7days ago.
cd $LOG
find ./slow_query* -ctime +7 -exec rm -f {} \;
####split mysql slow-query-log#######
LOG=/u01/mysql/5310/log/slow
DATE=`date +"%Y-%m-%d"`
user=root
passwd=root01
#stop slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log=0"
#reset the filename of slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log_file='${LOG}/slow_query_${DATE}.log'"
#enable slow_query_log
mysql -u$user -p$passwd -e "set global slow_query_log=1"
#remove slow_query_log 7days ago.
cd $LOG
find ./slow_query* -ctime +7 -exec rm -f {} \;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30176559/viewspace-2077210/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30176559/viewspace-2077210/