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

Keep Alive / Auto Reconnect

James@StThereseInstitute posted 1 year ago in General

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 :) ).

ansgar posted 1 year ago

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).

James@StThereseInstitute posted 1 year ago

@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 posted 1 year ago

Hehe, thanks a lot. :)

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