[Building Sakai] Site Stats/ Server-wide Reports

[Nuno Fernandes]

Hi Jon!

What we typically do is to move data from sakai DB to a "sakai_archive" DB
which also contains SAKAI_EVENT and SAKAI_SESSION tables. We run a script on
a daily basis to "archive" all data with more than 48h.

If you are using SiteStats with the default configuration (using the
realtime thread for processing events), these tables are never used by the
tool. If you run with the job scheduler configuration, just need to make
sure to archive only the events that have already been processed.

As far as I know, after data is written to these tables and user closes his
session, this data is not processed by any tool (exception for SiteStats on
the job scheduler configuration). To be on the safe side, we only remove
data from closed sessions (and that why we only "archive" data 48h old).
There are some more institutions that do a periodically clean up these two
tables!

Hope it helps,
Nuno

On Thu, Jun 17, 2010 at 3:16 PM, Jon Wheat <jwheat at messiah.edu> wrote:

>  Nuno,
>
> Hi there, I'm working with Dorie on the Stats issue here at Messiah.
> The SAKAI_EVENTS table has entries from way back in 2008, same with the
> SAKAI_SESSION table.
> Is it safe to remove old records from those two tables ?
>
>  -Jon
>
>



-- 
Nuno Fernandes  .  { Analyst/Programmer }

|| web  . { http://www.ufp.pt  |  http://tinyurl.com/nfgrilo  |  follow_me @
nfgrilo }
|| work . { Universidade Fernando Pessoa  |  Praça 9 de Abril, 349  |
 4249-004 Porto }
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100617/6ea5443e/attachment.html