I have an ongoing problem with Toad for MySql where if I leave it running, but don't use it for a period of time, when I come back to it it's basically hung. I can't do anything in the software, and I can't quit and I have to terminate the process. This happens several times a day.Running on Windows 7 x64. Anybody know what's going on and how to fix this/
I have a version of this and have discovered that there is an invisible Toad for MySQL popup waiting for a response. Use alt-tab to cycle through running programs and if this is your problem you'll see one program that has just the outline of the popup.I usually can go to that using alt-tab and it then shows up and I can respond and my machine is freed. It doesn't always work try different ways of selecting the same popup.
The issue with dialogs showing and then making the product not show up in the tab list should have been fixed for the 6.0 beta I think.
Same here. I experience the same issue on any version for a year many time a day, even if I don't leave it idle.Most of the time is related to an warming message Active queries are already running on this connection. Which is not true. The query that I ran on that tab finished and it has been idlefor a while.I use between 5 and 10 tabs at the time, with open connections to the same server.Running it o a 8 cores with 8GB of RAM laptop connecting to mysql 5.5 over VPN.Love it and don't want to drop it in favor of something else.Best,Nic
Message was edited by: nic chidu
I have autocommit on (the default setting). But this has no effect on any of the MySQL engines, does it?INNODB commits all implicit trasactions automatcally.I always wondered about this feature of TOAD for MySQL.Thanks,Nic
Mauritz,This is great to know. But just to make sure, in this scenarioINNODB tableAutocommit offif I run UPDATE Customer SET Name = 'NewCustomerName' WHERE Name = 'CustomerName'isn't this automatically committed by INNODB? Do I have to issue a commit?Thanks,Nic
Mauritz, Is this specific to TOAD? Is it wrapping the UPDATE statement in a transaction behind the scenes? AFAIK INNODB will automatically commmit (or rollback if necessary) an UPDATE statement.Thanks,Nic