RE: Connection Time Out

[Dathan Vance Pattishall]

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
  - Sr. Programmer and mySQL DBA for FriendFinder Inc.
  - http://friendfinder.com/go/p40688


-->-----Original Message-----
-->From: Randy Chrismon [mailto:rchrismon@stripped]
-->Sent: Tuesday, October 14, 2003 10:55 AM
-->To: mysql@stripped
-->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.
-->I've looked in the documentation and none of the possibilities there
-->seem to apply. It seems especially strange since the remote
-->connection
-->from my laptop has none of these problems.
-->Any ideas will be appreciated.
-->Randy
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/mysql?unsub=1