List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:July 17 2009 9:01pm
Subject:RE: Slave log files going nuts...
View as plain text  
The binlogs are closed and reopened every time you do a FLUSH LOGS; command, or when the
server restarts.  Is your server crashing continuously?  Take a look at your error log as
well.

Regards,
Gavin Towey

-----Original Message-----
From: Gary Smith [mailto:Gary@stripped]
Sent: Thursday, July 16, 2009 3:16 PM
To: Todd Lyons
Cc: mysql@stripped
Subject: RE: Slave log files going nuts...

I'll have to look into that.  We have a single cronjob that just does a mysqldump daily
but not during the time of the log file generation, but that's all I can think of off the
top of my head.

Gary

________________________________________
From: tlyons@stripped [tlyons@stripped] On Behalf Of Todd Lyons
[tlyons@stripped]
Sent: Thursday, July 16, 2009 2:41 PM
To: Gary Smith
Cc: mysql@stripped
Subject: Re: Slave log files going nuts...

On Thu, Jul 16, 2009 at 1:18 PM, Gary Smith<Gary@stripped> wrote:
> I have a new slave I setup against a new master server.  The master server has 4 log
> files in it, the most current being updated on the 16th.  The slave server on the other
> hand has several files, many which seem to be blank.  This slave is set to slave the
> master and act as a master for downstream slaves.  Note, there is no master/master on this
> configuration, even though the master itself could do it.
>
> Any ideas?

Something is doing several 'mysqladmin refresh' or a related command,
all sequentially in a row in short order.  Look at your cron jobs that
start or end around the time that all those "empty" binlogs are being
created.

--
Regards...      Todd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.
Thread
Slave log files going nuts...Gary Smith16 Jul
  • Re: Slave log files going nuts...Todd Lyons16 Jul
    • RE: Slave log files going nuts...Gary Smith17 Jul
      • RE: Slave log files going nuts...Gavin Towey17 Jul
        • RE: Slave log files going nuts...Gary Smith19 Jul