Without looking at the source code of DBD::mysql, I would quess that the
mysql_connect_timeout parameter is an integer. 0.5 is rounded down to 0,
which is the same as not specifying mysql_connect_timeout at all. If you
are on a Unix/POSIX System, alarm() and Signals may help.
Alexander
On 23.09.2006 18:02, Duncan Wren wrote:
The DBI module when connecting to a mysql database seams to only support
integer values for the mysql_connect_timeout if you use say 0.5 secs
as the
timeout value it defaults to 3secs. Does anyone know a way round this
problem as i need a very short timeout in my application.
for example
#does not work and defaults to 3 secs timeout
$dbh =
DBI->connect("DBI:mysql:db_name:db_host:3306;mysql_connect_timeout=
0.5","username","password");
#does work and timesout after 1 sec
$dbh =
DBI->connect("DBI:mysql:db_name:db_host:3306;mysql_connect_timeout=1","username","password");
Thanks
Duncan
--
Alexander Foken
mailto:[EMAIL PROTECTED] http://www.foken.de/alexander/