Re: thousands of binary log files

2002-06-26 Thread Paul DuBois
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" afte

Re: thousands of binary log files

2002-06-26 Thread Gary Colman
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 in

Re: thousands of binary log files

2002-06-25 Thread Paul DuBois
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.x" >According to the logs, this should happen only when a reload or flush >type command is issued ... > >mysql variables: >flush

thousands of binary log files

2002-06-25 Thread Gary Colman
Hi Every few seconds, my mysql server generates a new binary log file with an incremented id number "${hostname}-bin.x" 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 107