[Phplib-users] mysql_pconnect & db_mysql.inc

[Mike G. <mi...@op...>]

Hello phplib folks,

I've heard that mysql_pconnect has some problems, especially if it isn't
installed as an apache module.  

I did a search for problems with mysql_pconnect and didn't fid a lot.
Mostly this (which is pretty vague): 
http://www.dotxtra.net/support/php.htm

There is a report here with problems with PHP 4.1.1, but I haven't heard
anything about any other versions.
http://www.php.net/manual/en/function.mysql-pconnect.php

From what I could see from php.net the official version is to tweek
apache & MySQL:

We were running into an issue of too many open connections.

	Warning: Host 'db.ourserver.org' is blocked because of many
	connection errors. Unblock with 'mysqladmin flush-hosts' in
	/home/mike/phplib/db_mysql.inc on line 75

This one here actually..

From what I've read persistent connections should reduce the number of
db connections, unless they are set to persist a bit too long in which
case it has the opposite effect.  

I see from here (think this is the right one):
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/phplib/php-lib-stable/php/db_mysql.inc?rev=1.11&content-type=text/vnd.viewcvs-markup

that you haven't switched to (on line 72):
$this->halt("connect($Host, $User, \$Password) failed.");

If you have to change the wait_timeout, what would be considered a low
(buit reasonable) value?

Any additional insights on this would be appreciated..  

Mike
-- 
Mike Gifford,low wait_timeout OpenConcept Consulting,
http://www.openconcept.ca
Open Source Web Applications for Social Change.
Featured Clients - http://kenora.clc-ctc.ca | http://kingston.clc-ctc.ca
We are drowning in information, but starved for knowledge. - John 
Naisbilt