[ic] MySql sessions - expiring

Dorothy Puma dorothy at digilink.net
Thu Sep 25 14:35:48 EDT 2003


Jon Jensen wrote:
> On Thu, 25 Sep 2003, Dorothy Puma wrote:
> 
> 
>>I have recently followed Dan Browning's instructions 
>>(http://www.icdevgroup.org/~danb/ic_howto_cluster.html) for converting 
>>over to MySql based sessions.  It works like a charm.  I checked the 
>>archives and found a posting from Mike Heins 
>>(http://developer2.akopia.com/archive/interchange-users/2000/msg03202.html) 
>>stating that he didn't know if the "expire" would work with this kind of 
>>setup, but I didn't see any follow-ups to that.  Does anyone know how to 
>>expire the sessions if running in mysql mode?
> 
> 
> Hmm ... I think the easiest way would be to add a column to the sessions
> table of type TIMESTAMP, name "last_modified" or similar. In MySQL that 
> would get updated to the current time every time the row's modified, then 
> your session expiration would simply consist of somthing like:
> 
> DELETE FROM sessions
> WHERE CURRENT_TIMESTAMP - last_modified > INTERVAL 4 hours;
> 
> That's untested -- the exact syntax will depend on your version of MySQL.
> 
> Jon

Thanks Jon,

I'll have to look into that.  I did notice that there is a timestamp 
field in the table, probably for just this use.  I'll look at trying to 
add this to the cronjobs.

Thanks,
dorothy



More information about the interchange-users mailing list