Logrotate Mysql – 不发生旋转

我使用CentOS5，我有以下版本的mysql：

mysql Ver 14.12 Distrib 5.0.77，用于使用readline 5.1的redhat-linux-gnu（i686）

我想使用logrotate旋转mysql的日志。

让我们考虑一下，我只想旋转文件/var/lib/mysql/mysql-log.log作为例子。 我在下面描述了我所遵循的过程，我已经注意到的logrotate行为，然后给出了我的configuration文件的内容。

• 如何解决我的Windows / Linuxnetworking上的主机名？
• 如何在没有cPanel的情况下pipe理我的CentOS VPS
• 保护Linux中某些用户的源代码
• Linux服务器的性能比较
• Linux隐形进程

我遵循这些步骤：

1. 我在/etc/logrotate.d中添加了一个名为mysql的文件（见下面的内容），拥有660个权限（文件属于root）
2. 我试图用命令“logrotate -dv –force /etc/logrotate.conf”强制旋转

我注意到的行为：

• 由logrotate命令产生的消息似乎向我显示/var/lib/mysql/mysql-log.log已被旋转
• 实际上，在/ var / lib / mysql /中没有“mysql-log。*”，只有原始文件/var/lib/mysql/mysql-log.log，与执行命令之前一样大。

我现在给你我的onfig文件，而日志的提取产生了我关心mysql的命令logrotate。

/etc/logrotate.conf中

# see "man logrotate" for details # rotate log files weekly weekly # keep 4 weeks worth of backlogs rotate 4 # create new (empty) log files after rotating old ones create # uncomment this if you want your log files compressed #compress # RPM packages drop log rotation information into this directory include /etc/logrotate.d # no packages own wtmp -- we'll rotate them here /var/log/wtmp { monthly minsize 1M create 0664 root utmp rotate 1 } # system-specific logs may be also be configured here. 

/etc/logrotate.d/mysql

 /var/lib/mysql/mysql-log.log { rotate 4 daily nocompress missingok create 660 mysql mysql postrotate if ls /proc/`cat /var/run/mysqld/mysqld.pid` > /dev/null then /usr/bin/mysqladmin -pMotDePasseSqlRoot flush-logs fi endscript } 

这里是我注意到有关mysql的logrotate日志：

 reading config file mysql reading config info for /var/lib/mysql/mysql-log.log ... rotating pattern: /var/lib/mysql/mysql-log.log forced from command line (4 rotations) empty log files are rotated, old logs are removed considering log /var/lib/mysql/mysql-log.log log needs rotating rotating log /var/lib/mysql/mysql-log.log, log->rotateCount is 4 renaming /var/lib/mysql/mysql-log.log.4 to /var/lib/mysql/mysql-log.log.5 (rotatecount 4, logstart 1, i 4), renaming /var/lib/mysql/mysql-log.log.3 to /var/lib/mysql/mysql-log.log.4 (rotatecount 4, logstart 1, i 3), renaming /var/lib/mysql/mysql-log.log.2 to /var/lib/mysql/mysql-log.log.3 (rotatecount 4, logstart 1, i 2), renaming /var/lib/mysql/mysql-log.log.1 to /var/lib/mysql/mysql-log.log.2 (rotatecount 4, logstart 1, i 1), renaming /var/lib/mysql/mysql-log.log.0 to /var/lib/mysql/mysql-log.log.1 (rotatecount 4, logstart 1, i 0), renaming /var/lib/mysql/mysql-log.log to /var/lib/mysql/mysql-log.log.1 creating new log mode = 0660 uid = 27 gid = 27 running postrotate script running script with arg /var/lib/mysql/mysql-log.log : " if ls /proc/`cat /var/run/mysqld/mysqld.pid` > /dev/null then /usr/bin/mysqladmin -pMotDePasseSqlRoot flush-logs fi " removing old log /var/lib/mysql/mysql-log.log.5 

你有什么想法为什么logrotates报告一个不实际的行动？ 我在定义我的文件/etc/logrotated.d/mysql之前还是之后错过了一个步骤？

谢谢你的帮助 ！

西尔

 # If the root user has a password you have to create a # /.my.cnf configuration file with the following # content: # # [mysqladmin] # password = <secret> # user = <username> # # where "<secret>" is the password and <username> is user. # # ATTENTION: This /.my.cnf should be readable ONLY # for root ! /var/log/mysqld.log { create 640 mysql mysql notifempty missingok postrotate # just if mysqld is really running if test -x /usr/bin/mysqladmin && \ /usr/bin/mysqladmin --defaults-extra-file=/root/mysql/logrotate.cnf ping &>/dev/null then /usr/bin/mysqladmin --defaults-extra-file=/root/mysql/logrotate.cnf flush-logs fi /usr/bin/chcon -u system_u -r object_r -t mysqld_log_t /var/log/mysqld.log endscript } 

 [client] user = root password = TheRootPassword