List:Replication« Previous MessageNext Message »
From:Johan De Meersman Date:July 22 2011 2:24pm
Subject:Re: Slave receives end packet from master
View as plain text  
the ib_logfiles are not readable logfiles, they're part of the transaction system and are
preallocated fully; they won't grow with use. 

----- Original Message -----

> From: "Database System" <database100@stripped>
> To: "Prabhat Kumar" <aim.prabhat@stripped>
> Cc: "Rick James" <rjames@stripped>, "Johan De Meersman"
> <vegivamp@stripped>, "Replication" <replication@stripped>
> Sent: Friday, 22 July, 2011 3:32:24 PM
> Subject: Re: Slave receives end packet from master

> Hi Prabhat,

> You have a good point. But after I did that, it didn't help.

> In my MySQL 5.0 servers, all the relay_log_space_limit =0, but
> replications work fine. Is this something new, have to setup on 5.1?
> I looked 5.1 manual on setting up replication, it doesn't mention to
> setup this variable. Do you know how to use it, is the size for all
> the relay log files? or for each relay log file?

> By the way, we haven't put data in innodb table yet, but why
> ib_logfile0 and ib_logfile1 size is very big already? How to read
> these file?

> Thank you so much,
> Lisa

> --- On Thu, 7/21/11, Prabhat Kumar <aim.prabhat@stripped> wrote:

> > From: Prabhat Kumar <aim.prabhat@stripped>
> 
> > Subject: Re: Slave receives end packet from master
> 
> > To: database100@stripped
> 
> > Cc: "Rick James" <rjames@stripped>, "Johan De Meersman"
> > <vegivamp@stripped>, "Replication" <replication@stripped>
> 
> > Date: Thursday, July 21, 2011, 3:57 PM
> 

> > try with increasing the 'relay_log_space_limit', might be if
> > connections are made everytime the slave thread pauses for more
> > space to be freed up.
> 
> > mysql> SHOW VARIABLES LIKE 'relay_log_space_limit';
> 

> > Thanks,
> 

> > On Thu, Jul 21, 2011 at 12:36 PM, Database System <
> > database100@stripped > wrote:
> 

> > > I said that is not my case.
> > 
> 

> > > > Subject: Re: Slave receives end packet from master
> > 
> 
> > > > To: "Rick James" < rjames@stripped >
> > 
> 

> > > > Cc: database100@stripped , "Replication" <
> > > > replication@stripped >
> > 
> 
> > > > Date: Thursday, July 21, 2011, 1:59 PM
> > 
> 

> > > > Ooh, that definitely stinks of a
> > 
> 

> > > > To unsubscribe:
> > > > http://lists.mysql.com/replication?unsub=1
> > 
> 

> > > >
> > 
> 
> > --
> 
> > Bier met grenadyn
> 
> > Is als mosterd by den wyn
> 
> > Sy die't drinkt, is eene kwezel
> 
> > Hy die't drinkt, is ras een ezel
> 

Thread
Slave receives end packet from masterDatabase System20 Jul
  • Re: Slave receives end packet from masterJohan De Meersman20 Jul
    • Re: Slave receives end packet from masterRick James20 Jul
      • Re: Slave receives end packet from masterDatabase System20 Jul
      • Re: Slave receives end packet from masterJohan De Meersman21 Jul
        • Re: Slave receives end packet from masterRick James21 Jul
          • Re: Slave receives end packet from masterJohan De Meersman21 Jul
            • Re: Slave receives end packet from masterDatabase System21 Jul
              • Re: Slave receives end packet from masterPrabhat Kumar21 Jul
                • Re: Slave receives end packet from masterDatabase System22 Jul
                  • Re: Slave receives end packet from masterJohan De Meersman22 Jul
                    • Re: Slave receives end packet from masterDatabase System22 Jul
                  • Re: Slave receives end packet from masterEber Duarte22 Jul
                • Re: Slave receives end packet from masterDatabase System22 Jul
              • Re: Slave receives end packet from masterAlfie John21 Jul
    • Re: Slave receives end packet from masterDatabase System20 Jul
      • Re: Slave receives end packet from masterRick James20 Jul
        • Re: Slave receives end packet from masterDatabase System20 Jul
          • Re: Slave receives end packet from masterWagner Bianchi21 Jul
            • Re: Slave receives end packet from masterDatabase System21 Jul
      • Re: Slave receives end packet from masterJohan De Meersman21 Jul