too many PERSISTANT connections

[asolell]

Hi,

I used php-dbi functions in my website and they worked great until yesterday. Yesterday my hosting provider disconnected me
from my MySQL after he informed me that he found multiple sleeping connection to the database.
I ran

mysqladmin -u MYDOMAINNAMEHERE -p processlist

to see if this is the case, and indeed I found that I was creating such sleeping connections.

I decided to isolate the cause in the code and find where is it that I create multiple sleeping connections.

This is where I actually asking for your help:

I'm not savvy with db admin, but my understanding is that:

Using mysql_pconnect I'm establishing a persistant connection and whenever I'm calling dbi_query in my page
I'm 'skipping' the connection procedure again to the db, as it is using the persistant link.
That is good and great. The problem is, that I think that is not happening with my calls. I believe I'm creating
persistant connections but never re-use them or at least the code doesn't recognize them and opens another
connection for each query.
The question now is, how do trace the query that initiated the persistent connection, and why is it that it
is not recognized as an open connection?
Last, when and how does a persistant connection dies? dbi_close doesn't work with it. What does?

Thanks for your help.

-Alon.

[asolell]

I tend to believe that persistant connection are the mother of all evils!

I changed the mysql_pconnect to mysql_connect and everything works great! No more sleeping processes.

From what I've read so far, it really didn't make any sense in using persistant connections. The ovehead of connecting and opening the db is a non-issue which is the only reason why to use the persistant connection.
There is no sharing of resources between the queries so literally the only thing saved is the open db and connect.
In my case, and my guess in others as well, it is very low efficiency saving procedure and at the same time, ties your db connection! So it is something to avoid. At least on my end.