[Building Sakai] Site Stats/ Server-wide Reports

[Mustansar Mehmood]

Is there any documentation page that goes over setting up sitestats tool 
and other instructions how to reap information out of the stored data in 
confluence or somewhere else ?
On 06/17/2010 09:38 AM, Nuno Fernandes wrote:
> 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 
> <mailto: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 }
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"


-- 
Mustansar Mehmood
Educational System Developer&  Integrator

Information Technology
6100 Main St. MS 119
Houston Texas 77005

Phone:(713)348-2523
Fax  :(713)348 6099
email:mustansar at rice.edu





I have yet to see any problem, however complicated, which, when,you  looked at it in the right way, did not become still more complicated.
     -- Poul Anderson


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20100617/f7aa6e01/attachment.html