MySQL Slow query log script

#!/bin/bash

log=/diskb/mysql/slowlog/#定义日志存储路径

Date= ' date + '%y-%m-%d ' #定义时间参数

User=root #填写MySQL账户信息

passwd=123456

MYSQL-U$USER-P$PASSWD-E "Set global slow_query_log=0" #停止mysql慢查询日志

MYSQL-U$USER-P$PASSWD-E "Set global slow_query_log_file= ' ${log}/slow_query_${date}.log '" #按天配置路径

MYSQL-U$USER-P$PASSWD-E "Set global slow_query_log=1" #开启日志

CD $LOG

Find./slow_query*-ctime +7-exec rm-f {} \; #移除七天前日志

This article is from the "Three Fat Technical Blog" blog, please be sure to keep this source http://jinsanpang.blog.51cto.com/2222920/1901203

MySQL Slow query log script