Random Error

2006-08-16 Thread Mike Blezien
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

Re: Random Error

2006-08-16 Thread Dan Buettner
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,

Re: Random Error

2006-08-16 Thread Mike Blezien
: 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

Re: Random Error

2006-08-16 Thread Dan Buettner
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)

Re: Random Error

2006-08-16 Thread Dan Buettner
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