MySQL Forums
Forum List  »  Perl

Lost connection to Mysql Server.
Posted by: David Schaefer
Date: October 22, 2008 01:13PM

Hi there.
Im working on a perl program that takes the rows off of one of my tables to manipulate the data.

The problem is that if i take a table that is too large i get the:
DBD::mysql::st execute failed: Lost connection to MySQL server during query at line 41

If I use a smaller table (in this case ~85,000 records, 8.2MB) I can connect to the database and then pull up all of the rows of the table.. it works just fine. But using a larger table (~265,000 records, 28.3MB) I get the error.

I have tried changing the values of max_allowed_packet and wait_timeout in /etc/my.cnf... but it makes no difference with the problem.

Any ideas?

Options: ReplyQuote

Written By
Lost connection to Mysql Server.
October 22, 2008 01:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.