[redland-dev] MySQL Free Connections

Simon Cross simon at sanbi.ac.za
Fri Aug 5 16:16:30 BST 2005


Ping,

On 08/05/05 17:04:01, Sebastian Dietzold wrote:
> Hi there, i use the php bindings of redland 1.0.2 and my problem is
> that there are up to 5 connections created each time i http-request a  
> script. these conns are not closed after the request so its easy  
> possible to dos every mysql-db.

I still see this problem too.  It's a little difficult to pin down  
exactly what is happening.  Some queries don't cause problems, others  
do.  I've worked around it by putting the common queries in a separate  
php process - the connections close when the process ends.

I haven't looked at the problem since the MySQL backend was patched to  
use persistent connections.  I would have thought that would have  
solved the problem or at least made things better but it seems that is  
not the case.

Does anything special have to be done to activate the persistent  
connections?

Schiavo
Simon



More information about the redland-dev mailing list