Kristen G. Thorson wrote:
> Hi all,
>
> This may be a simple solution that I'm just not seeing. logrotate has
> trouble with binlogs since the extension keeps changing, so instead of
> actually rotating logs out, I just get a dir filled with
>
> binlog.001.1
> binlog.002.1
> binlog.003.1
> binlog.004.1
> binlog.005.1
> binlog.006.1
>
> and on to inifinity. The manual says "If you supply an extension in
> the log name (for example, |--log-bin=/|file_name.extension|/|), the
> extension is silently removed and ignored," so it appears I'm stuck.
> Does anyone have some pointer for me to set up auto-rotation? I'm
> somehow not finding much info on this.
>
>
> kgt
>
>
Don't do that. You will break replication.
Set up a cron job to flush logs instead.
