Bug #17238 Updated: Mysql Connection Timeout
ID: 17238
Updated by: georg@php.net
Reported By: paul79@optonline.net
Status: Open
Bug Type: Feature/Change Request
Operating System: FreeBSd 4.5
PHP Version: 4.2.0
-Assigned To:
+Assigned To: georg
New Comment:
Yep, that's right. Currently php doesn't support the
connect_timeout option. I'll implement this.
Georg
Previous Comments:
------------------------------------------------------------------------
[2002-05-15 03:21:18] paul79@optonline.net
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 this bug report at http://bugs.php.net/?id=17238&edit=1
Thread (3 messages)