469,919 Members | 2,166 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,919 developers. It's quick & easy.

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

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.
Oct 22 '08 #1
1 5073
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?
Oct 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Randell D. | last post: by
reply views Thread by Yun Guan | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.