Posts
轮换MySQL日志文件
用Logrotate维护MySQL日志
通常打开MySQL的普通查询日志(general query log)和慢速查询日志(slow query log), 以便查找(可能)出现的问题
在繁忙的系统中, 日志文件增长很快, 对大文件查询起来不方便, 写日志文件本身也会影响磁盘性能
MySQL 5.0中普通/慢速查询日志参数是个静态的参数,只能通过重启MySQL服务生效
MySQL 5.1版本后普通/慢速查询日志参数是动态的, 能够动态的启用或关闭. 可以平时关闭普通查询日志, 当需要时再打开
当日志文件增长过大时需要截断(truncate), 使用命令"> logfile"
此命令清空文件全部内容,而不删除文件
# ls -l install.log.bak -rw-r--r-- 1 root root 17244 Jun 1 09:29 install.log.bak # >install.log.bak # ls -l install.log.bak -rw-r--r-- 1 root root 0 Aug 11 06:45 install.log.bak #
截断日志文件后以前的内容就没有了, 所以这并非是一个理想的方案, 需要的是对日志进行归档, 保留旧的日志, 产生新的日志文件
方法见MySQL参考手册:
shell> mv host_name.log host_name-old.log shell> mysqladmin flush-logs shell> cp host_name-old.log backup-directory shell> rm host_name-old.log
- 日志文件改名, 这不会使MySQL服务终止, 所以不影响在线业务
- 运行flush-logs命令, 刷新日志文件(包括关闭/重新打开查询日志文件)
- 备份旧的日志文件
- 删除旧的日志文件
使用linux系统中logrotate自动工作, 配置文件如下:
cat >/etc/logrotate.d/mysql <<'EOF'
/mysql/logs/error.log /mysql/logs/general.log /mysql/logs/slow-queries.log {
daily
create 0660 mysql mysql
notifempty
#size 100M
missingok
nocompress
rotate 120
sharedscripts
postrotate
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &>/dev/null
then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
EOF
daily: 每天归档一次create 0660 mysql mysql: 归档后创建新文件
notifempty: 文件为空时不做处理
#size 100M: 文件大小超过100M也归档
missingok: 文件不存在时不报错
nocompress: 不压缩归档文件
rotate 120: 保留120个归档文件
sharedscripts: 共享的脚本,意味着对所有文件只运行一次
postrotate: 轮换后要运行的脚本
试运行一下
/usr/sbin/logrotate -vf /etc/logrotate.d/mysql查看结果
[root@db01 /mysql/logs]# ll total 1675432 -rw-rw---- 1 mysql mysql 472 Aug 11 2009 error.log -rw-rw---- 1 mysql mysql 472 Aug 11 15:03 error.log.1 -rw-rw---- 1 mysql mysql 472 Aug 11 14:57 error.log.2 -rw-rw---- 1 mysql mysql 0 Aug 11 15:03 error.log-old -rw-rw---- 1 mysql mysql 687 Aug 11 2009 general.log -rw-rw---- 1 mysql mysql 1082 Aug 11 15:03 general.log.1 -rw-rw---- 1 mysql mysql 37115 Aug 11 15:01 general.log.2 -rw-rw---- 1 mysql mysql 1693930999 Aug 11 11:06 general.log.3 -rw-rw---- 1 mysql mysql 354 Aug 11 2009 slow-queries.log -rw-rw---- 1 mysql mysql 354 Aug 11 15:03 slow-queries.log.1 -rw-rw---- 1 mysql mysql 18263218 Aug 11 14:57 slow-queries.log.2 [root@db01 /mysql/logs]# /usr/sbin/logrotate -v /etc/logrotate.d/mysql reading config file /etc/logrotate.d/mysql reading config info for /mysql/logs/error.log /mysql/logs/general.log /mysql/logs/slow-queries.log Handling 1 logs rotating pattern: /mysql/logs/error.log /mysql/logs/general.log /mysql/logs/slow-queries.log after 1 days (120 rotations) empty log files are not rotated, old logs are removed considering log /mysql/logs/error.log log does not need rotating considering log /mysql/logs/general.log log does not need rotating considering log /mysql/logs/slow-queries.log log does not need rotating not running postrotate script, since no logs were rotated [root@db01.cloud2.bqa3.blurdev.com /mysql/logs]# /usr/sbin/logrotate -vf /etc/logrotate.d/mysql reading config file /etc/logrotate.d/mysql reading config info for /mysql/logs/error.log /mysql/logs/general.log /mysql/logs/slow-queries.log Handling 1 logs rotating pattern: /mysql/logs/error.log /mysql/logs/general.log /mysql/logs/slow-queries.log forced from command line (120 rotations) empty log files are not rotated, old logs are removed considering log /mysql/logs/error.log log needs rotating considering log /mysql/logs/general.log log needs rotating considering log /mysql/logs/slow-queries.log log needs rotating rotating log /mysql/logs/error.log, log->rotateCount is 120 renaming /mysql/logs/error.log.120 to /mysql/logs/error.log.121 (rotatecount 120, logstart 1, i 120), old log /mysql/logs/error.log.120 does not exist renaming /mysql/logs/error.log.119 to /mysql/logs/error.log.120 (rotatecount 120, logstart 1, i 119), old log /mysql/logs/error.log.119 does not exist renaming /mysql/logs/error.log.118 to /mysql/logs/error.log.119 (rotatecount 120, logstart 1, i 118), old log /mysql/logs/error.log.118 does not exist renaming /mysql/logs/error.log.117 to /mysql/logs/error.log.118 (rotatecount 120, logstart 1, i 117), old log /mysql/logs/error.log.117 does not exist renaming /mysql/logs/error.log.116 to /mysql/logs/error.log.117 (rotatecount 120, logstart 1, i 116), old log /mysql/logs/error.log.116 does not exist renaming /mysql/logs/error.log.115 to /mysql/logs/error.log.116 (rotatecount 120, logstart 1, i 115), old log /mysql/logs/error.log.115 does not exist renaming /mysql/logs/error.log.114 to /mysql/logs/error.log.115 (rotatecount 120, logstart 1, i 114), old log /mysql/logs/error.log.114 does not exist renaming /mysql/logs/error.log.113 to /mysql/logs/error.log.114 (rotatecount 120, logstart 1, i 113), old log /mysql/logs/error.log.113 does not exist renaming /mysql/logs/error.log.112 to /mysql/logs/error.log.113 (rotatecount 120, logstart 1, i 112), old log /mysql/logs/error.log.112 does not exist renaming /mysql/logs/error.log.111 to /mysql/logs/error.log.112 (rotatecount 120, logstart 1, i 111), old log /mysql/logs/error.log.111 does not exist renaming /mysql/logs/error.log.110 to /mysql/logs/error.log.111 (rotatecount 120, logstart 1, i 110), old log /mysql/logs/error.log.110 does not exist renaming /mysql/logs/error.log.109 to /mysql/logs/error.log.110 (rotatecount 120, logstart 1, i 109), old log /mysql/logs/error.log.109 does not exist renaming /mysql/logs/error.log.108 to /mysql/logs/error.log.109 (rotatecount 120, logstart 1, i 108), old log /mysql/logs/error.log.108 does not exist renaming /mysql/logs/error.log.107 to /mysql/logs/error.log.108 (rotatecount 120, logstart 1, i 107), old log /mysql/logs/error.log.107 does not exist renaming /mysql/logs/error.log.106 to /mysql/logs/error.log.107 (rotatecount 120, logstart 1, i 106), old log /mysql/logs/error.log.106 does not exist renaming /mysql/logs/error.log.105 to /mysql/logs/error.log.106 (rotatecount 120, logstart 1, i 105), old log /mysql/logs/error.log.105 does not exist renaming /mysql/logs/error.log.104 to /mysql/logs/error.log.105 (rotatecount 120, logstart 1, i 104), old log /mysql/logs/error.log.104 does not exist renaming /mysql/logs/error.log.103 to /mysql/logs/error.log.104 (rotatecount 120, logstart 1, i 103), old log /mysql/logs/error.log.103 does not exist renaming /mysql/logs/error.log.102 to /mysql/logs/error.log.103 (rotatecount 120, logstart 1, i 102), old log /mysql/logs/error.log.102 does not exist renaming /mysql/logs/error.log.101 to /mysql/logs/error.log.102 (rotatecount 120, logstart 1, i 101), old log /mysql/logs/error.log.101 does not exist renaming /mysql/logs/error.log.100 to /mysql/logs/error.log.101 (rotatecount 120, logstart 1, i 100), old log /mysql/logs/error.log.100 does not exist renaming /mysql/logs/error.log.99 to /mysql/logs/error.log.100 (rotatecount 120, logstart 1, i 99), old log /mysql/logs/error.log.99 does not exist renaming /mysql/logs/error.log.98 to /mysql/logs/error.log.99 (rotatecount 120, logstart 1, i 98), old log /mysql/logs/error.log.98 does not exist renaming /mysql/logs/error.log.97 to /mysql/logs/error.log.98 (rotatecount 120, logstart 1, i 97), old log /mysql/logs/error.log.97 does not exist renaming /mysql/logs/error.log.96 to /mysql/logs/error.log.97 (rotatecount 120, logstart 1, i 96), old log /mysql/logs/error.log.96 does not exist renaming /mysql/logs/error.log.95 to /mysql/logs/error.log.96 (rotatecount 120, logstart 1, i 95), old log /mysql/logs/error.log.95 does not exist renaming /mysql/logs/error.log.94 to /mysql/logs/error.log.95 (rotatecount 120, logstart 1, i 94), old log /mysql/logs/error.log.94 does not exist renaming /mysql/logs/error.log.93 to /mysql/logs/error.log.94 (rotatecount 120, logstart 1, i 93), old log /mysql/logs/error.log.93 does not exist renaming /mysql/logs/error.log.92 to /mysql/logs/error.log.93 (rotatecount 120, logstart 1, i 92), old log /mysql/logs/error.log.92 does not exist renaming /mysql/logs/error.log.91 to /mysql/logs/error.log.92 (rotatecount 120, logstart 1, i 91), old log /mysql/logs/error.log.91 does not exist renaming /mysql/logs/error.log.90 to /mysql/logs/error.log.91 (rotatecount 120, logstart 1, i 90), old log /mysql/logs/error.log.90 does not exist renaming /mysql/logs/error.log.89 to /mysql/logs/error.log.90 (rotatecount 120, logstart 1, i 89), old log /mysql/logs/error.log.89 does not exist renaming /mysql/logs/error.log.88 to /mysql/logs/error.log.89 (rotatecount 120, logstart 1, i 88), old log /mysql/logs/error.log.88 does not exist renaming /mysql/logs/error.log.87 to /mysql/logs/error.log.88 (rotatecount 120, logstart 1, i 87), old log /mysql/logs/error.log.87 does not exist renaming /mysql/logs/error.log.86 to /mysql/logs/error.log.87 (rotatecount 120, logstart 1, i 86), old log /mysql/logs/error.log.86 does not exist renaming /mysql/logs/error.log.85 to /mysql/logs/error.log.86 (rotatecount 120, logstart 1, i 85), old log /mysql/logs/error.log.85 does not exist renaming /mysql/logs/error.log.84 to /mysql/logs/error.log.85 (rotatecount 120, logstart 1, i 84), old log /mysql/logs/error.log.84 does not exist renaming /mysql/logs/error.log.83 to /mysql/logs/error.log.84 (rotatecount 120, logstart 1, i 83), old log /mysql/logs/error.log.83 does not exist renaming /mysql/logs/error.log.82 to /mysql/logs/error.log.83 (rotatecount 120, logstart 1, i 82), old log /mysql/logs/error.log.82 does not exist renaming /mysql/logs/error.log.81 to /mysql/logs/error.log.82 (rotatecount 120, logstart 1, i 81), old log /mysql/logs/error.log.81 does not exist renaming /mysql/logs/error.log.80 to /mysql/logs/error.log.81 (rotatecount 120, logstart 1, i 80), old log /mysql/logs/error.log.80 does not exist renaming /mysql/logs/error.log.79 to /mysql/logs/error.log.80 (rotatecount 120, logstart 1, i 79), old log /mysql/logs/error.log.79 does not exist renaming /mysql/logs/error.log.78 to /mysql/logs/error.log.79 (rotatecount 120, logstart 1, i 78), old log /mysql/logs/error.log.78 does not exist renaming /mysql/logs/error.log.77 to /mysql/logs/error.log.78 (rotatecount 120, logstart 1, i 77), old log /mysql/logs/error.log.77 does not exist renaming /mysql/logs/error.log.76 to /mysql/logs/error.log.77 (rotatecount 120, logstart 1, i 76), old log /mysql/logs/error.log.76 does not exist renaming /mysql/logs/error.log.75 to /mysql/logs/error.log.76 (rotatecount 120, logstart 1, i 75), old log /mysql/logs/error.log.75 does not exist renaming /mysql/logs/error.log.74 to /mysql/logs/error.log.75 (rotatecount 120, logstart 1, i 74), old log /mysql/logs/error.log.74 does not exist renaming /mysql/logs/error.log.73 to /mysql/logs/error.log.74 (rotatecount 120, logstart 1, i 73), old log /mysql/logs/error.log.73 does not exist renaming /mysql/logs/error.log.72 to /mysql/logs/error.log.73 (rotatecount 120, logstart 1, i 72), old log /mysql/logs/error.log.72 does not exist renaming /mysql/logs/error.log.71 to /mysql/logs/error.log.72 (rotatecount 120, logstart 1, i 71), old log /mysql/logs/error.log.71 does not exist renaming /mysql/logs/error.log.70 to /mysql/logs/error.log.71 (rotatecount 120, logstart 1, i 70), old log /mysql/logs/error.log.70 does not exist renaming /mysql/logs/error.log.69 to /mysql/logs/error.log.70 (rotatecount 120, logstart 1, i 69), old log /mysql/logs/error.log.69 does not exist renaming /mysql/logs/error.log.68 to /mysql/logs/error.log.69 (rotatecount 120, logstart 1, i 68), old log /mysql/logs/error.log.68 does not exist renaming /mysql/logs/error.log.67 to /mysql/logs/error.log.68 (rotatecount 120, logstart 1, i 67), old log /mysql/logs/error.log.67 does not exist renaming /mysql/logs/error.log.66 to /mysql/logs/error.log.67 (rotatecount 120, logstart 1, i 66), old log /mysql/logs/error.log.66 does not exist renaming /mysql/logs/error.log.65 to /mysql/logs/error.log.66 (rotatecount 120, logstart 1, i 65), old log /mysql/logs/error.log.65 does not exist renaming /mysql/logs/error.log.64 to /mysql/logs/error.log.65 (rotatecount 120, logstart 1, i 64), old log /mysql/logs/error.log.64 does not exist renaming /mysql/logs/error.log.63 to /mysql/logs/error.log.64 (rotatecount 120, logstart 1, i 63), old log /mysql/logs/error.log.63 does not exist renaming /mysql/logs/error.log.62 to /mysql/logs/error.log.63 (rotatecount 120, logstart 1, i 62), old log /mysql/logs/error.log.62 does not exist renaming /mysql/logs/error.log.61 to /mysql/logs/error.log.62 (rotatecount 120, logstart 1, i 61), old log /mysql/logs/error.log.61 does not exist renaming /mysql/logs/error.log.60 to /mysql/logs/error.log.61 (rotatecount 120, logstart 1, i 60), old log /mysql/logs/error.log.60 does not exist renaming /mysql/logs/error.log.59 to /mysql/logs/error.log.60 (rotatecount 120, logstart 1, i 59), old log /mysql/logs/error.log.59 does not exist renaming /mysql/logs/error.log.58 to /mysql/logs/error.log.59 (rotatecount 120, logstart 1, i 58), old log /mysql/logs/error.log.58 does not exist renaming /mysql/logs/error.log.57 to /mysql/logs/error.log.58 (rotatecount 120, logstart 1, i 57), old log /mysql/logs/error.log.57 does not exist renaming /mysql/logs/error.log.56 to /mysql/logs/error.log.57 (rotatecount 120, logstart 1, i 56), old log /mysql/logs/error.log.56 does not exist renaming /mysql/logs/error.log.55 to /mysql/logs/error.log.56 (rotatecount 120, logstart 1, i 55), old log /mysql/logs/error.log.55 does not exist renaming /mysql/logs/error.log.54 to /mysql/logs/error.log.55 (rotatecount 120, logstart 1, i 54), old log /mysql/logs/error.log.54 does not exist renaming /mysql/logs/error.log.53 to /mysql/logs/error.log.54 (rotatecount 120, logstart 1, i 53), old log /mysql/logs/error.log.53 does not exist renaming /mysql/logs/error.log.52 to /mysql/logs/error.log.53 (rotatecount 120, logstart 1, i 52), old log /mysql/logs/error.log.52 does not exist renaming /mysql/logs/error.log.51 to /mysql/logs/error.log.52 (rotatecount 120, logstart 1, i 51), old log /mysql/logs/error.log.51 does not exist renaming /mysql/logs/error.log.50 to /mysql/logs/error.log.51 (rotatecount 120, logstart 1, i 50), old log /mysql/logs/error.log.50 does not exist renaming /mysql/logs/error.log.49 to /mysql/logs/error.log.50 (rotatecount 120, logstart 1, i 49), old log /mysql/logs/error.log.49 does not exist renaming /mysql/logs/error.log.48 to /mysql/logs/error.log.49 (rotatecount 120, logstart 1, i 48), old log /mysql/logs/error.log.48 does not exist renaming /mysql/logs/error.log.47 to /mysql/logs/error.log.48 (rotatecount 120, logstart 1, i 47), old log /mysql/logs/error.log.47 does not exist renaming /mysql/logs/error.log.46 to /mysql/logs/error.log.47 (rotatecount 120, logstart 1, i 46), old log /mysql/logs/error.log.46 does not exist renaming /mysql/logs/error.log.45 to /mysql/logs/error.log.46 (rotatecount 120, logstart 1, i 45), old log /mysql/logs/error.log.45 does not exist renaming /mysql/logs/error.log.44 to /mysql/logs/error.log.45 (rotatecount 120, logstart 1, i 44), old log /mysql/logs/error.log.44 does not exist renaming /mysql/logs/error.log.43 to /mysql/logs/error.log.44 (rotatecount 120, logstart 1, i 43), old log /mysql/logs/error.log.43 does not exist renaming /mysql/logs/error.log.42 to /mysql/logs/error.log.43 (rotatecount 120, logstart 1, i 42), old log /mysql/logs/error.log.42 does not exist renaming /mysql/logs/error.log.41 to /mysql/logs/error.log.42 (rotatecount 120, logstart 1, i 41), old log /mysql/logs/error.log.41 does not exist renaming /mysql/logs/error.log.40 to /mysql/logs/error.log.41 (rotatecount 120, logstart 1, i 40), old log /mysql/logs/error.log.40 does not exist renaming /mysql/logs/error.log.39 to /mysql/logs/error.log.40 (rotatecount 120, logstart 1, i 39), old log /mysql/logs/error.log.39 does not exist renaming /mysql/logs/error.log.38 to /mysql/logs/error.log.39 (rotatecount 120, logstart 1, i 38), old log /mysql/logs/error.log.38 does not exist renaming /mysql/logs/error.log.37 to /mysql/logs/error.log.38 (rotatecount 120, logstart 1, i 37), old log /mysql/logs/error.log.37 does not exist renaming /mysql/logs/error.log.36 to /mysql/logs/error.log.37 (rotatecount 120, logstart 1, i 36), old log /mysql/logs/error.log.36 does not exist renaming /mysql/logs/error.log.35 to /mysql/logs/error.log.36 (rotatecount 120, logstart 1, i 35), old log /mysql/logs/error.log.35 does not exist renaming /mysql/logs/error.log.34 to /mysql/logs/error.log.35 (rotatecount 120, logstart 1, i 34), old log /mysql/logs/error.log.34 does not exist renaming /mysql/logs/error.log.33 to /mysql/logs/error.log.34 (rotatecount 120, logstart 1, i 33), old log /mysql/logs/error.log.33 does not exist renaming /mysql/logs/error.log.32 to /mysql/logs/error.log.33 (rotatecount 120, logstart 1, i 32), old log /mysql/logs/error.log.32 does not exist renaming /mysql/logs/error.log.31 to /mysql/logs/error.log.32 (rotatecount 120, logstart 1, i 31), old log /mysql/logs/error.log.31 does not exist renaming /mysql/logs/error.log.30 to /mysql/logs/error.log.31 (rotatecount 120, logstart 1, i 30), old log /mysql/logs/error.log.30 does not exist renaming /mysql/logs/error.log.29 to /mysql/logs/error.log.30 (rotatecount 120, logstart 1, i 29), old log /mysql/logs/error.log.29 does not exist renaming /mysql/logs/error.log.28 to /mysql/logs/error.log.29 (rotatecount 120, logstart 1, i 28), old log /mysql/logs/error.log.28 does not exist renaming /mysql/logs/error.log.27 to /mysql/logs/error.log.28 (rotatecount 120, logstart 1, i 27), old log /mysql/logs/error.log.27 does not exist renaming /mysql/logs/error.log.26 to /mysql/logs/error.log.27 (rotatecount 120, logstart 1, i 26), old log /mysql/logs/error.log.26 does not exist renaming /mysql/logs/error.log.25 to /mysql/logs/error.log.26 (rotatecount 120, logstart 1, i 25), old log /mysql/logs/error.log.25 does not exist renaming /mysql/logs/error.log.24 to /mysql/logs/error.log.25 (rotatecount 120, logstart 1, i 24), old log /mysql/logs/error.log.24 does not exist renaming /mysql/logs/error.log.23 to /mysql/logs/error.log.24 (rotatecount 120, logstart 1, i 23), old log /mysql/logs/error.log.23 does not exist renaming /mysql/logs/error.log.22 to /mysql/logs/error.log.23 (rotatecount 120, logstart 1, i 22), old log /mysql/logs/error.log.22 does not exist renaming /mysql/logs/error.log.21 to /mysql/logs/error.log.22 (rotatecount 120, logstart 1, i 21), old log /mysql/logs/error.log.21 does not exist renaming /mysql/logs/error.log.20 to /mysql/logs/error.log.21 (rotatecount 120, logstart 1, i 20), old log /mysql/logs/error.log.20 does not exist renaming /mysql/logs/error.log.19 to /mysql/logs/error.log.20 (rotatecount 120, logstart 1, i 19), old log /mysql/logs/error.log.19 does not exist renaming /mysql/logs/error.log.18 to /mysql/logs/error.log.19 (rotatecount 120, logstart 1, i 18), old log /mysql/logs/error.log.18 does not exist renaming /mysql/logs/error.log.17 to /mysql/logs/error.log.18 (rotatecount 120, logstart 1, i 17), old log /mysql/logs/error.log.17 does not exist renaming /mysql/logs/error.log.16 to /mysql/logs/error.log.17 (rotatecount 120, logstart 1, i 16), old log /mysql/logs/error.log.16 does not exist renaming /mysql/logs/error.log.15 to /mysql/logs/error.log.16 (rotatecount 120, logstart 1, i 15), old log /mysql/logs/error.log.15 does not exist renaming /mysql/logs/error.log.14 to /mysql/logs/error.log.15 (rotatecount 120, logstart 1, i 14), old log /mysql/logs/error.log.14 does not exist renaming /mysql/logs/error.log.13 to /mysql/logs/error.log.14 (rotatecount 120, logstart 1, i 13), old log /mysql/logs/error.log.13 does not exist renaming /mysql/logs/error.log.12 to /mysql/logs/error.log.13 (rotatecount 120, logstart 1, i 12), old log /mysql/logs/error.log.12 does not exist renaming /mysql/logs/error.log.11 to /mysql/logs/error.log.12 (rotatecount 120, logstart 1, i 11), old log /mysql/logs/error.log.11 does not exist renaming /mysql/logs/error.log.10 to /mysql/logs/error.log.11 (rotatecount 120, logstart 1, i 10), old log /mysql/logs/error.log.10 does not exist renaming /mysql/logs/error.log.9 to /mysql/logs/error.log.10 (rotatecount 120, logstart 1, i 9), old log /mysql/logs/error.log.9 does not exist renaming /mysql/logs/error.log.8 to /mysql/logs/error.log.9 (rotatecount 120, logstart 1, i 8), old log /mysql/logs/error.log.8 does not exist renaming /mysql/logs/error.log.7 to /mysql/logs/error.log.8 (rotatecount 120, logstart 1, i 7), old log /mysql/logs/error.log.7 does not exist renaming /mysql/logs/error.log.6 to /mysql/logs/error.log.7 (rotatecount 120, logstart 1, i 6), old log /mysql/logs/error.log.6 does not exist renaming /mysql/logs/error.log.5 to /mysql/logs/error.log.6 (rotatecount 120, logstart 1, i 5), old log /mysql/logs/error.log.5 does not exist renaming /mysql/logs/error.log.4 to /mysql/logs/error.log.5 (rotatecount 120, logstart 1, i 4), old log /mysql/logs/error.log.4 does not exist renaming /mysql/logs/error.log.3 to /mysql/logs/error.log.4 (rotatecount 120, logstart 1, i 3), old log /mysql/logs/error.log.3 does not exist renaming /mysql/logs/error.log.2 to /mysql/logs/error.log.3 (rotatecount 120, logstart 1, i 2), renaming /mysql/logs/error.log.1 to /mysql/logs/error.log.2 (rotatecount 120, logstart 1, i 1), renaming /mysql/logs/error.log.0 to /mysql/logs/error.log.1 (rotatecount 120, logstart 1, i 0), old log /mysql/logs/error.log.0 does not exist log /mysql/logs/error.log.121 doesn't exist -- won't try to dispose of it rotating log /mysql/logs/general.log, log->rotateCount is 120 renaming /mysql/logs/general.log.120 to /mysql/logs/general.log.121 (rotatecount 120, logstart 1, i 120), old log /mysql/logs/general.log.120 does not exist renaming /mysql/logs/general.log.119 to /mysql/logs/general.log.120 (rotatecount 120, logstart 1, i 119), old log /mysql/logs/general.log.119 does not exist renaming /mysql/logs/general.log.118 to /mysql/logs/general.log.119 (rotatecount 120, logstart 1, i 118), old log /mysql/logs/general.log.118 does not exist renaming /mysql/logs/general.log.117 to /mysql/logs/general.log.118 (rotatecount 120, logstart 1, i 117), old log /mysql/logs/general.log.117 does not exist renaming /mysql/logs/general.log.116 to /mysql/logs/general.log.117 (rotatecount 120, logstart 1, i 116), old log /mysql/logs/general.log.116 does not exist renaming /mysql/logs/general.log.115 to /mysql/logs/general.log.116 (rotatecount 120, logstart 1, i 115), old log /mysql/logs/general.log.115 does not exist renaming /mysql/logs/general.log.114 to /mysql/logs/general.log.115 (rotatecount 120, logstart 1, i 114), old log /mysql/logs/general.log.114 does not exist renaming /mysql/logs/general.log.113 to /mysql/logs/general.log.114 (rotatecount 120, logstart 1, i 113), old log /mysql/logs/general.log.113 does not exist renaming /mysql/logs/general.log.112 to /mysql/logs/general.log.113 (rotatecount 120, logstart 1, i 112), old log /mysql/logs/general.log.112 does not exist renaming /mysql/logs/general.log.111 to /mysql/logs/general.log.112 (rotatecount 120, logstart 1, i 111), old log /mysql/logs/general.log.111 does not exist renaming /mysql/logs/general.log.110 to /mysql/logs/general.log.111 (rotatecount 120, logstart 1, i 110), old log /mysql/logs/general.log.110 does not exist renaming /mysql/logs/general.log.109 to /mysql/logs/general.log.110 (rotatecount 120, logstart 1, i 109), old log /mysql/logs/general.log.109 does not exist renaming /mysql/logs/general.log.108 to /mysql/logs/general.log.109 (rotatecount 120, logstart 1, i 108), old log /mysql/logs/general.log.108 does not exist renaming /mysql/logs/general.log.107 to /mysql/logs/general.log.108 (rotatecount 120, logstart 1, i 107), old log /mysql/logs/general.log.107 does not exist renaming /mysql/logs/general.log.106 to /mysql/logs/general.log.107 (rotatecount 120, logstart 1, i 106), old log /mysql/logs/general.log.106 does not exist renaming /mysql/logs/general.log.105 to /mysql/logs/general.log.106 (rotatecount 120, logstart 1, i 105), old log /mysql/logs/general.log.105 does not exist renaming /mysql/logs/general.log.104 to /mysql/logs/general.log.105 (rotatecount 120, logstart 1, i 104), old log /mysql/logs/general.log.104 does not exist renaming /mysql/logs/general.log.103 to /mysql/logs/general.log.104 (rotatecount 120, logstart 1, i 103), old log /mysql/logs/general.log.103 does not exist renaming /mysql/logs/general.log.102 to /mysql/logs/general.log.103 (rotatecount 120, logstart 1, i 102), old log /mysql/logs/general.log.102 does not exist renaming /mysql/logs/general.log.101 to /mysql/logs/general.log.102 (rotatecount 120, logstart 1, i 101), old log /mysql/logs/general.log.101 does not exist renaming /mysql/logs/general.log.100 to /mysql/logs/general.log.101 (rotatecount 120, logstart 1, i 100), old log /mysql/logs/general.log.100 does not exist renaming /mysql/logs/general.log.99 to /mysql/logs/general.log.100 (rotatecount 120, logstart 1, i 99), old log /mysql/logs/general.log.99 does not exist renaming /mysql/logs/general.log.98 to /mysql/logs/general.log.99 (rotatecount 120, logstart 1, i 98), old log /mysql/logs/general.log.98 does not exist renaming /mysql/logs/general.log.97 to /mysql/logs/general.log.98 (rotatecount 120, logstart 1, i 97), old log /mysql/logs/general.log.97 does not exist renaming /mysql/logs/general.log.96 to /mysql/logs/general.log.97 (rotatecount 120, logstart 1, i 96), old log /mysql/logs/general.log.96 does not exist renaming /mysql/logs/general.log.95 to /mysql/logs/general.log.96 (rotatecount 120, logstart 1, i 95), old log /mysql/logs/general.log.95 does not exist renaming /mysql/logs/general.log.94 to /mysql/logs/general.log.95 (rotatecount 120, logstart 1, i 94), old log /mysql/logs/general.log.94 does not exist renaming /mysql/logs/general.log.93 to /mysql/logs/general.log.94 (rotatecount 120, logstart 1, i 93), old log /mysql/logs/general.log.93 does not exist renaming /mysql/logs/general.log.92 to /mysql/logs/general.log.93 (rotatecount 120, logstart 1, i 92), old log /mysql/logs/general.log.92 does not exist renaming /mysql/logs/general.log.91 to /mysql/logs/general.log.92 (rotatecount 120, logstart 1, i 91), old log /mysql/logs/general.log.91 does not exist renaming /mysql/logs/general.log.90 to /mysql/logs/general.log.91 (rotatecount 120, logstart 1, i 90), old log /mysql/logs/general.log.90 does not exist renaming /mysql/logs/general.log.89 to /mysql/logs/general.log.90 (rotatecount 120, logstart 1, i 89), old log /mysql/logs/general.log.89 does not exist renaming /mysql/logs/general.log.88 to /mysql/logs/general.log.89 (rotatecount 120, logstart 1, i 88), old log /mysql/logs/general.log.88 does not exist renaming /mysql/logs/general.log.87 to /mysql/logs/general.log.88 (rotatecount 120, logstart 1, i 87), old log /mysql/logs/general.log.87 does not exist renaming /mysql/logs/general.log.86 to /mysql/logs/general.log.87 (rotatecount 120, logstart 1, i 86), old log /mysql/logs/general.log.86 does not exist renaming /mysql/logs/general.log.85 to /mysql/logs/general.log.86 (rotatecount 120, logstart 1, i 85), old log /mysql/logs/general.log.85 does not exist renaming /mysql/logs/general.log.84 to /mysql/logs/general.log.85 (rotatecount 120, logstart 1, i 84), old log /mysql/logs/general.log.84 does not exist renaming /mysql/logs/general.log.83 to /mysql/logs/general.log.84 (rotatecount 120, logstart 1, i 83), old log /mysql/logs/general.log.83 does not exist renaming /mysql/logs/general.log.82 to /mysql/logs/general.log.83 (rotatecount 120, logstart 1, i 82), old log /mysql/logs/general.log.82 does not exist renaming /mysql/logs/general.log.81 to /mysql/logs/general.log.82 (rotatecount 120, logstart 1, i 81), old log /mysql/logs/general.log.81 does not exist renaming /mysql/logs/general.log.80 to /mysql/logs/general.log.81 (rotatecount 120, logstart 1, i 80), old log /mysql/logs/general.log.80 does not exist renaming /mysql/logs/general.log.79 to /mysql/logs/general.log.80 (rotatecount 120, logstart 1, i 79), old log /mysql/logs/general.log.79 does not exist renaming /mysql/logs/general.log.78 to /mysql/logs/general.log.79 (rotatecount 120, logstart 1, i 78), old log /mysql/logs/general.log.78 does not exist renaming /mysql/logs/general.log.77 to /mysql/logs/general.log.78 (rotatecount 120, logstart 1, i 77), old log /mysql/logs/general.log.77 does not exist renaming /mysql/logs/general.log.76 to /mysql/logs/general.log.77 (rotatecount 120, logstart 1, i 76), old log /mysql/logs/general.log.76 does not exist renaming /mysql/logs/general.log.75 to /mysql/logs/general.log.76 (rotatecount 120, logstart 1, i 75), old log /mysql/logs/general.log.75 does not exist renaming /mysql/logs/general.log.74 to /mysql/logs/general.log.75 (rotatecount 120, logstart 1, i 74), old log /mysql/logs/general.log.74 does not exist renaming /mysql/logs/general.log.73 to /mysql/logs/general.log.74 (rotatecount 120, logstart 1, i 73), old log /mysql/logs/general.log.73 does not exist renaming /mysql/logs/general.log.72 to /mysql/logs/general.log.73 (rotatecount 120, logstart 1, i 72), old log /mysql/logs/general.log.72 does not exist renaming /mysql/logs/general.log.71 to /mysql/logs/general.log.72 (rotatecount 120, logstart 1, i 71), old log /mysql/logs/general.log.71 does not exist renaming /mysql/logs/general.log.70 to /mysql/logs/general.log.71 (rotatecount 120, logstart 1, i 70), old log /mysql/logs/general.log.70 does not exist renaming /mysql/logs/general.log.69 to /mysql/logs/general.log.70 (rotatecount 120, logstart 1, i 69), old log /mysql/logs/general.log.69 does not exist renaming /mysql/logs/general.log.68 to /mysql/logs/general.log.69 (rotatecount 120, logstart 1, i 68), old log /mysql/logs/general.log.68 does not exist renaming /mysql/logs/general.log.67 to /mysql/logs/general.log.68 (rotatecount 120, logstart 1, i 67), old log /mysql/logs/general.log.67 does not exist renaming /mysql/logs/general.log.66 to /mysql/logs/general.log.67 (rotatecount 120, logstart 1, i 66), old log /mysql/logs/general.log.66 does not exist renaming /mysql/logs/general.log.65 to /mysql/logs/general.log.66 (rotatecount 120, logstart 1, i 65), old log /mysql/logs/general.log.65 does not exist renaming /mysql/logs/general.log.64 to /mysql/logs/general.log.65 (rotatecount 120, logstart 1, i 64), old log /mysql/logs/general.log.64 does not exist renaming /mysql/logs/general.log.63 to /mysql/logs/general.log.64 (rotatecount 120, logstart 1, i 63), old log /mysql/logs/general.log.63 does not exist renaming /mysql/logs/general.log.62 to /mysql/logs/general.log.63 (rotatecount 120, logstart 1, i 62), old log /mysql/logs/general.log.62 does not exist renaming /mysql/logs/general.log.61 to /mysql/logs/general.log.62 (rotatecount 120, logstart 1, i 61), old log /mysql/logs/general.log.61 does not exist renaming /mysql/logs/general.log.60 to /mysql/logs/general.log.61 (rotatecount 120, logstart 1, i 60), old log /mysql/logs/general.log.60 does not exist renaming /mysql/logs/general.log.59 to /mysql/logs/general.log.60 (rotatecount 120, logstart 1, i 59), old log /mysql/logs/general.log.59 does not exist renaming /mysql/logs/general.log.58 to /mysql/logs/general.log.59 (rotatecount 120, logstart 1, i 58), old log /mysql/logs/general.log.58 does not exist renaming /mysql/logs/general.log.57 to /mysql/logs/general.log.58 (rotatecount 120, logstart 1, i 57), old log /mysql/logs/general.log.57 does not exist renaming /mysql/logs/general.log.56 to /mysql/logs/general.log.57 (rotatecount 120, logstart 1, i 56), old log /mysql/logs/general.log.56 does not exist renaming /mysql/logs/general.log.55 to /mysql/logs/general.log.56 (rotatecount 120, logstart 1, i 55), old log /mysql/logs/general.log.55 does not exist renaming /mysql/logs/general.log.54 to /mysql/logs/general.log.55 (rotatecount 120, logstart 1, i 54), old log /mysql/logs/general.log.54 does not exist renaming /mysql/logs/general.log.53 to /mysql/logs/general.log.54 (rotatecount 120, logstart 1, i 53), old log /mysql/logs/general.log.53 does not exist renaming /mysql/logs/general.log.52 to /mysql/logs/general.log.53 (rotatecount 120, logstart 1, i 52), old log /mysql/logs/general.log.52 does not exist renaming /mysql/logs/general.log.51 to /mysql/logs/general.log.52 (rotatecount 120, logstart 1, i 51), old log /mysql/logs/general.log.51 does not exist renaming /mysql/logs/general.log.50 to /mysql/logs/general.log.51 (rotatecount 120, logstart 1, i 50), old log /mysql/logs/general.log.50 does not exist renaming /mysql/logs/general.log.49 to /mysql/logs/general.log.50 (rotatecount 120, logstart 1, i 49), old log /mysql/logs/general.log.49 does not exist renaming /mysql/logs/general.log.48 to /mysql/logs/general.log.49 (rotatecount 120, logstart 1, i 48), old log /mysql/logs/general.log.48 does not exist renaming /mysql/logs/general.log.47 to /mysql/logs/general.log.48 (rotatecount 120, logstart 1, i 47), old log /mysql/logs/general.log.47 does not exist renaming /mysql/logs/general.log.46 to /mysql/logs/general.log.47 (rotatecount 120, logstart 1, i 46), old log /mysql/logs/general.log.46 does not exist renaming /mysql/logs/general.log.45 to /mysql/logs/general.log.46 (rotatecount 120, logstart 1, i 45), old log /mysql/logs/general.log.45 does not exist renaming /mysql/logs/general.log.44 to /mysql/logs/general.log.45 (rotatecount 120, logstart 1, i 44), old log /mysql/logs/general.log.44 does not exist renaming /mysql/logs/general.log.43 to /mysql/logs/general.log.44 (rotatecount 120, logstart 1, i 43), old log /mysql/logs/general.log.43 does not exist renaming /mysql/logs/general.log.42 to /mysql/logs/general.log.43 (rotatecount 120, logstart 1, i 42), old log /mysql/logs/general.log.42 does not exist renaming /mysql/logs/general.log.41 to /mysql/logs/general.log.42 (rotatecount 120, logstart 1, i 41), old log /mysql/logs/general.log.41 does not exist renaming /mysql/logs/general.log.40 to /mysql/logs/general.log.41 (rotatecount 120, logstart 1, i 40), old log /mysql/logs/general.log.40 does not exist renaming /mysql/logs/general.log.39 to /mysql/logs/general.log.40 (rotatecount 120, logstart 1, i 39), old log /mysql/logs/general.log.39 does not exist renaming /mysql/logs/general.log.38 to /mysql/logs/general.log.39 (rotatecount 120, logstart 1, i 38), old log /mysql/logs/general.log.38 does not exist renaming /mysql/logs/general.log.37 to /mysql/logs/general.log.38 (rotatecount 120, logstart 1, i 37), old log /mysql/logs/general.log.37 does not exist renaming /mysql/logs/general.log.36 to /mysql/logs/general.log.37 (rotatecount 120, logstart 1, i 36), old log /mysql/logs/general.log.36 does not exist renaming /mysql/logs/general.log.35 to /mysql/logs/general.log.36 (rotatecount 120, logstart 1, i 35), old log /mysql/logs/general.log.35 does not exist renaming /mysql/logs/general.log.34 to /mysql/logs/general.log.35 (rotatecount 120, logstart 1, i 34), old log /mysql/logs/general.log.34 does not exist renaming /mysql/logs/general.log.33 to /mysql/logs/general.log.34 (rotatecount 120, logstart 1, i 33), old log /mysql/logs/general.log.33 does not exist renaming /mysql/logs/general.log.32 to /mysql/logs/general.log.33 (rotatecount 120, logstart 1, i 32), old log /mysql/logs/general.log.32 does not exist renaming /mysql/logs/general.log.31 to /mysql/logs/general.log.32 (rotatecount 120, logstart 1, i 31), old log /mysql/logs/general.log.31 does not exist renaming /mysql/logs/general.log.30 to /mysql/logs/general.log.31 (rotatecount 120, logstart 1, i 30), old log /mysql/logs/general.log.30 does not exist renaming /mysql/logs/general.log.29 to /mysql/logs/general.log.30 (rotatecount 120, logstart 1, i 29), old log /mysql/logs/general.log.29 does not exist renaming /mysql/logs/general.log.28 to /mysql/logs/general.log.29 (rotatecount 120, logstart 1, i 28), old log /mysql/logs/general.log.28 does not exist renaming /mysql/logs/general.log.27 to /mysql/logs/general.log.28 (rotatecount 120, logstart 1, i 27), old log /mysql/logs/general.log.27 does not exist renaming /mysql/logs/general.log.26 to /mysql/logs/general.log.27 (rotatecount 120, logstart 1, i 26), old log /mysql/logs/general.log.26 does not exist renaming /mysql/logs/general.log.25 to /mysql/logs/general.log.26 (rotatecount 120, logstart 1, i 25), old log /mysql/logs/general.log.25 does not exist renaming /mysql/logs/general.log.24 to /mysql/logs/general.log.25 (rotatecount 120, logstart 1, i 24), old log /mysql/logs/general.log.24 does not exist renaming /mysql/logs/general.log.23 to /mysql/logs/general.log.24 (rotatecount 120, logstart 1, i 23), old log /mysql/logs/general.log.23 does not exist renaming /mysql/logs/general.log.22 to /mysql/logs/general.log.23 (rotatecount 120, logstart 1, i 22), old log /mysql/logs/general.log.22 does not exist renaming /mysql/logs/general.log.21 to /mysql/logs/general.log.22 (rotatecount 120, logstart 1, i 21), old log /mysql/logs/general.log.21 does not exist renaming /mysql/logs/general.log.20 to /mysql/logs/general.log.21 (rotatecount 120, logstart 1, i 20), old log /mysql/logs/general.log.20 does not exist renaming /mysql/logs/general.log.19 to /mysql/logs/general.log.20 (rotatecount 120, logstart 1, i 19), old log /mysql/logs/general.log.19 does not exist renaming /mysql/logs/general.log.18 to /mysql/logs/general.log.19 (rotatecount 120, logstart 1, i 18), old log /mysql/logs/general.log.18 does not exist renaming /mysql/logs/general.log.17 to /mysql/logs/general.log.18 (rotatecount 120, logstart 1, i 17), old log /mysql/logs/general.log.17 does not exist renaming /mysql/logs/general.log.16 to /mysql/logs/general.log.17 (rotatecount 120, logstart 1, i 16), old log /mysql/logs/general.log.16 does not exist renaming /mysql/logs/general.log.15 to /mysql/logs/general.log.16 (rotatecount 120, logstart 1, i 15), old log /mysql/logs/general.log.15 does not exist renaming /mysql/logs/general.log.14 to /mysql/logs/general.log.15 (rotatecount 120, logstart 1, i 14), old log /mysql/logs/general.log.14 does not exist renaming /mysql/logs/general.log.13 to /mysql/logs/general.log.14 (rotatecount 120, logstart 1, i 13), old log /mysql/logs/general.log.13 does not exist renaming /mysql/logs/general.log.12 to /mysql/logs/general.log.13 (rotatecount 120, logstart 1, i 12), old log /mysql/logs/general.log.12 does not exist renaming /mysql/logs/general.log.11 to /mysql/logs/general.log.12 (rotatecount 120, logstart 1, i 11), old log /mysql/logs/general.log.11 does not exist renaming /mysql/logs/general.log.10 to /mysql/logs/general.log.11 (rotatecount 120, logstart 1, i 10), old log /mysql/logs/general.log.10 does not exist renaming /mysql/logs/general.log.9 to /mysql/logs/general.log.10 (rotatecount 120, logstart 1, i 9), old log /mysql/logs/general.log.9 does not exist renaming /mysql/logs/general.log.8 to /mysql/logs/general.log.9 (rotatecount 120, logstart 1, i 8), old log /mysql/logs/general.log.8 does not exist renaming /mysql/logs/general.log.7 to /mysql/logs/general.log.8 (rotatecount 120, logstart 1, i 7), old log /mysql/logs/general.log.7 does not exist renaming /mysql/logs/general.log.6 to /mysql/logs/general.log.7 (rotatecount 120, logstart 1, i 6), old log /mysql/logs/general.log.6 does not exist renaming /mysql/logs/general.log.5 to /mysql/logs/general.log.6 (rotatecount 120, logstart 1, i 5), old log /mysql/logs/general.log.5 does not exist renaming /mysql/logs/general.log.4 to /mysql/logs/general.log.5 (rotatecount 120, logstart 1, i 4), old log /mysql/logs/general.log.4 does not exist renaming /mysql/logs/general.log.3 to /mysql/logs/general.log.4 (rotatecount 120, logstart 1, i 3), renaming /mysql/logs/general.log.2 to /mysql/logs/general.log.3 (rotatecount 120, logstart 1, i 2), renaming /mysql/logs/general.log.1 to /mysql/logs/general.log.2 (rotatecount 120, logstart 1, i 1), renaming /mysql/logs/general.log.0 to /mysql/logs/general.log.1 (rotatecount 120, logstart 1, i 0), old log /mysql/logs/general.log.0 does not exist log /mysql/logs/general.log.121 doesn't exist -- won't try to dispose of it rotating log /mysql/logs/slow-queries.log, log->rotateCount is 120 renaming /mysql/logs/slow-queries.log.120 to /mysql/logs/slow-queries.log.121 (rotatecount 120, logstart 1, i 120), old log /mysql/logs/slow-queries.log.120 does not exist renaming /mysql/logs/slow-queries.log.119 to /mysql/logs/slow-queries.log.120 (rotatecount 120, logstart 1, i 119), old log /mysql/logs/slow-queries.log.119 does not exist renaming /mysql/logs/slow-queries.log.118 to /mysql/logs/slow-queries.log.119 (rotatecount 120, logstart 1, i 118), old log /mysql/logs/slow-queries.log.118 does not exist renaming /mysql/logs/slow-queries.log.117 to /mysql/logs/slow-queries.log.118 (rotatecount 120, logstart 1, i 117), old log /mysql/logs/slow-queries.log.117 does not exist renaming /mysql/logs/slow-queries.log.116 to /mysql/logs/slow-queries.log.117 (rotatecount 120, logstart 1, i 116), old log /mysql/logs/slow-queries.log.116 does not exist renaming /mysql/logs/slow-queries.log.115 to /mysql/logs/slow-queries.log.116 (rotatecount 120, logstart 1, i 115), old log /mysql/logs/slow-queries.log.115 does not exist renaming /mysql/logs/slow-queries.log.114 to /mysql/logs/slow-queries.log.115 (rotatecount 120, logstart 1, i 114), old log /mysql/logs/slow-queries.log.114 does not exist renaming /mysql/logs/slow-queries.log.113 to /mysql/logs/slow-queries.log.114 (rotatecount 120, logstart 1, i 113), old log /mysql/logs/slow-queries.log.113 does not exist renaming /mysql/logs/slow-queries.log.112 to /mysql/logs/slow-queries.log.113 (rotatecount 120, logstart 1, i 112), old log /mysql/logs/slow-queries.log.112 does not exist renaming /mysql/logs/slow-queries.log.111 to /mysql/logs/slow-queries.log.112 (rotatecount 120, logstart 1, i 111), old log /mysql/logs/slow-queries.log.111 does not exist renaming /mysql/logs/slow-queries.log.110 to /mysql/logs/slow-queries.log.111 (rotatecount 120, logstart 1, i 110), old log /mysql/logs/slow-queries.log.110 does not exist renaming /mysql/logs/slow-queries.log.109 to /mysql/logs/slow-queries.log.110 (rotatecount 120, logstart 1, i 109), old log /mysql/logs/slow-queries.log.109 does not exist renaming /mysql/logs/slow-queries.log.108 to /mysql/logs/slow-queries.log.109 (rotatecount 120, logstart 1, i 108), old log /mysql/logs/slow-queries.log.108 does not exist renaming /mysql/logs/slow-queries.log.107 to /mysql/logs/slow-queries.log.108 (rotatecount 120, logstart 1, i 107), old log /mysql/logs/slow-queries.log.107 does not exist renaming /mysql/logs/slow-queries.log.106 to /mysql/logs/slow-queries.log.107 (rotatecount 120, logstart 1, i 106), old log /mysql/logs/slow-queries.log.106 does not exist renaming /mysql/logs/slow-queries.log.105 to /mysql/logs/slow-queries.log.106 (rotatecount 120, logstart 1, i 105), old log /mysql/logs/slow-queries.log.105 does not exist renaming /mysql/logs/slow-queries.log.104 to /mysql/logs/slow-queries.log.105 (rotatecount 120, logstart 1, i 104), old log /mysql/logs/slow-queries.log.104 does not exist renaming /mysql/logs/slow-queries.log.103 to /mysql/logs/slow-queries.log.104 (rotatecount 120, logstart 1, i 103), old log /mysql/logs/slow-queries.log.103 does not exist renaming /mysql/logs/slow-queries.log.102 to /mysql/logs/slow-queries.log.103 (rotatecount 120, logstart 1, i 102), old log /mysql/logs/slow-queries.log.102 does not exist renaming /mysql/logs/slow-queries.log.101 to /mysql/logs/slow-queries.log.102 (rotatecount 120, logstart 1, i 101), old log /mysql/logs/slow-queries.log.101 does not exist renaming /mysql/logs/slow-queries.log.100 to /mysql/logs/slow-queries.log.101 (rotatecount 120, logstart 1, i 100), old log /mysql/logs/slow-queries.log.100 does not exist renaming /mysql/logs/slow-queries.log.99 to /mysql/logs/slow-queries.log.100 (rotatecount 120, logstart 1, i 99), old log /mysql/logs/slow-queries.log.99 does not exist renaming /mysql/logs/slow-queries.log.98 to /mysql/logs/slow-queries.log.99 (rotatecount 120, logstart 1, i 98), old log /mysql/logs/slow-queries.log.98 does not exist renaming /mysql/logs/slow-queries.log.97 to /mysql/logs/slow-queries.log.98 (rotatecount 120, logstart 1, i 97), old log /mysql/logs/slow-queries.log.97 does not exist renaming /mysql/logs/slow-queries.log.96 to /mysql/logs/slow-queries.log.97 (rotatecount 120, logstart 1, i 96), old log /mysql/logs/slow-queries.log.96 does not exist renaming /mysql/logs/slow-queries.log.95 to /mysql/logs/slow-queries.log.96 (rotatecount 120, logstart 1, i 95), old log /mysql/logs/slow-queries.log.95 does not exist renaming /mysql/logs/slow-queries.log.94 to /mysql/logs/slow-queries.log.95 (rotatecount 120, logstart 1, i 94), old log /mysql/logs/slow-queries.log.94 does not exist renaming /mysql/logs/slow-queries.log.93 to /mysql/logs/slow-queries.log.94 (rotatecount 120, logstart 1, i 93), old log /mysql/logs/slow-queries.log.93 does not exist renaming /mysql/logs/slow-queries.log.92 to /mysql/logs/slow-queries.log.93 (rotatecount 120, logstart 1, i 92), old log /mysql/logs/slow-queries.log.92 does not exist renaming /mysql/logs/slow-queries.log.91 to /mysql/logs/slow-queries.log.92 (rotatecount 120, logstart 1, i 91), old log /mysql/logs/slow-queries.log.91 does not exist renaming /mysql/logs/slow-queries.log.90 to /mysql/logs/slow-queries.log.91 (rotatecount 120, logstart 1, i 90), old log /mysql/logs/slow-queries.log.90 does not exist renaming /mysql/logs/slow-queries.log.89 to /mysql/logs/slow-queries.log.90 (rotatecount 120, logstart 1, i 89), old log /mysql/logs/slow-queries.log.89 does not exist renaming /mysql/logs/slow-queries.log.88 to /mysql/logs/slow-queries.log.89 (rotatecount 120, logstart 1, i 88), old log /mysql/logs/slow-queries.log.88 does not exist renaming /mysql/logs/slow-queries.log.87 to /mysql/logs/slow-queries.log.88 (rotatecount 120, logstart 1, i 87), old log /mysql/logs/slow-queries.log.87 does not exist renaming /mysql/logs/slow-queries.log.86 to /mysql/logs/slow-queries.log.87 (rotatecount 120, logstart 1, i 86), old log /mysql/logs/slow-queries.log.86 does not exist renaming /mysql/logs/slow-queries.log.85 to /mysql/logs/slow-queries.log.86 (rotatecount 120, logstart 1, i 85), old log /mysql/logs/slow-queries.log.85 does not exist renaming /mysql/logs/slow-queries.log.84 to /mysql/logs/slow-queries.log.85 (rotatecount 120, logstart 1, i 84), old log /mysql/logs/slow-queries.log.84 does not exist renaming /mysql/logs/slow-queries.log.83 to /mysql/logs/slow-queries.log.84 (rotatecount 120, logstart 1, i 83), old log /mysql/logs/slow-queries.log.83 does not exist renaming /mysql/logs/slow-queries.log.82 to /mysql/logs/slow-queries.log.83 (rotatecount 120, logstart 1, i 82), old log /mysql/logs/slow-queries.log.82 does not exist renaming /mysql/logs/slow-queries.log.81 to /mysql/logs/slow-queries.log.82 (rotatecount 120, logstart 1, i 81), old log /mysql/logs/slow-queries.log.81 does not exist renaming /mysql/logs/slow-queries.log.80 to /mysql/logs/slow-queries.log.81 (rotatecount 120, logstart 1, i 80), old log /mysql/logs/slow-queries.log.80 does not exist renaming /mysql/logs/slow-queries.log.79 to /mysql/logs/slow-queries.log.80 (rotatecount 120, logstart 1, i 79), old log /mysql/logs/slow-queries.log.79 does not exist renaming /mysql/logs/slow-queries.log.78 to /mysql/logs/slow-queries.log.79 (rotatecount 120, logstart 1, i 78), old log /mysql/logs/slow-queries.log.78 does not exist renaming /mysql/logs/slow-queries.log.77 to /mysql/logs/slow-queries.log.78 (rotatecount 120, logstart 1, i 77), old log /mysql/logs/slow-queries.log.77 does not exist renaming /mysql/logs/slow-queries.log.76 to /mysql/logs/slow-queries.log.77 (rotatecount 120, logstart 1, i 76), old log /mysql/logs/slow-queries.log.76 does not exist renaming /mysql/logs/slow-queries.log.75 to /mysql/logs/slow-queries.log.76 (rotatecount 120, logstart 1, i 75), old log /mysql/logs/slow-queries.log.75 does not exist renaming /mysql/logs/slow-queries.log.74 to /mysql/logs/slow-queries.log.75 (rotatecount 120, logstart 1, i 74), old log /mysql/logs/slow-queries.log.74 does not exist renaming /mysql/logs/slow-queries.log.73 to /mysql/logs/slow-queries.log.74 (rotatecount 120, logstart 1, i 73), old log /mysql/logs/slow-queries.log.73 does not exist renaming /mysql/logs/slow-queries.log.72 to /mysql/logs/slow-queries.log.73 (rotatecount 120, logstart 1, i 72), old log /mysql/logs/slow-queries.log.72 does not exist renaming /mysql/logs/slow-queries.log.71 to /mysql/logs/slow-queries.log.72 (rotatecount 120, logstart 1, i 71), old log /mysql/logs/slow-queries.log.71 does not exist renaming /mysql/logs/slow-queries.log.70 to /mysql/logs/slow-queries.log.71 (rotatecount 120, logstart 1, i 70), old log /mysql/logs/slow-queries.log.70 does not exist renaming /mysql/logs/slow-queries.log.69 to /mysql/logs/slow-queries.log.70 (rotatecount 120, logstart 1, i 69), old log /mysql/logs/slow-queries.log.69 does not exist renaming /mysql/logs/slow-queries.log.68 to /mysql/logs/slow-queries.log.69 (rotatecount 120, logstart 1, i 68), old log /mysql/logs/slow-queries.log.68 does not exist renaming /mysql/logs/slow-queries.log.67 to /mysql/logs/slow-queries.log.68 (rotatecount 120, logstart 1, i 67), old log /mysql/logs/slow-queries.log.67 does not exist renaming /mysql/logs/slow-queries.log.66 to /mysql/logs/slow-queries.log.67 (rotatecount 120, logstart 1, i 66), old log /mysql/logs/slow-queries.log.66 does not exist renaming /mysql/logs/slow-queries.log.65 to /mysql/logs/slow-queries.log.66 (rotatecount 120, logstart 1, i 65), old log /mysql/logs/slow-queries.log.65 does not exist renaming /mysql/logs/slow-queries.log.64 to /mysql/logs/slow-queries.log.65 (rotatecount 120, logstart 1, i 64), old log /mysql/logs/slow-queries.log.64 does not exist renaming /mysql/logs/slow-queries.log.63 to /mysql/logs/slow-queries.log.64 (rotatecount 120, logstart 1, i 63), old log /mysql/logs/slow-queries.log.63 does not exist renaming /mysql/logs/slow-queries.log.62 to /mysql/logs/slow-queries.log.63 (rotatecount 120, logstart 1, i 62), old log /mysql/logs/slow-queries.log.62 does not exist renaming /mysql/logs/slow-queries.log.61 to /mysql/logs/slow-queries.log.62 (rotatecount 120, logstart 1, i 61), old log /mysql/logs/slow-queries.log.61 does not exist renaming /mysql/logs/slow-queries.log.60 to /mysql/logs/slow-queries.log.61 (rotatecount 120, logstart 1, i 60), old log /mysql/logs/slow-queries.log.60 does not exist renaming /mysql/logs/slow-queries.log.59 to /mysql/logs/slow-queries.log.60 (rotatecount 120, logstart 1, i 59), old log /mysql/logs/slow-queries.log.59 does not exist renaming /mysql/logs/slow-queries.log.58 to /mysql/logs/slow-queries.log.59 (rotatecount 120, logstart 1, i 58), old log /mysql/logs/slow-queries.log.58 does not exist renaming /mysql/logs/slow-queries.log.57 to /mysql/logs/slow-queries.log.58 (rotatecount 120, logstart 1, i 57), old log /mysql/logs/slow-queries.log.57 does not exist renaming /mysql/logs/slow-queries.log.56 to /mysql/logs/slow-queries.log.57 (rotatecount 120, logstart 1, i 56), old log /mysql/logs/slow-queries.log.56 does not exist renaming /mysql/logs/slow-queries.log.55 to /mysql/logs/slow-queries.log.56 (rotatecount 120, logstart 1, i 55), old log /mysql/logs/slow-queries.log.55 does not exist renaming /mysql/logs/slow-queries.log.54 to /mysql/logs/slow-queries.log.55 (rotatecount 120, logstart 1, i 54), old log /mysql/logs/slow-queries.log.54 does not exist renaming /mysql/logs/slow-queries.log.53 to /mysql/logs/slow-queries.log.54 (rotatecount 120, logstart 1, i 53), old log /mysql/logs/slow-queries.log.53 does not exist renaming /mysql/logs/slow-queries.log.52 to /mysql/logs/slow-queries.log.53 (rotatecount 120, logstart 1, i 52), old log /mysql/logs/slow-queries.log.52 does not exist renaming /mysql/logs/slow-queries.log.51 to /mysql/logs/slow-queries.log.52 (rotatecount 120, logstart 1, i 51), old log /mysql/logs/slow-queries.log.51 does not exist renaming /mysql/logs/slow-queries.log.50 to /mysql/logs/slow-queries.log.51 (rotatecount 120, logstart 1, i 50), old log /mysql/logs/slow-queries.log.50 does not exist renaming /mysql/logs/slow-queries.log.49 to /mysql/logs/slow-queries.log.50 (rotatecount 120, logstart 1, i 49), old log /mysql/logs/slow-queries.log.49 does not exist renaming /mysql/logs/slow-queries.log.48 to /mysql/logs/slow-queries.log.49 (rotatecount 120, logstart 1, i 48), old log /mysql/logs/slow-queries.log.48 does not exist renaming /mysql/logs/slow-queries.log.47 to /mysql/logs/slow-queries.log.48 (rotatecount 120, logstart 1, i 47), old log /mysql/logs/slow-queries.log.47 does not exist renaming /mysql/logs/slow-queries.log.46 to /mysql/logs/slow-queries.log.47 (rotatecount 120, logstart 1, i 46), old log /mysql/logs/slow-queries.log.46 does not exist renaming /mysql/logs/slow-queries.log.45 to /mysql/logs/slow-queries.log.46 (rotatecount 120, logstart 1, i 45), old log /mysql/logs/slow-queries.log.45 does not exist renaming /mysql/logs/slow-queries.log.44 to /mysql/logs/slow-queries.log.45 (rotatecount 120, logstart 1, i 44), old log /mysql/logs/slow-queries.log.44 does not exist renaming /mysql/logs/slow-queries.log.43 to /mysql/logs/slow-queries.log.44 (rotatecount 120, logstart 1, i 43), old log /mysql/logs/slow-queries.log.43 does not exist renaming /mysql/logs/slow-queries.log.42 to /mysql/logs/slow-queries.log.43 (rotatecount 120, logstart 1, i 42), old log /mysql/logs/slow-queries.log.42 does not exist renaming /mysql/logs/slow-queries.log.41 to /mysql/logs/slow-queries.log.42 (rotatecount 120, logstart 1, i 41), old log /mysql/logs/slow-queries.log.41 does not exist renaming /mysql/logs/slow-queries.log.40 to /mysql/logs/slow-queries.log.41 (rotatecount 120, logstart 1, i 40), old log /mysql/logs/slow-queries.log.40 does not exist renaming /mysql/logs/slow-queries.log.39 to /mysql/logs/slow-queries.log.40 (rotatecount 120, logstart 1, i 39), old log /mysql/logs/slow-queries.log.39 does not exist renaming /mysql/logs/slow-queries.log.38 to /mysql/logs/slow-queries.log.39 (rotatecount 120, logstart 1, i 38), old log /mysql/logs/slow-queries.log.38 does not exist renaming /mysql/logs/slow-queries.log.37 to /mysql/logs/slow-queries.log.38 (rotatecount 120, logstart 1, i 37), old log /mysql/logs/slow-queries.log.37 does not exist renaming /mysql/logs/slow-queries.log.36 to /mysql/logs/slow-queries.log.37 (rotatecount 120, logstart 1, i 36), old log /mysql/logs/slow-queries.log.36 does not exist renaming /mysql/logs/slow-queries.log.35 to /mysql/logs/slow-queries.log.36 (rotatecount 120, logstart 1, i 35), old log /mysql/logs/slow-queries.log.35 does not exist renaming /mysql/logs/slow-queries.log.34 to /mysql/logs/slow-queries.log.35 (rotatecount 120, logstart 1, i 34), old log /mysql/logs/slow-queries.log.34 does not exist renaming /mysql/logs/slow-queries.log.33 to /mysql/logs/slow-queries.log.34 (rotatecount 120, logstart 1, i 33), old log /mysql/logs/slow-queries.log.33 does not exist renaming /mysql/logs/slow-queries.log.32 to /mysql/logs/slow-queries.log.33 (rotatecount 120, logstart 1, i 32), old log /mysql/logs/slow-queries.log.32 does not exist renaming /mysql/logs/slow-queries.log.31 to /mysql/logs/slow-queries.log.32 (rotatecount 120, logstart 1, i 31), old log /mysql/logs/slow-queries.log.31 does not exist renaming /mysql/logs/slow-queries.log.30 to /mysql/logs/slow-queries.log.31 (rotatecount 120, logstart 1, i 30), old log /mysql/logs/slow-queries.log.30 does not exist renaming /mysql/logs/slow-queries.log.29 to /mysql/logs/slow-queries.log.30 (rotatecount 120, logstart 1, i 29), old log /mysql/logs/slow-queries.log.29 does not exist renaming /mysql/logs/slow-queries.log.28 to /mysql/logs/slow-queries.log.29 (rotatecount 120, logstart 1, i 28), old log /mysql/logs/slow-queries.log.28 does not exist renaming /mysql/logs/slow-queries.log.27 to /mysql/logs/slow-queries.log.28 (rotatecount 120, logstart 1, i 27), old log /mysql/logs/slow-queries.log.27 does not exist renaming /mysql/logs/slow-queries.log.26 to /mysql/logs/slow-queries.log.27 (rotatecount 120, logstart 1, i 26), old log /mysql/logs/slow-queries.log.26 does not exist renaming /mysql/logs/slow-queries.log.25 to /mysql/logs/slow-queries.log.26 (rotatecount 120, logstart 1, i 25), old log /mysql/logs/slow-queries.log.25 does not exist renaming /mysql/logs/slow-queries.log.24 to /mysql/logs/slow-queries.log.25 (rotatecount 120, logstart 1, i 24), old log /mysql/logs/slow-queries.log.24 does not exist renaming /mysql/logs/slow-queries.log.23 to /mysql/logs/slow-queries.log.24 (rotatecount 120, logstart 1, i 23), old log /mysql/logs/slow-queries.log.23 does not exist renaming /mysql/logs/slow-queries.log.22 to /mysql/logs/slow-queries.log.23 (rotatecount 120, logstart 1, i 22), old log /mysql/logs/slow-queries.log.22 does not exist renaming /mysql/logs/slow-queries.log.21 to /mysql/logs/slow-queries.log.22 (rotatecount 120, logstart 1, i 21), old log /mysql/logs/slow-queries.log.21 does not exist renaming /mysql/logs/slow-queries.log.20 to /mysql/logs/slow-queries.log.21 (rotatecount 120, logstart 1, i 20), old log /mysql/logs/slow-queries.log.20 does not exist renaming /mysql/logs/slow-queries.log.19 to /mysql/logs/slow-queries.log.20 (rotatecount 120, logstart 1, i 19), old log /mysql/logs/slow-queries.log.19 does not exist renaming /mysql/logs/slow-queries.log.18 to /mysql/logs/slow-queries.log.19 (rotatecount 120, logstart 1, i 18), old log /mysql/logs/slow-queries.log.18 does not exist renaming /mysql/logs/slow-queries.log.17 to /mysql/logs/slow-queries.log.18 (rotatecount 120, logstart 1, i 17), old log /mysql/logs/slow-queries.log.17 does not exist renaming /mysql/logs/slow-queries.log.16 to /mysql/logs/slow-queries.log.17 (rotatecount 120, logstart 1, i 16), old log /mysql/logs/slow-queries.log.16 does not exist renaming /mysql/logs/slow-queries.log.15 to /mysql/logs/slow-queries.log.16 (rotatecount 120, logstart 1, i 15), old log /mysql/logs/slow-queries.log.15 does not exist renaming /mysql/logs/slow-queries.log.14 to /mysql/logs/slow-queries.log.15 (rotatecount 120, logstart 1, i 14), old log /mysql/logs/slow-queries.log.14 does not exist renaming /mysql/logs/slow-queries.log.13 to /mysql/logs/slow-queries.log.14 (rotatecount 120, logstart 1, i 13), old log /mysql/logs/slow-queries.log.13 does not exist renaming /mysql/logs/slow-queries.log.12 to /mysql/logs/slow-queries.log.13 (rotatecount 120, logstart 1, i 12), old log /mysql/logs/slow-queries.log.12 does not exist renaming /mysql/logs/slow-queries.log.11 to /mysql/logs/slow-queries.log.12 (rotatecount 120, logstart 1, i 11), old log /mysql/logs/slow-queries.log.11 does not exist renaming /mysql/logs/slow-queries.log.10 to /mysql/logs/slow-queries.log.11 (rotatecount 120, logstart 1, i 10), old log /mysql/logs/slow-queries.log.10 does not exist renaming /mysql/logs/slow-queries.log.9 to /mysql/logs/slow-queries.log.10 (rotatecount 120, logstart 1, i 9), old log /mysql/logs/slow-queries.log.9 does not exist renaming /mysql/logs/slow-queries.log.8 to /mysql/logs/slow-queries.log.9 (rotatecount 120, logstart 1, i 8), old log /mysql/logs/slow-queries.log.8 does not exist renaming /mysql/logs/slow-queries.log.7 to /mysql/logs/slow-queries.log.8 (rotatecount 120, logstart 1, i 7), old log /mysql/logs/slow-queries.log.7 does not exist renaming /mysql/logs/slow-queries.log.6 to /mysql/logs/slow-queries.log.7 (rotatecount 120, logstart 1, i 6), old log /mysql/logs/slow-queries.log.6 does not exist renaming /mysql/logs/slow-queries.log.5 to /mysql/logs/slow-queries.log.6 (rotatecount 120, logstart 1, i 5), old log /mysql/logs/slow-queries.log.5 does not exist renaming /mysql/logs/slow-queries.log.4 to /mysql/logs/slow-queries.log.5 (rotatecount 120, logstart 1, i 4), old log /mysql/logs/slow-queries.log.4 does not exist renaming /mysql/logs/slow-queries.log.3 to /mysql/logs/slow-queries.log.4 (rotatecount 120, logstart 1, i 3), old log /mysql/logs/slow-queries.log.3 does not exist renaming /mysql/logs/slow-queries.log.2 to /mysql/logs/slow-queries.log.3 (rotatecount 120, logstart 1, i 2), renaming /mysql/logs/slow-queries.log.1 to /mysql/logs/slow-queries.log.2 (rotatecount 120, logstart 1, i 1), renaming /mysql/logs/slow-queries.log.0 to /mysql/logs/slow-queries.log.1 (rotatecount 120, logstart 1, i 0), old log /mysql/logs/slow-queries.log.0 does not exist log /mysql/logs/slow-queries.log.121 doesn't exist -- won't try to dispose of it renaming /mysql/logs/error.log to /mysql/logs/error.log.1 creating new log mode = 0660 uid = 27 gid = 27 renaming /mysql/logs/general.log to /mysql/logs/general.log.1 creating new log mode = 0660 uid = 27 gid = 27 renaming /mysql/logs/slow-queries.log to /mysql/logs/slow-queries.log.1 creating new log mode = 0660 uid = 27 gid = 27 running postrotate script [root@db01 /mysql/logs]# ll total 1675440 -rw-rw---- 1 mysql mysql 0 Aug 11 2009 error.log -rw-rw---- 1 mysql mysql 472 Aug 11 2009 error.log.1 -rw-rw---- 1 mysql mysql 472 Aug 11 15:03 error.log.2 -rw-rw---- 1 mysql mysql 472 Aug 11 14:57 error.log.3 -rw-rw---- 1 mysql mysql 0 Aug 11 2009 error.log-old -rw-rw---- 1 mysql mysql 213 Aug 11 2009 general.log -rw-rw---- 1 mysql mysql 827 Aug 11 2009 general.log.1 -rw-rw---- 1 mysql mysql 1082 Aug 11 15:03 general.log.2 -rw-rw---- 1 mysql mysql 37115 Aug 11 15:01 general.log.3 -rw-rw---- 1 mysql mysql 1693930999 Aug 11 11:06 general.log.4 -rw-rw---- 1 mysql mysql 177 Aug 11 2009 slow-queries.log -rw-rw---- 1 mysql mysql 354 Aug 11 2009 slow-queries.log.1 -rw-rw---- 1 mysql mysql 354 Aug 11 15:03 slow-queries.log.2 -rw-rw---- 1 mysql mysql 18263218 Aug 11 14:57 slow-queries.log.3 [root@db01 /mysql/logs]#
外部链接:
Rotating General Query & Slow Logs
Be careful rotating MySQL logs
Rotating logs - MySQL Administrator's Bible By Sheeri K. Cabral, Keith Murphy
5.2.6. Server Log Maintenance
5.2.3. The General Query Log
Truncating MySQL Log Files
How to logrotate mysq slow log files?
[rhelv5-list] where is mysql-log-rotate in RH EL 4/5 ?
参考MySQL某发行版本的配置文件
# This logname can be set in /etc/my.cnf
# by setting the variable "err-log"
# in the [safe_mysqld] section as follows:
#
# [safe_mysqld]
# err-log=/var/lib/mysql/mysqld.log
#
# If the root user has a password you have to create a
# /root/.my.cnf configuration file with the following
# content:
#
# [mysqladmin]
# password = <secret>
# user= root
#
# where "<secret>" is the password.
#
# ATTENTION: This /root/.my.cnf should be readable ONLY
# for root !
/var/lib/mysql/mysqld.log {
# create 600 mysql mysql
notifempty
daily
rotate 3
missingok
compress
postrotate
# just if mysqld is really running
if test -x /usr/bin/mysqladmin && \
/usr/bin/mysqladmin ping &>/dev/null
then
/usr/bin/mysqladmin flush-logs
fi
endscript
}
-fin-
No comments:
Post a Comment