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.
--- On Thu, 7/21/11, Johan De Meersman <vegivamp@stripped> wrote:
> From: Johan De Meersman <vegivamp@stripped>
> 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
> duplicate IP. Check your slave's IP configuration.
>
> If they're virtual, you might also have trouble with the
> switch not wanting more than one mac-address on the same
> port - talk to the network people for that.
>
> ----- Original Message -----
> > From: "Rick James" <rjames@stripped>
> > To: "Johan De Meersman" <vegivamp@stripped>
> > Cc: database100@stripped,
> "Replication" <replication@stripped>
> > Sent: Thursday, 21 July, 2011 7:46:33 PM
> > Subject: Re: Slave receives end packet from master
> >
> > Actually, they ping-pong. One Slave gets to talk
> to the master, then
> > (somehow) the connection is dropped and the other
> Slave gets the
> > connection.
> >
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
> --
> MySQL Replication Mailing List
> For list archives: http://lists.mysql.com/replication
> To unsubscribe: http://lists.mysql.com/replication?unsub=1
>
>
--
MySQL Replication Mailing List
For list archives: http://lists.mysql.com/replication
To unsubscribe: http://lists.mysql.com/replication?unsub=1
--
Best Regards,
Prabhat Kumar
MySQL DBA
My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat
