Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- From: "John" <john1949@xxxxxxxxx>
- Date: Mon, 16 Mar 2009 16:55:29 -0000
"J. Gleixner" <glex_no-spam@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:49be71fd$0$89873$815e3792@xxxxxxxxxxxxxxxxx
John wrote:
Hi
I'm updating a MySQL table with about 2 million records. After about 100
seconds the program ends with no error message. If I use LIMIT
800000,50000 the part where it stopped is OK so the UPDATE part is OK.
Is there a time out parameter? Or am I running out of memory. Can the
memory be increased?
Check line 24.
Line 24 says:-
our $old_fh=select(STDOUT); $|=1; select($old_fh); # Make standard output
socket hot
Can't see how that can affect it.
Regards
John
.
- Follow-Ups:
- Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- From: Tad J McClellan
- Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- From: Jens Thoms Toerring
- Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- References:
- Prev by Date: Re: Most efficient way to do set-comparison
- Next by Date: Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- Previous by thread: Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- Next by thread: Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
- Index(es):
Relevant Pages
|