[sr-dev] DB API and connection keepalive

[Andrei Pelinescu-Onciul]

On Sep 22, 2009 at 09:28, Jason Penton <jason.penton at smilecoms.com> wrote:
> Hi *,
> 
> What would be the suggestions regarding having a process / thread that can
> be used to ping (keepalive) a connection to a particular db backend. I am
> specifically looking at coding something for mysql (our firewall is closing
> connections to mysql if they are idle for longer than 30mins). I would like
> to have a process that would go through all connections and "ping" them
> every so often. I would imagine each DB impl can either ignore the ping
> function or actually do something with it. I would imagine this will be
> useful for a few backend db implementations. Any input before I go ahead?

Doesn't modparam("db_mysql", "ping_interval", 15)  work?

Andrei