You're wrong.The new log file will be generated when you flush logs
manually.
On Fri, Oct 24, 2008 at 2:23 AM, Olaf Stein <
[EMAIL PROTECTED]> wrote:
> And I assume you backup script also archives or removes the old log file,
> because flush-logs does not start a new log file if there is still on
Nope, we use the expire_logs_days parameter in MySQL's my.cnf (set to
expire_logs_days=7 - removes log files that are 7 days old.)
mysqldump's flush-logs does indeed begin a new log - that's the idea of it:
# ls -l /srv/mysql
rw-rw 1 mysql localservice 213 2008-10-16 00:56 sql-m2-bin
And I assume you backup script also archives or removes the old log file,
because flush-logs does not start a new log file if there is still one
present
On 10/23/08 2:20 PM, "Andy Shellam" <[EMAIL PROTECTED]> wrote:
> Hi Olaf,
>
> We use our mysqldump script to rotate the binlogs; it's much saf
Hi Olaf,
We use our mysqldump script to rotate the binlogs; it's much safer as it
allows MySQL to do the log rotate natively (if you use logrotate, MySQL
will complain that either the log doesn't exist when it expects it to,
or your slaves will bail out because they didn't know the log was
ch
Thanks all...
Rotating actually does not affect the slaves, they adjust to the new binlog
just fine, I guess I should have tried that first.
I will nevertheless take a closer look at logrotate...
Olaf
On 10/23/08 12:13 PM, "Uwe Kiewel" <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Olaf Stein schrieb:
> Hi all
>
> Is it possible to rotate just the regular (--log) log file?
I am not sure if it will be safe, but maybe with logrotate and for
/var/log/mysqld.log the "copytruncate" option for logrotate.
> If I do flush-logs I have t
Hi all
Is it possible to rotate just the regular (--log) log file?
If I do flush-logs I have to tell my slaves that (at least I have done so in
the past, maybe I don't and the slves realizes by itself?)
Thanks
Olaf
- Confidentiality Notice:
The following m