rivet/packages/session/session-purge-mysql.sql

--
--  Note  for Mysql 4.x and 5.0 users
-- 
--  Though Mysql<5.1 supports the specification 'ON CASCADE DELETE' for CREATE TABLE
--  this is only for sql code portability: deleting a row in rivet_session doesn't 
--  imply Mysql remove the rows in rivet_session_cache matching the same session_id.
--  This table gets progressively cluttered with rows referring to sessions that are long dead.

--  This command can be used to clean up 'rivet_session_cache'

delete rivet_session_cache from rivet_session_cache left join rivet_session as t2 using(session_id) where t2.session_id is null;

--  You may subclass 'Session' in order to specialize the method do_garbage_collection and 
--  exec this command after the superclass method has run.

--  Starting with version 5.1 the 'on delete cascade' should be working (but I haven't tried)
--  and also triggers can be used to achive the same goal

--  2 Oct 2006