distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL keeps locking up after inactivity

User, date Message
Written by ptmclellan
3 months ago
Category: General
7 posts since Fri, 13 Jun 14
Hello! New user here...

Have used HeidiSQL for probably 6-8 years. Use it religiously all day long to connect to our web server. We are on the same VPN tunnel as our hosting provider, where our MySQL server is hosted.

While HeidiSQL runs great, if I leave it inactive for too long, it completely locks up on me when I come back to it. Regardless of what screen I left it on, it will freeze up for about 10 seconds, throw a random error and then release itself.

If I am working continuously in Heidi, it never freezes/disconnects. But, if left idle for, say, 5-10 minutes, it crashes.

Any thoughts?
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
FYI - the same issue happens with other MySQL front-end programs (MySQL-Front, for example), so I do not believe it is ISOLATED *to* Heidi, but perhaps there is a workaround/fix
Written by ansgar
3 months ago
4973 posts since Fri, 07 Apr 06
I guess you are waiting for the results of SHOW TABLE STATUS. Please go and disable the session setting "Get full table status" in the session manager's "Advanced tab". You will get less details in the "Database" tab, but at least we can see if that's the cause of your waiting.
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
But this issue happens no matter which section is open in Heidi. I may have a query window open, and I go back to execute it after sitting idle. Even the execution of the query locks up the program.

I think the issue may be a persistency problem with our Comcast connection. Therefore, is there any way to create a "scheduled task" that runs a quick query statement every 5-10 mins?
Written by ansgar
3 months ago
4973 posts since Fri, 07 Apr 06
Heidi already sends a ping each 20 seconds.

Please try my suggested thingy.
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
Sure thing - I'll give it a shot
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
Just let it sit for a good 30 minutes. Went back and refreshed my query and it came up right away! Will continue to test it...
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
gave it another 30 minutes and it didn't lockup. Fingers crossed, this is a solution. THANK YOU!
Written by ansgar
3 months ago
4973 posts since Fri, 07 Apr 06
Yeah, if that's it, it is just the server taking some time to collect file attributes of table files, index files, internal data etc. SHOW TABLE STATUS was complained about *many* times before by other users, until I finally added that session option to allow the user to use a very quick and lightweight alternative query.
Written by ptmclellan
3 months ago
7 posts since Fri, 13 Jun 14
Well, my sanity thanks you! Much appreciated!
 

Please login to leave a reply, or register at first.