MySQL Forums
Forum List  »  Perl

Re: DBD::mysql::st execute failed: Lost connection to MySQL server during query
Posted by: Rick James
Date: September 27, 2011 08:50PM

(Ignore the spammer)

> Something else to note, as you asked about autocommit before. This has occured with statements run outside of any transaction (autocommit will be creating a transaction around the single statement) as well as on transactions executed between a 'START TRANSACTION' and 'COMMIT', so there was already a transaction session in place.

Are you sure it is timing out _during_ a query, not _between_ transactions.

Do any queries take more than a few seconds?

Add some timers in your code. Let's find out how long before it times out.

Options: ReplyQuote

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.