[RESOLVED] mysql_connect vs. mysql_pconnect in mysql connections limits issue

blackhorse

According to the manual, mysql_pconnect may exceed the number of connections allowed by MySQL. so I am using mysql_connect instead of mysql_pconnect.

The php manual said that "Note: The link to the server will be closed as soon as the execution of the script ends"

But, I saw this note in the http://ca.php.net/manual/en/function.mysql-connect.php

"Drowning under a sea of connections using mysql_connect (not pconnect) I found that php connections did NOT go away at the end of a page load. Only by setting the directive mysql.allow_persistent = Off made the connections go away."

Could anybody confirm this? If he is right, then the php manual is dead wrong.

Because I don't use the mysql_connect, but 3rd party system such as the phpBB, dotproject use it. So I cannot turn the mysql.allow_persistent to be Off.

Then I have to call the mysql_close() in the end of every page of my script?

MarkR

Connections opened by mysql_connect SHOULD go away when a page ends. Unless your pages take a long time to render, there should never be an excessive number.

Connecting to mysql is a very quick operation, so I normally recommend that _pconnect is not used.

Have you reproduced this error in your dev environment? Have you built PHP from source?

Can you be more specific as to the nature of the problem? What web server are you using? If it's Apache, which MPM are you using? What is MaxClients set to?

Mark

blackhorse

I am on FreeBSD, I am on a rent server, running dozens sites, and always using mysql_connect. Just request the hosting company increase the connections limits.

I don't have page takes a long time to run. Haven't see the problem for one year. No new big sites added to the server, no sudden increase in traffic.

I had this php connections problem one year ago before, after the hosting company increase memory and increase the connections limits, I hadn't seen this problem for a year.

But recently, I had seen this exceeding the limits connnections problem 2 times, the hosting company is going to update the system, but at the same time, they suggested me to change the connect to pconnect. I think it was wrong that change connect to pconnect, (the hosting company may have the old knowledge like php before 4 which doesn't close itself).

Also, I have seen other problems, such as DNS service problems, or server running out of the air shut down eventually. I think it was not mysql limit connections, it was the server problem. But I just want to investigate the mysql_connect and mysql_close() etc. just to be on better programming practice if I need to be.

bradgrafelman

If you're really hurting for open connections, try adding [man]mysql_close/man's right after you're done grabbing data from SQL.