----- Original Message ----- From: "Karam Chand" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 10, 2004 1:08 PM Subject: Lost connection during query when using SSH tunneling
> Hello, > > I have a MySQL database hosted with my ISP. They > provide direction as well as thru SSH tunneling. I can > very well connect to it diredctly from any app but I > prefer to use SSH tunneling. > > So I use Putty to create the SSH tunneler and then > connecting to the local port. > > Now the problem, is that whenever I execute a long > query or something that returns big resultset, i get > an error - > > Lost connection during query. > > If I use direct connection - everythings fine. > > Is this a known issue? Is this a bug with Putty? > > Regards, > Karam > I don't have a lot of information for you, mostly just educated guesses. I think you are experiencing a timeout due to the length of the query. It seems reasonable to me that there would be a limit on how long a query could run before it got killed; otherwise, if it was looping, you'd never get break out of the loop. If I was writing the framework in which your query was executing, I'd want a query to timeout automatically if it had been running over a set amount of time. I'd set that value at a reasonable number and give the user some way to change it if the default was too high or too low. Unfortunately, I don't know for certain that this is what's happening but it seems pretty reasonable to me. I use WinSSH to do the same sort of tunnelling you are doing and I have never timed out yet. Then again, I haven't run any really long queries or built any really large result sets either so maybe I've just been lucky. I had a look at the WinSSH software and I don't see any kind of a timeout setting in it. Therefore, I suspect that the timeout is being set at the server itself. Unfortunately, I'm not sure where to start looking. Perhaps if you search on 'SSH' in the manual, you will find that MySQL has a setting that affects timeouts for SSH tunnels; if not, it might be a more global setting somewhere on the server, perhaps in Apache. Sorry I couldn't be more help. Rhino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
