Hello,
occassionally we come accross this error:
2013 - Lost connection to MySQL server during query
not all the time, but now and then, no real pattern that we can see of find in
the logs. but appear to happen mainly with SELECT's
is there a way to fix this or trace it down to a cause?
TIA
Mike, can you provide more details? OS platform, networking overview,
types of apps experiencing this error (PHP app, mysql cli, etc), does
it happen with local as well as network connections, etc.
This will help us help you.
Dan
On 8/16/06, Mike Blezien [EMAIL PROTECTED] wrote:
Hello,
: Wednesday, August 16, 2006 3:24 PM
Subject: Re: Random Error
Mike, can you provide more details? OS platform, networking overview,
types of apps experiencing this error (PHP app, mysql cli, etc), does
it happen with local as well as network connections, etc.
This will help us help you.
Dan
At first blush, I'd look into a few different possibilities -
- An idle connection timeout is being enforced on a persistent connection pool
- Too many individual connections are overwhelming a Windows server
(see
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server-on-windows.html)
A little more searching also uncovered this, which appears to be right
up your alley:
http://dev.mysql.com/doc/refman/4.1/en/gone-away.html
On 8/16/06, Dan Buettner [EMAIL PROTECTED] wrote:
At first blush, I'd look into a few different possibilities -
- An idle connection timeout is being