5 messages in com.mysql.lists.perlRe: mysql server dying
FromSent OnAttachments
mayuran15 Apr 2004 13:22 
Garth Webb15 Apr 2004 14:20 
Rudy Lippan15 Apr 2004 18:46 
Rudy Lippan15 Apr 2004 18:48 
Dave Howorth16 Apr 2004 02:28 
Subject:Re: mysql server dying
From:Rudy Lippan (rlip@remotelinux.com)
Date:04/15/2004 06:48:54 PM
List:com.mysql.lists.perl

On Thu, 15 Apr 2004, Garth Webb wrote:

On Thu, 2004-04-15 at 13:22, mayuran wrote:

a while and i eventually had to kill -9 it. what im wondering is, is there some sort of timeout value i can play with? what i would like to do is set a timeout, and if the timeout is reached at any point then DBI should issue some sort of error msg that i can then parse inside the $Dbh->ErrorHandler sub. I know there is a timeout value for connecting to a db but that doesnt help me in this case.

You could set an alarm (from 'perldoc -f alarm'):

I wonder if a SIGALRM would help if it takes a SIGKILL to term the process.

Rudy