Description:
I use MySQL Workbench 6.09 on a Mac to connect to a remote db via SSH tunneling from home.
I noticed all my SSH connections would die after a short period. i googled around and found that i can avoid the issue by adding
Host *
TCPKeepAlive yes
to
~/.ssh/config
this fixed all my SSH terminal connections - they would pretty much stay up.
However, my db connections via SSH tunneling in MySQLWorkbench will still die after a very short idle period.
Is there a way to avoid this? It has been such an annoyance, i've started using Sequel Pro instead, which doesn't have this issue. However, I would like to go back to MySQL Workbench if there was a a way to resolve my problem.
For example:
I could be connected to the remote database via SSH fine using MSQLWB. Then, if I need to look up something via google for a particular SQL command, or if I get interrupted with a phone call, or need to leave the app for whatever reason - I notice that the connection has died if I try to go back in even if the distraction was just a few minutes. I have no problem with having to reconnect - but the problem is that when I revisit the query page (tapping on it), the MySQL WorkBench busy icon kicks in, and stays like that for at least 30 seconds or more - and sometimes it never comes back. During this time, the interface is pretty much frozen. I would have to kill the process and reenter that way.
(my original post of this topic is here: http://forums.mysql.com/read.php?152,610468,610468#msg-610468)
How to repeat:
See description
