Regarding mysql_pconnect()

[hsriat]

For your database connection issue, what you can do is instead of connect() use pconnect()

p = persistent.

This way php/mysql do no create more connections, if the connection parameters are the same, it looks for a current one and uses it.

Got an issue regarding this...

As said above (same as what php.net says), if we use mysql_pconnect(), it doesn't create more connections, if the connection parameters are same as the existing pconnection's.

But if the already set pconnection is too busy serving others, would the next request of pconnect create another connection then or would still wait for the first query to complete before serving it?

This will actually end up utilizing only one connection.

[dlite922]

From what I understand your problem is, some solutions are provided here:

http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

I still don't know how you have so many connections.

With pconnect() it is done once per user session (per request), Do you have thousands of users pinging the DB at the same time?

If so, you might need to go enterprise level, increase harware and setup i guess. Increase number of ports/default connections between PHP and MySQL (Google it as i've never done this)

Hope that helps buddy,


Dan

[hsriat]

From what I understand your problem is, some solutions are provided here:

http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/

I still don't know how you have so many connections.

With pconnect() it is done once per user session (per request), Do you have thousands of users pinging the DB at the same time?

If so, you might need to go enterprise level, increase harware and setup i guess. Increase number of ports/default connections between PHP and MySQL (Google it as i've never done this)

Hope that helps buddy,


Dan

Yes, I have average 100 users pinging at time. At time, it might be no one. Its an online entrance test site. So it depends upon at what time the test is.

Using mysql_connect, "Error: Too many connections" occurs like 1'ce in every 10 tries while testing in a lab of more then 100 clients. While there are 50 allowed connections by the server host.

Using mysql_pconnect, it sounds like only one connection will be used. But I need to utilize all the 50 allowed connections, else it would slow down the speed.

Will read out the stuff at the link provided. Then will think something.

Thanks for the response.

Regards,
Harpreet

[dlite922]

Yes, I have average 100 users pinging at time. At time, it might be no one. Its an online entrance test site. So it depends upon at what time the test is.

Using mysql_connect, "Error: Too many connections" occurs like 1'ce in every 10 tries while testing in a lab of more then 100 clients. While there are 50 allowed connections by the server host.

Using mysql_pconnect, it sounds like only one connection will be used. But I need to utilize all the 50 allowed connections, else it would slow down the speed.

Will read out the stuff at the link provided. Then will think something.

Thanks for the response. :)

Regards,
Harpreet

Sounds good, but still 100 users is not nearly enough for MySQL to trip about it. I'm not sure what's causing this error.

And to be honest, I've never run into this issue before so I'm kind of guiding you blind.

I'm interested in the solution though,


Dan

[hsriat]

Sounds good, but still 100 users is not nearly enough for MySQL to trip about it. I'm not sure what's causing this error.

And to be honest, I've never run into this issue before so I'm kind of guiding you blind.

I'm interested in the solution though,


Dan

Content there was good, but got no idea what to do. Their (guys in that blog) arguments rather made me more confused about the matter.

I have two options now.

• Review code and make sure connection is only made when required and closed as soon as there's no more use.
• In my database.php file, replace mysql_connect with mysql_pconnect, and replace mysql_close with return.

Will try the second one first, do that 100 client testing, for which they charge me

, see the results, and then do changes accordingly.

oh btw... nice hat and goggles.

cheers...