Keep Alive / Timeout Issue

[Blue Ink Software]

Currently I am using Enterprise version 5.13. If I leave the program idle for over 5 minutes, it hangs whenever I hit refresh or try to run a query. After 30 – 45 seconds the program finally unfreezes and runs the query. I have changed as many MySQL connection settings on my remote Linux server as I can think of. Is there a “keep alive” option in the tool to send ping requests to the open database connection?

I have seen posts in the past talking about this issue that mentioned this feature was coming. Is it availabe in the version I am using? If so, how do I access it?

Thanks,

John

[peterlaursen]

There is no such option.

[Blue Ink Software]

peterlaursen wrote on Sep 28 2006, 03:43 AM:

There is no such option.

Does anyone have a suggestion on how to fix this problem. It is getting so annoying that I am planning to go back to my online MySql admin tool.

Here are a couple links I found on the forum from last year with the same problem.

http://www.webyog.com/forums/index.php?showtopic=1135

http://www.webyog.com/forums/index.php?showtopic=1408

Thanks,

John

[peterlaursen]

I am sorry for the short reply in the first place.

We were not good at the time to 'keep track' of issues.

It is better now!

Implementation idea:

At intervals send a 'dummy query' like

Code:

SHOW VARIABLES LIKE 'keep me alive';

that will of course return NULL 😀

The tricky part of it is the TIMER functionality. I think there will have to be a seperate thread running for each open connection. These threads should SLEEP most of the time, but WAKE UP – say – every 2 minutes, check HISTORY if anything was sent since since last wake-up. If there was not then send the dummy statement.

I also think that this should be optional/configurable (I have no such issue and do not need the feature). I do not know of other database clients doing things like this. There is no FTP-like 'NOOP' command available in SQL. No 'ping' either (you can ping the host, but not MySQL). However I think that PHP has a mysql_ping() function. Anybody knows what it actually does?

[Blue Ink Software]

peterlaursen wrote on Sep 28 2006, 08:02 PM:

I am sorry for the short reply in the first place.

We were not good at the time to 'keep track' of issues.

It is better now!

Implementation idea:

At intervals send a 'dummy query' like

Code:

SHOW VARIABLES LIKE 'keep me alive';

that will of course return NULL 😀

The tricky part of it is the TIMER functionality. I think there will have to be a seperate thread running for each open connection. These threads should SLEEP most of the time, but WAKE UP – say – every 2 minutes, check HISTORY if anything was sent since since last wake-up. If there was not then send the dummy statement.

I also think that this should be optional/configurable (I have no such issue and do not need the feature). I do not know of other database clients doing things like this. There is no FTP-like 'NOOP' command available in SQL. No 'ping' either (you can ping the host, but not MySQL). However I think that PHP has a mysql_ping() function. Anybody knows what it actually does?

Any idea when that might be added to the product? Is there anything I can do now to get around it?

Thanks,

John

[Author]

Posts