At 11:43 +0200 6/26/02, Gary Colman wrote:
>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
You may not see an explict FLUSH LOGS query. Do you seen any
lines that say "Refresh" after a connect event? That's what
appears in the log if someone executes "mysqladmin reload",
which causes a reload without an explicit query. Something like
this:
Time Id Command Argument
020626 9:31:26 1 Connect root@localhost on
1 Refresh
1 Quit
>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
---------------------------------------------------------------------
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
