Lost connection to Mysql Server.
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 program.pl 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?
Subject
Written By
Posted
Lost connection to Mysql Server.
October 22, 2008 01:13PM
November 05, 2008 02:38AM
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.