From: [EMAIL PROTECTED]
Operating system: FreeBSd 4.5
PHP version: 4.2.0
PHP Bug Type: Feature/Change Request
Bug description: Mysql Connection Timeout
Hey,
First off, nice work on php. I must say it's a piece of art. Well, I
was wondering...
I'm trying to build an application that could required mutiple databases.
Obviously, we start off with one database. As the company gets bigger,
and the need for faster access time grows, I was like to split the
database records onto mutiple database. It's kinda like a dynamic
database system. The only problem was, is that when a database is down,
and I make a call to mysql_connect(), it hangs, and of coarse, the script
timeouts. I know you can set the timeout limit on the script, but I was
wondering if it would be featureful enough to add a timeout limit to the
mysql_connect() call. That way, we can avoid doing a fsockopen() to see
if the connection will be ok, before the mysql_connect() call, or even
just simply waiting for the mysql_connect() call to return. With 30 mysql
databases to connect to, this is very time consuming, if they were all
down. (If they were all down, at a time, I would be out of a job. -- ;)).
Just a suggestion, in which I think could be very beneficial. Please let
me know what you think.
--
Edit bug report at http://bugs.php.net/?id=17238&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=17238&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=17238&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=17238&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=17238&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=17238&r=support
Expected behavior: http://bugs.php.net/fix.php?id=17238&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=17238&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=17238&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=17238&r=globals
