Re: mysql_connect_timeout problem when using times less than 1 sec

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:alexander@xxxxxxxx http://www.foken.de/alexander/

.

Relevant Pages

  • Re: timeout for send?
    ... In looking at the tk source code, looks like send will timeout if target ... application dies. ...
    (comp.lang.tcl)
  • Re: Timeout problem
    ... On Tuesday 06 July 2004 10:58, Werner Otto wrote: ... > incorrect it timesout after 1 second. ... > switched off it does not timeout after 1 second. ... is doing what you want (e.g. handling the timeout on connect vs. handling the ...
    (perl.beginners)