Regular " Lost connection to MYSQL server during query at... "

Query the MySQL database will often appear "Lost connection to MYSQL server during query at..." this error, one SQL statement is sometimes trigger such mistakes, sometimes normal. How to solve this problem? Because just contact database, feeling unable to locate the source of the problem in WebServer or MysqlServer

Web Server: Ubuntu 12.04 + Apache + mod_perl
MySQL Server: CentOS + mysql 5.0.77

Started by Fabian at February 06, 2016 - 11:39 PM


Posted by Fabian at February 11, 2016 - 12:08 AM

Database connection string set to automatically re training

Posted by Mamie at November 26, 2016 - 5:40 PM

Have a look what prompted the MYSQL database log

Posted by Jerry at November 30, 2016 - 6:29 PM

You mean field which files on MysqlServer.?

Posted by Fabian at December 05, 2016 - 7:21 PM

The error log, slow query log has no information?

Posted by Stephen at December 06, 2016 - 7:50 PM

What feeling is because the MySQL connection timeout is too short.
Have a look the wrong information.

Posted by Nat at December 13, 2016 - 7:55 PM

The MySQL connection is re connected. One day one or two times normal.

Posted by Scott at December 23, 2016 - 8:50 PM

Is often a very short period of time repeatedly request will trigger this wrong, such as I'm a short time two consecutive F5 to refresh the page, lost connection failure occurs, so far haven't found out the specific reasons, we then some advice, thank you

Posted by Fabian at December 29, 2016 - 8:55 PM

The timemout in the client terminal configuration, or a server end?

Posted by Fabian at January 04, 2017 - 9:24 PM

Find out why not, I these two days using the delphi+myDAC components to write a query MySQL database of small programs, as long as it is on the client, will not appear the mistake, seeking the solution of it, to help you.

Posted by Jackson at January 05, 2017 - 9:46 PM

I solved it, I also encountered the same problem.

Posted by Laura at January 07, 2017 - 10:03 PM

Hello, borrow a son of the building lord, ask, I and you meet the same problem, I set the reconnection but still appeared, the same problem.

Lost connection to MYSQL server during query at .

Posted by Laura at January 12, 2017 - 11:03 PM

I have to do is to solve my problems, I see my MySQL timeout is 30 seconds, I put a timer in the program, every 28 seconds to execute a select 1 query, so that the server will not automatically disconnect my connection. The test is normal

Posted by Jackson at January 12, 2017 - 11:06 PM