[ale] logrotate behavior

[Atlanta Geek]

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.

-- 
http://www.atlantageek.com