Hi
Paul - Thanks for your suggestion.
Unfortunately the general query log indicates that there is
no hint of any external interference and it still rotates
every few seconds ... there are constant accesses to the DB,
and the bin-log is rotated mid-connection by a querying client.
I have an inkling perhaps updating the mysqld may make a difference,
even though I cannot find anything mentioned in the TODO's or fixes.
Almost every file is only 65 bytes long, and shows:
[root@mysql mysql]# mysqlbinlog mysql-bin.61676
# at 4
#020626 9:54:19 server id 12 Rotate to mysql-bin.61677pos=4
# at 46
#020626 9:57:48 server id 2 Stop
[root@mysql mysql]# mysqlbinlog mysql-bin.61677
# at 4
#020626 9:54:19 server id 12 Rotate to mysql-bin.61678pos=4
# at 46
#020626 9:57:56 server id 2 Stop
[root@mysql mysql]# mysqlbinlog mysql-bin.61678
# at 4
#020626 9:54:39 server id 12 Rotate to mysql-bin.61679pos=4
# at 46
#020626 9:58:04 server id 2 Stop
See - it's REALLY frequent..
*shrug* who knows ... Anyone?? ;)
G
On Tue, 25 Jun 2002, Paul DuBois wrote:
> At 16:31 +0200 6/25/02, Gary Colman wrote:
> >Hi
> >
> >Every few seconds, my mysql server generates a new binary log file
> >with an incremented id number "${hostname}-bin.xxxxx"
> >According to the logs, this should happen only when a reload or flush
> >type command is issued ...
> >
> >mysql variables:
> >flush off
> >log_bin on
> >max_binlog_size 1073741824
> >version 4.0.1-alpha-Max-log
> >
> >It is running on an i386 running RedHat Linux 6.2
> >
> >
> >Any ideas, anyone ??
>
> If you turn on general query logging, the query log may tell you
> if and when reload or flush commands are issued and where they're
> coming.
>
> Maybe there's an out-of-control cron job running.
>
> >
> >Many thanks
> > Gary
>
---------------------------------------------------------------------
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
