[ale] logrotate behavior

[Brian Pitts]

On Wed, 2009-01-07 at 09:51 -0500, Atlanta Geek wrote:
> I have mysql with debugging turned on running on a beta server.
> I turned on logrotate on the log but it looks like that the mysql
> daemon process never lets go of the old files. The mysqld.log.1 is
> still growing and nothing has been written to the mysqld.log.
> 
> So it looks like the filenode is still held by the existing process an
> it doesnt change until the mysql server closes and then reopens the
> file.
> So is there someway to get logrotate to deal with this or how do other
> people handle these situations with a constantly running daemon.
> 

mysqladmin flush-logs

http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html

-Brian