On Mon, Aug 9, 2010 at 7:58 PM, Umberto Masotti <u.masotti@...> wrote:

>
>
> Hi Milan,
>
>
> On 09/08/2010 15:04, Milan Babuskov wrote:
> > Umberto wrote:
> >> PHP ibase_pconnect() uses pooled permanent connections.
> >> Note that it's not PHP, but Apache that keeps alive connections.
> >
> > Which one can check with the following Apache settings:
> >
> > KeepAlive
> > MaxKeepAliveRequests
> > KeepAliveTimout
> >
>
> Maybe I'm wrong reading Apache 2.2 on-line manuals because I've not read
> technical papers about its internal workings.
> AFAIU these are virtual host only core module configuration settings
> that apply to HTTP sessions to keep alive client connection.
> php_interbase is activated if declared in php.ini, so it's mod_php that
> keeps alive Firebird connections (I guess).
> Don't understand how this configuration parameters can release FB
> permanent connections when not needed for some time. Only guess: they
> release mod_php that shut down his pool of connections.
> Is this a correct guess?
>

another option is to kill the connection from firebird and add it to a cron
job

2) Disconnect everybody but ourselves (new in Firebird 2.5)

DELETE FROM MON$ATTACHMENTS
WHERE MON$ATTACHMENT_ID <> CURRENT_CONNECTION

>
> Ciao.
> Mimmo.
>
>
>

[Non-text portions of this message have been removed]