slave-net-timeout

Hi,

According to the manual, the slave-net-timeout specifies how long time to wait
for data from the master before considering the connection dead. From my
experience this actually means that the slave will reconnect if it hasn't
received a full event in that period of time.

E.g. setting slave_net_timeout to 180 seconds, then an event that takes 240
seconds to transfer will never make it through. The replication will make it
75% through and then start all over.

Does anyone know whether that is a bug in the implementation, or whether it is
the documentation that could be more clear?

Thanks,
Jesper

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: slave-net-timeout

--0016367b6f7a52b0fc04878fc425
Content-Type: text/plain; charset=ISO-8859-1

On Thu, May 27, 2010 at 1:43 AM, Jesper Wisborg Krogh
wrote:

> E.g. setting slave_net_timeout to 180 seconds, then an event that takes 240
> seconds to transfer will never make it through. The replication will make
> it
> 75% through and then start all over.
>

Without bothering to read or test, I'd guess that if an event takes 240
seconds to be sent, then that means that for 240 seconds, data is being
pumped.

Also, there's undoubtedly a keepalive in the protocol for those quiet times.


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

--0016367b6f7a52b0fc04878fc425--