1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
--
-- 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
|
