Is there any way to configure idle connection timeout on silent connections? If its not configurable, can it be done by querying system tables and deleting idle registers from MON$ATTACHMENTS?
I have a sub-optimal situation in my stack, with php and firebird. Php with fpm-fastcgi creates a pool of x number of php processes that waits for connections. This have a minimum number of servers configured, for instance, even if there are no one using the server, there will always be 5 php processes opened waiting for connections. If more php processes are needed the pool will generate them. The problem is, every time a persistent connection is opened by php, chances are it will never be closed, because the php process will never close (until it reaches max_requests and auto recycles, but thats a pretty long time). Even if I keep max_requests really low, when server usage is high, the number of opened idle connections will also be very high, consuming an amount of RAM thats unsupportable. Also, from what I have tested and monitored, php doesnt seems to be effectively reutilizing firebird connections which are already opened, it seems to create more then needed. Furthermore, in a multi-user environment, we cannot manually close firebird connections from php it would kill the whole point of using resusable persistent connections. Atenciosamente, Rudi Feijó Multidados Informática Ltda. * (11) 2579-8794 / 2579-8795 * <mailto:[email protected]> [email protected] * <http://www.multidadosti.com.br/> www.multidadosti.com.br <http://www.timesheet.com.br/> www.timesheet.com.br [Non-text portions of this message have been removed]
