List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 26 2002 2:31pm
Subject:Re: thousands of binary log files
View as plain text  
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 <mysql-thread113017@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
thousands of binary log filesGary Colman25 Jun
Re: thousands of binary log filesPaul DuBois25 Jun
  • Re: thousands of binary log filesGary Colman26 Jun
Re: thousands of binary log filesPaul DuBois27 Jun