LKML Archive on
help / color / mirror / Atom feed
From: Nicolas Cannasse <>
Subject: Re: poll() blocked / packets not received ?
Date: Mon, 20 Oct 2008 19:24:14 +0200	[thread overview]
Message-ID: <> (raw)
In-Reply-To: <>

David Schwartz a écrit :
>> At least I will have nice sleep tonight.
> Note that this solved your symptom, not your problem. You actually have two
> problems:
> 1) You rely on TCP to detect a lost connection even by a side that will
> never transmit any data. TCP simply does not do this. If you are not trying
> to send data, you are not assured that a lost connection will be detected.
> (You either need a timeout, or you need to send or dribble some data,
> depending on the protocl.)
> 2) You hold a lock on a shared resource while you wait for a reply over a
> network. If this is a low-level "block and wait indefinitely" lock, this
> will cause many threads to line up behind a slow/stuck thread. The right fix
> depends on your circumstances, but you need to use a synchronization
> primitive that is suitable. (You need to be able to use multiple connections
> or defer operations without holding a thread.)

I agree with both points, but I can't modify the MySQL protocol to 
implement that.

For (1) I can't add the timeout since I have no way to differentiate 
between a lost connection and a request that takes time to execute. I'll 
maybe check if the protocol allow pings while waiting for the request 
result, but I'm not sure it does.

For (2) the shared resources is on the database side, not on the server 
side. It's the transaction that have some rows locked. I have no 
solution for that.


  reply	other threads:[~2008-10-20 17:25 UTC|newest]

Thread overview: 10+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2008-10-20  8:25 Nicolas Cannasse
2008-10-20 10:15 ` swivel
2008-10-20 10:46   ` Nicolas Cannasse
2008-10-20 11:39     ` swivel
2008-10-20 12:13       ` Nicolas Cannasse
2008-10-20 12:39       ` Nicolas Cannasse
2008-10-20 15:53         ` David Schwartz
2008-10-20 17:24           ` Nicolas Cannasse [this message]
2008-10-20 23:21             ` David Schwartz
2008-10-21  5:12             ` Willy Tarreau

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \ \ \ \ \ \
    --subject='Re: poll() blocked / packets not received ?' \

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for NNTP newsgroup(s).