Keep Alive / Auto Reconnect

[expired user #9662]'s profile image [expired user #9662] posted 8 years ago in General Permalink

I've been using HeidiSQL for about a year now to hack/manage my website's DB. There is one issue that arises every time I use the program -- it's finally pushed me to the point that I am commenting on it :)

My webhost auto-disconnects mySQL connections at about 18-19 seconds of inactivity. In HeidiSQL, this disconnect causes all data editing/browsing to grey-out and become unclickable / scrollable until I reconnect to the DB. If I'm typing an entry or browsing the records, I get disconnected and need to reconnect to manually continue.

I read in a forum post that HeidiSQL's auto keep-alive pings at a hard-coded rate of every 20 seconds. Would it be possible to change this to user-configurable rather than hard-coded, or at lease give some options regarding keep-alive timing (15s / 20s / 25s / 30s)? The forum post was 3 years old, so maybe this has already been implemented and I didn't see the setting in HeidiSQL.

Alternately, would it be possible to either 1) allow the user to continue to scroll through the data records when disconnected, rather than disabling the scroll bars, and/or; 2) auto-reconnect when the user finishes editing a record if they have been disconnected?

Thanks for a great product (and for choosing a great name for the product -- my much-loved wife is named Heidi, and I think of her every time I run the application :) ).

Code modification/commit from ansgarbecker, 8 years ago, revision 9.3.0.5052
Make keep-alive-interval customizable in "Advanced" tab on session manager. See http://www.heidisql.com/forum.php?t=20829
ansgar's profile image ansgar posted 8 years ago Permalink

Agree. r5052 has a new setting for that, in the session manager on the "Advanced" tab. By default all sessions have a 20 seconds interval. 0 means no keep-alive-ping. Maximum is 86400 seconds (= 1 day).

[expired user #9662]'s profile image [expired user #9662] posted 8 years ago Permalink

@Ansgar, thank you so much! Set at 18 seconds, my connection now stays live. A small donation is on it's way (as much as I can send without having to get boss approval :) ).

ansgar's profile image ansgar posted 8 years ago Permalink

Hehe, thanks a lot. :)

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