首页 > 代码库 > MySQL慢查询日志分割
MySQL慢查询日志分割
mysql> set global slow_query_log=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global slow_query_log_file=‘/data/mysql_33096/mysqllog/slow_query_2014-06-09.log‘;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like ‘slow%‘;
+---------------------+------------------------------------------------------+
| Variable_name | Value |
+---------------------+------------------------------------------------------+
| slow_launch_time | 2 |
| slow_query_log | OFF |
| slow_query_log_file | /data/mysql_33096/mysqllog/slow_query_2014-06-09.log |
+---------------------+------------------------------------------------------+
mysql> set global slow_query_log=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show variables like ‘slow%‘;
+---------------------+-------------------------------------------+
| Variable_name | Value |
+---------------------+-------------------------------------------+
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_file | /data/mysql_33096/mysqllog/slow_query.log |
+---------------------+-------------------------------------------+
3 rows in set (0.00 sec)
/root/slowlog.sh脚本
#!/bin/bash
####split mysql slow-query-log#######
LOGDIR=/data/mysqllog
DATE=`date +"%Y-%m-%d"`
user=xxx
passwd=****
#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=‘${LOGDIR}/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 $LOGDIR
find ./slow_query* -ctime +7 -exec rm -f {} \;
定时任务：
[wy@dev88 home]$ sudo crontab -e
00 0 * * * /root/slowlog.sh
MySQL慢查询日志分割
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。