[Building Sakai] Site Stats/ Server-wide Reports

[Nuno Fernandes]

Hi Mustansar,

SiteStats have a dedicated confluence page, with details about configuration
options and installation instructions:
http://confluence.sakaiproject.org/display/STAT

<http://confluence.sakaiproject.org/display/STAT>Regarding db data archive,
I am not aware of such page, but I would recommend you to search on
Confluence anyway...

Nuno

On Thu, Jun 17, 2010 at 6:45 PM, Mustansar Mehmood <mustansar at rice.edu>wrote:

>  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> 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.orghttp://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
>
>
>
> _______________________________________________
> 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"
>



-- 
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/20100618/3ecd4bf2/attachment.html