How to disconnect the useless sessions? (From MR1809)

~ 0 min
2016-03-08 04:55

To disconnect the connection automatically, DBMaker supports two keywords DB_ITimO and DB_DtClt.

The keyword DB_ITimO is used in Server side. DB_ITimO specifies the idle timeout interval, According to this value, DBMaker automatically disconnects connections those have no database operations with a higher value than the specified timeout interval. Before setting DB_DtClt, make sure the DB_ITimO is turned on (the default setting is disabled).

The keyword DB_DtClt is used in Client side. So each client can set DB_DtClt value for itself, and each client can have different detect times. DB_DtClt is only used to detect connection, it can not disconnect connection. For each client, server will use the maximum[1] value between DB_ITimO and DB_DtClt to disconnect connection.

Now, DBMaker can not identify the useless connections and the connections those have no database operations for long time (Idle). So the only method to disconnect the useless connections automatically is setting the DB_ITIimO to a larger value. For the less DB_ITimO value will disconnect some idles too.



[1] After DBMaker 5.0, the action will change; it will use the minimum value between DB_ITimO and DB_DtClt to disconnect the connection.

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags