Subject: rotating binary log files...
Can anyone shed some light on how we should be rotating the binary log
files?
I am running version 3.23.37.
In the manual it states to flush the logs, or execute a refresh command and
that would close the existing log file and rename it to .1 extension and
then open a new clean log file in its place.
However, this does not happen. Flushing the logs doesn't even seem to close
the current log file.
Try this. Enable a binary log file, then rename it to some other name.
Then execute a flush logs command.
Mysql keeps the original file open and doesn't open a new one. The only way
I have seen that works so far it to shut the server down and then restart
it. But that really isn't an open on a frequently used server.
Any ideas? Has anyone else run into this?
Thanks in advance.
Mike Farley
JobCircle.com
email: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php