[jifty-devel] Jifty server stuck

[Stanislav Sinyagin]

----- Original Message ----
> From: Jesse Vincent <jesse at bestpractical.com>
> > before '**' => run { Jifty->handle->connect };
> > 
> > That will not reconnect if the current connection is still up
> and
> 
 running,
> > but it will ping the database connection to check for liveness. If
> it
> 
 fails
> > the liveness test, it will reconnect.
> > 
> > That's resolved the problem on my servers. I hope that helps.
> 
> 
> It _should_ be possible to sink that down into Jifty::DBI,
> possibly
> 
 down
> as far as ::Handle->simple_query. (Say, trap a failure and retry if you
> get a not-connected error?) That way you don't get the overhead of a
> ping before each statement.

why not setting up a timer two times shorter than standard MySQL timeout 
and ping the DB server when this timer expires?