Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.

From: "John" <john1949@xxxxxxxxx>
Date: Mon, 16 Mar 2009 14:00:44 -0000

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?

Regards
John

.

Follow-Ups:
- Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
  - From: Xho Jingleheimerschmidt
- Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
  - From: J. Gleixner

Prev by Date: Re: help using SQLite3 in-memory databases (through DBI)
Next by Date: Re: Most efficient way to do set-comparison
Previous by thread: FAQ 1.12 What's the difference between "perl" and "Perl"?
Next by thread: Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
Index(es):
- Date
- Thread

Relevant Pages

Mysql Error 1135
... I am getting following error message while accessing mysql. ... available memory, you can consult the manual for a possible OS-dependent bug ...
(freebsd-questions)
Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
... I'm updating a MySQL table with about 2 million records. ... After about 100 seconds the program ends with no error message. ... perl script could have a time out, or your MySQL server might have a time out, but neither of those are Perl issues ... there is no reason that large update should consume much memory in the Perl client. ...
(comp.lang.perl.misc)
Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
... I'm updating a MySQL table with about 2 million records. ... seconds the program ends with no error message. ... Or am I running out of memory. ...
(comp.lang.perl.misc)
Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
... I'm updating a MySQL table with about 2 million records. ... seconds the program ends with no error message. ... Or am I running out of memory. ...
(comp.lang.perl.misc)
Re: Debian MySQL Perl DBI - connection terminates unexpectedly after 100 secs.
... I'm updating a MySQL table with about 2 million records. ... After about 100 seconds the program ends with no error message. ... Or am I running out of memory. ...
(comp.lang.perl.misc)