mysql server dying

Here is the scenario:

2 machines, machine 1 is running a script
and machine is the db server.

the script is doing massive inserts/updates (in a
transaction) into the db when all of a sudden the
db server dies (it shut off somehow). the db being
powered off caused the script to hang. it hung for
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.

Thanks

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org