Frequent Disconnects

[commsys]

I recently upgraded and am now using 4.0 Enterprise.

I develop / debug code located on remote server, which also hosts the MySQL db's. I like to launch SQLyog and leave it connected while I am editing / updating / testing the HTML / PHP code, that way I can alter db on the fly if needed or use SQLyog to create a rough draft of INSERT statements etc.

The problem is that if I do not use or refresh SQLyog every few minutes, it drops the connection to MySQL. Even though no error message appears, if I try to “refresh” data already displayed or select another table (or whatever), SQLyog more or less locks up for a couple of minutes, shows “not responding,” and eventually displays an error message that the connection was lost. I can then (and only then) do File | Disconnect All, then File | Connect. Then the first re-connect attempt usually fails, but the second re-connect attempt always succeeds.

I have tried to find a “keep alive” or “auto regresh” setting, but cannot locate anything.

I do not recall having this problem with prior version.

Any suggestions would be most welcome. Thanks.

/s/ John Parken

[Ritesh]

Are you using direct connection or HTTP/SSH Tunneling?

[commsys]

Direct connection. It's a virtual server with multiple databases. Server runs Apache with PHP, MySQL, etc., on FreeBSD. It's also with a good hosting company and we have pretty much unfettered root access.

Seems that connection with SQLyog client on my PC “times out” in 5 minutes or so on no activity. There is no on-screen indication (that I can find) that the connection has dropped; however, if I change to a different table or do a refresh or anything, there is a long hourglass pause (the client here is running on WinXP), so I try really hard to remember and do a file | Disconnect, then File | Connect and that is MUCH, MUCH faster than forgetting, finding the connection has dropped etc.

It's really frustrating for me and I find that I am using SQLyog less for those ever-so-convenient quick checks of data, or field configuration, or testing a query I'm about to use in PHP code or whatever.

/s/ John

[peterlaursen]

I think you should try connecting with “Mysql Administrator” from http://www.mysql.com .

If the problem is the same here it must have something to do with the server settings or network settings for remote connections. (php tools like phpMyAdmin runs “locally” on the server.

[Author]

Posts