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

Reply via email to