[PHP] Persistant Connections and max_connections on mysql

[Dan Rossi]

Hi there, I have run into issues on a public production server where I 
keep running into max connection issues on mysql if I am using 
peristant connections. Sometimes the machine gets high traffic and I 
was wondering if there are good reasons to leave them on or off. After 
turning them off its been ok for one of the sites/projects. The mysql 
setting was originally 100 I got the bumped up to 500 but still the 
same issue ?


Let me know.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Persistant Connections

[John Wards]

I am running a website which generates around 100,000 pageviews a day and I
am wondering if I stop using persistent conections to the database and use
normal open and close conections this would reduce the load onto my server?

Most conections are either made through my main file or the phorum message
board system.

Thanks in advance
John Wards



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Persistant Connections

[Nick Oostveen]

Persistent connections are typically a good thing to use on high traffic 
sites as they offer better performance than opening and closing connections 
for each database request. The reason for this is the overhead used in 
opening a database connection is actually quite high.

While keeping them open when they are no longer needed may seem 
counter-intuitive, the connection isn't being saved for a particular user 
or page, instead it remains open and will automatically be used by any page 
requiring database connectivity on your site.  If there are no free 
connections when a page request comes in, a new one is open.  Conversely if 
a connection has not been utilized for a specific period of time (usually a 
couple minutes) it will be closed.

At 02:46 PM 8/14/2002 +0100, John Wards wrote:
I am running a website which generates around 100,000 pageviews a day and I
am wondering if I stop using persistent conections to the database and use
normal open and close conections this would reduce the load onto my server?

Most conections are either made through my main file or the phorum message
board system.

Thanks in advance
John Wards



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php