mr_fern

It seems Persistent Connections are a trouble for users on shared hosting, as persistent connections can easily lead to blocked access to their databases once they've used up their alloted number of connections, which is not very high since its shared. Most users are using PHP with these MySQL databases.

After going through my own PHP Config php.ini file, I noticed that there's a directive

So why aren't the shared servers set with a value of Off?

I'm assuming that if this value is set to Off, even if the persistent connection function is used it would still be a dynamic connection. I say assume since the php.net manual doesn't specify what happens on the mysql_pconnect function page.

__________________
Nobody doing nothing

David

I was reading about this earlier when trying to figured out why another user's Invision Board message board keeps coming up with a max_connections error. I wasn't sure if Persistant Connections was on or off on these shared servers. I assumed it was off, which is what really puzzelled me.

From what you're saying, with PC on, that may very well be the reason the max connections error comes up?

__________________

mr_fern

That's usually the cause, that or slow/delayed queries. Those slow queries just cause a spiral down in performance, and they aren't always even queries using tables frequently accessed.

__________________
Nobody doing nothing

David

Hmm. *checks server php.ini file*

actually, maybe I'll do that later. My password is too ridiculous and long to look up again and type in lol

__________________