By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,693 Members | 1,936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,693 IT Pros & Developers. It's quick & easy.

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

P: 14
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
Share this Question
Share on Google+
1 Reply


P: 14
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.