Re: mysql_connect_timeout problem when using times less than 1 sec

I have looked at the code for DBD::mysql and DBI.pm but cannot workout where
the timeout is implemented or where the default is specified. Does anyone
know where this logic is implemented? I would rather make make the change in
the module that currently implements the time out code than add some logic
to add timeout in my application code.

Duncan

On 24/09/06, Alexander Foken <alexander@xxxxxxxx> wrote:

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: [Microsoft][ODBC SQL Server Driver] Timeout expired
    ... If you are not specifying the correct parameter, ... > to timeout on that type. ... > Anthony Thomas ... > Enterprise Manager Properties Advanced window, I have set Query timeout to ...
    (microsoft.public.sqlserver.server)
  • Re: timing input!
    ... to enter something just a few second and if user didnt enter anything ... specifying a timeout. ... errordlg(), warndlg, questdlgdialog, uigetprefall create new ...
    (comp.soft-sys.matlab)
  • Re: mysql_connect_timeout problem when using times less than 1 sec
    ... http://search.cpan.org/src/CAPTTOFU/DBD-mysql-3.0007/dbdimp.c line 1309 and following, the value is converted to an int, then passed to mysql_options, which is a part of the mysql API. ... there IS NO WAY to specify a timeout of less than one second. ... It seems that you have to live with a minimum timeout of one second, as alarmalso has only seconds resolution. ... > The DBI module when connecting to a mysql database seams to only support ...
    (perl.dbi.users)
  • Re: mysql_connect_timeout problem when using times less than 1 sec
    ... x 1sec timeout is acceptable but 10 x 1 sec timeout is not. ... custom signal handler, which is really, really ugly. ... On 24.09.2006 12:23, Duncan Wren wrote: ... >>> The DBI module when connecting to a mysql database seams to only ...
    (perl.dbi.users)
  • Re: mysql_connect_timeout problem when using times less than 1 sec
    ... Abort if the first connection in the page times out after 1 or 2 seconds and assume the server is down instead of trying to connect again: ... Maximum timeout is one second, ... >>> The DBI module when connecting to a mysql database seams to only ...
    (perl.dbi.users)