Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


0
(click on this box to dismiss)

Session Expiration

After how much time an user session automatically expires? Can I change it manually?

link comment (0)
asked 3 years ago
cubriduser
35
23 Answers
1

There are two session types in CUBRID:

1. BROKER session

2. Application session

1. BROKER session

This session type refers to the time span for which CUBRID maintains an active ("physical") connection to an idle client. To provide better transaction concurrency, CUBRID terminates active connections after a certain time span. You can configure this timeout by setting the value for the parameter SESSION_TIMEOUT in cubrid_broker.conf.

Drivers automatically reestablish a connection to CUBRID if it is terminated. This process is not transparent to the application using this driver. While reestablishing a connection introduces some overhead, there is substantial gain in the fact that you can increase concurrency (an idle client doesn't use any database resources).


2. Application session

A CUBRID user session begins when the driver used for communicating with CUBRID issues a call to connect() and is terminated when the driver issues a call to disconnect() or when it expires. Even though the actual physical connection is not open for the entire duration of time between connect() and disconnect(), CUBRID still keeps some session related information for the associated driver (like LAST_INSERT_ID, session variables, etc)


The expiration of an user session is controlled by the parameter 'session_state_timeout' which should be set in cubrid.conf. The default value is 21600 seconds (6 hours), the minimum value is 60 (1 minute) and the maximum value is 31,536,000 (about 1 year).

link comment (0)
answered 3 years ago
eusto
204
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: