develooper Front page | perl.dbi.users | Postings from March 2005

Re: hang with mysql in execute

Thread Previous | Thread Next
From:
Peter J. Holzer
Date:
March 24, 2005 00:54
Subject:
Re: hang with mysql in execute
Message ID:
20050323172452.GM13807@wsr.ac.at
On 2005-03-23 07:26:35 -0600, Jones Robert Civ TTMS Keesler wrote:
>      If this is due to a timeout issue then you want to increase the timeout
> settings on your system.  That would be something you will need to configure
> on the client side in the OS settings.  

No, he would have to configure that on the firewall:

> > > A firewall is terminating my connection with a mysql
      ^^^^^^^^^^
> > > database after a period of inactivity.

The firewall is probably not under his control, though (Even if it is,
it may not be feasible to increase the timeout to a large enough value).

The best solution is probably to use some keepalive mechanism. TCP
keepalive would be the simplest, but there is no obvious way to enable
it on either the client or the server side, so he has to change his
application to issue a dummy query every $n minutes. 

	hp

-- 
   _  | Peter J. Holzer \Beta means "we're down to fixing misspelled comments in
|_|_) | Sysadmin WSR     \the source, and you might run into a memory leak if 
| |   | hjp@wsr.ac.at     \you enable embedded haskell as a loadable module and
__/   | http://www.hjp.at/ \write your plugins upside-down in lisp". --ae@op5.se

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About