From: Date: October 15 2003 3:04am
Subject: Re: Connection Time Out
List-Archive: http://lists.mysql.com/mysql/151640
Message-Id: <3F8C9D2F.2090108@patmedia.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Dathan Vance Pattishall wrote:

>Look at your wait_timeout and interactive_timeout settings. They may be
>set to a low value. If your connection sleeps for > these 2 vars mysql
>will disconnect you.
>
>
>- Dathan Vance Pattishall
>  
>

>-->Subject: Connection Time Out
>-->
>-->
>-->Splain this to me: I use my laptop to connect to the test-bed MySQL
>-->server residing on my desktop. Using this connection, I can do
>-->anything: load 200K lines, do complex (for me) queries, whatever.
>-->But,
>-->open a MySQL console connection _on the desktop_ where the MySQL
>-->server lives, I can't do a desc table without getting the "Lost
>-->connection to MySQL server during query" message.
>
>  
>
Don't think this is the issue. Both variables are at default values of 
28800 -- or 8 hours. Besides, wouldn't they have the same effect on my 
laptop access as on the desktop? Again, using the console on the box 
hosting MySQL, I get frequent server gone away errors. At the same time, 
using the console on my laptop but accessing the very same MySQL server 
over the network, I have no such problems. That seems precisely 
bass-ackwards to me! ;-)

Randy