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
