Auto-reconnect on lost connection
Now if i try to execute query if connection was lost (because of timeout, for example) annoying popup "Lost connection to MySQL server during query" appears. I need to close it and restart query.
Very annoying on servers with small timeout.
Suggestion: make at least one connection retry, before show this popup. Maybe make behaviour configurable.
Fox
shared this idea
Actually, this feature is already implemented. If you have the latest version of the product and it still doesn’t work, please contact technical support for help.
-
AdminDevart
(_, Devart)
commented
You can select the 'Keep connection alive' option on the 'Advanced' tab of the 'Database Connection Properties' dialog box that can be invoked by right-clicking the connection in Database Explorer and selecting 'Modify Connection...' from the popup menu.
Note, zero means to wait infinitively.
-
Raju Mourya
commented
I am using version 7.1.13 and still have to reconnect it manually before running the query
-
Dima
commented
Actually it does not work well as it should. Here are steps:
1. Connect to DB
2. Wait few minutes
3. Try to execute any query: it will take about 30 sec to say that connection is lost
4. You need to execute a query again (extra mouse click) to reconnectI would expect: keep connection opened all the time with keep alive OR monitor disconnect and auto reconnect OR just drop connection and reconnect every few min (for dormant connections)