[jifty-devel] Jifty server stuck
Stanislav Sinyagin
ssinyagin at yahoo.com
Tue Jan 22 19:56:12 EST 2008
----- 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?
More information about the jifty-devel
mailing list