List:Replication« Previous MessageNext Message »
From:Database System Date:July 22 2011 2:34pm
Subject:Re: Slave receives end packet from master
View as plain text  
Thanks. This is the first time we enable innodb. 

--- On Fri, 7/22/11, Johan De Meersman <vegivamp@stripped> wrote:


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



#yiv1353405399 p {margin:0;}

the ib_logfiles are not readable logfiles, they're part of the transaction system and are
preallocated fully; they won't grow with use.




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