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


"Xho Jingleheimerschmidt" <xhoster@xxxxxxxxx> wrote in message
news:49bf08ca$0$9725$ed362ca5@xxxxxxxxxxxxxxxxxxxxxxxxx
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.

Are you sure? If there were an error message, do you know where it would
go and do you know you could find it?


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?

I don't think there is one in DBD::mysql. The program that calls your
perl script could have a time out, or your MySQL server might have a time
out, but neither of those are Perl issues


Or am I running out of memory. Can the memory be increased?

Unlike a select, there is no reason that large update should consume much
memory in the Perl client. And I don't use Debian specifically, but on
other linux systems running out of memory does produce an error somewhere,
but not always in the first place one might think to look.

Xho

Yes I have now found that error log. There is a special log for slow
queries. So evidently MySQL are aware that some constructs do take a long
time.
I am not certain whether it is a Perl problem. My feeling now it is a MySQL
problem and that they are aware of similar problems.

Regards
John




.

Relevant Pages

  • Re: Need help with Perl and MySQL database data load
    ... You are telling Perl that you're creating a package named ... > 'MySQL' with this line. ... I get the error message "Can't locate object method "connect" ... When I put that line, use DBI;, back in I then get an authentication ...
    (comp.lang.perl.misc)
  • Re: Suddenly ODBC driver does not work
    ... > Suddenly the users and I get an error message when trying to open the ... > The page stops and shows "ODBC Drivers error '80040e21' ... I just noticed that you are using MySQL. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • 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: Perl-mysql
    ... sharing the error message you get when trying to connect will ... networking for mysql may not be active ... On 8/30/06, Manne, Siva Chaitanya Prasad ... machine from my Windows machine. ...
    (perl.beginners)
  • Re: connection with MySQL with Python interface
    ... > When I tried to connect with MySQL database which run on XP from shell. ... Has anyone get similar error message and provide any suggestion? ... You have to know that a client needs to have a mysql-client ...
    (comp.lang.python)