[Building Sakai] SiteStats Tool and events table

[Nuno Fernandes]

Hi Mustansar,

SST tables growth depends on your installation, but it grows slower than
SAKAI_EVENT table as events are aggregated (grouped by some fields)....

Thanks,
Nuno

On Tue, Jul 20, 2010 at 8:13 PM, Mustansar Mehmood <mustansar at rice.edu>wrote:

>  Hi,
>    Thanks for the reply on this matter. My last concern is how fast do the
> tables for sitestats grow assuming they are storing events data.
> Do they just keep the totals or individual entries  for the 'watched'
> events?
>
> Regards,
> Mustansar
>
> On 07/15/2010 06:56 AM, Nuno Fernandes wrote:
>
> Hi Mustansar,
>
>  @steve Thank you for helping :)
>
>  You don't need the data from SAKAI_EVENT *unless*:
>
>    - you are using the contributed feature Steve mentioned before
>    (STAT-61);
>    - you are not using the default configuration for event aggregation
>    (using the quartz job instead).
>
>
>  If you do not fall under the previous cases, you can safely clean up
> those tables. In fact, we archive rows from SAKAI_EVENT and SAKAI_SESSION
> everyday, up to 48hours back.
>
>  Hope this helps,
> Nuno
>
>
> On Thu, Jul 15, 2010 at 12:35 PM, Steve Swinsburg <
> steve.swinsburg at gmail.com> wrote:
>
>> Hi Mustansar,
>>
>>  SiteStats uses an event listener to collect events as they are
>> published, so you shouldn't have any problems with archiving your data.
>>
>>  There is, however, a contributed feature in SiteStats that does work on
>> the SAKAI_EVENT and SAKAI_SESSION tables directly, however it's not
>> activated by default, and we are looking at changing this behaviour to use
>> the normal SST_* tables directly.
>>
>>  -----
>>  http://jira.sakaiproject.org/browse/STAT-61
>>
>>  serverWideStatsEnabled at org.sakaiproject.sitestats.api.StatsManager=true
>>  -----
>>
>>  cheers,
>> Steve
>>
>>   On 15/07/2010, at 9:27 PM, Mustansar Mehmood wrote:
>>
>>    Hi,
>>    We tend to archive events table from the database every few days. I am
>> not sure if this has any implications to using sitestats tool. For isntance
>> if SiteStats tool extracts information from EVENTS table and uses a quartz
>> scheduler to do so at certain intervals and between to such attempts to run
>> the quartz job to extract events there has been an archival process done.
>> Thaks,
>> ./mustansar
>>
>> --
>> 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"
>>
>>
>>
>> _______________________________________________
>> 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 }
>
>
>
> --
> 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
>
>
>


-- 
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/20100802/73a48b4a/attachment.html