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


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to