Shulou(Shulou.com)06/01 Report--

#! / 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 {}\

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.