Session data in DB not going away

[littlebob (Chris)]

Hi,

For one of my applications, I just changed the configuration to handle sessions in the database (Mysql, InnoDB). Here is what I added in the config file:

'session' => array (

	'class' => 'system.web.CDbHttpSession',

	'connectionID' => 'db',

	'sessionTableName' => 'session',

),

After the session table was created I added one more line:

	'autoCreateSessionTable' => FALSE,

The problem I’m having now is that the data in the session table is not being deleted. There are still entries in there with an expiration date of 5 days ago. I was under the impression that the data should be deleted after 24 minutes. However, I couldn’t find any information on how and where the session data is deleted. What process does the actual automatic deleting? Why is the data still there?

Thanks!

Bob

[littlebob (Chris)]

After spending a few more hours looking into this, I think I understand what’s going on now. The garbage collection isn’t running as often as I thought it would. I found the following after googling:

Perhaps the gc_maxlifetime parameter should have been called gc_minlifetime, because the value represents the minimum time garbage collection permits an inactive session to exist. Remember that garbage collection is performed only when a request that initializes a session is made, and then only with the probability set by gc_probability.

[JFReyes (Jose Reyes)]

Thanks for the heads up Littlebob, I wondered about this but didn’t have a clue.