DBD::mysql::st execute failed: Lost connection to MySQL server during query

[theschaef]

Hi there.
I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data.

If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message:
DBD::mysql::st execute failed: Lost connection to MySQL server during query

I have tried searching for the solution to this problem and haven't found anything that helps yet. I have changed the values of 'max_allowed_packet' and 'wait_timeout', with no effect.

Any ideas?
Thanks in advance for any help.

[theschaef]

anyone? Im guessing it is probably something to do with my my.cnf file but im not sure.

mysql > SHOW VARIABLES; gives me..
wait_timeout = 28800
max_allowed_packet = 524288000

do these seem sufficient for what i need? are there any other variables that could be causing the error?