Connection goes stale

[androidtech]

This only happens when executing a hand-typed SQL query in the query window pane. It never happens when I click on a database->table in the browser pane, and then hit enter to show the table's data.

If I leave SQLYog for a while with a query sitting in the SQL query pane, and then hit F5, the connection will time out after a lengthy period and report a lost connection error. After that F5 works again just fine. Because of this I have gotten into the habit of copying the SQL query, disconnecting the SQL connection, connecting again, and pasting in the copied query. The time period before the connection goes stale isn't very long, a few minutes perhaps.

Is there a fix planned for this? Perhaps an automatic reconnect after X seconds, without trying the current and possibly timed-out session connection? Or perhaps an option to force a reconnect every X seconds or with every SQL query?

BTW, the first time I tried to submit this post I got an error complaining about “out of disk space”. The second time I submitted it worked.

Thanks.

[Ritesh]

You can probably increase the wait_timeout value for the server. More information on Server System Variables can be found at http://dev.mysql.com/doc/mysql/en/Server_s…_variables.html.

Later version's of SQLyog will have an option where it will ping the MySQL server at regular intervals so that the connection is not timed out.

[Author]

Posts