[Building Sakai] Site Stats' server wide stats improvement by Steve Swinsburg

[Steve Swinsburg]

Hi J-F,

Responses inline:

> Do you mean you're gonna use your changes that are currently in trunk with sakai 2.8 or did you intend to write 2.9 instead of 2.8?
> 
We will be running this in our 2.8 install. 

> Does your last comment in STAT-299 mean the server wide stats for MySQL are not using the sakai_session or sakai_event tables anymore but this has not been changed at all for Oracle?


The original server wide stats was MySQL only. This is a rewrite of that. There is no Oracle support at this stage but it would be easy to implement if someone writes the SQL. Once you perform the db conversion to get the historical data in the SiteStats format (included for MySQL), then the data in the sakai_event and sakai_session tables are no longer used - SiteStats was modified to collect the additional events and store them in its own tables.

cheers,
Steve



On 11/10/2011, at 11:04 PM, Jean-Francois Leveque wrote:

> Creating a fork from previous thread.
> 
> Do you mean you're gonna use your changes that are currently in trunk with sakai 2.8 or did you intend to write 2.9 instead of 2.8?
> 
> Does your last comment in STAT-299 mean the server wide stats for MySQL are not using the sakai_session or sakai_event tables anymore but this has not been changed at all for Oracle?
> 
> cheers,
> j-f
> 
> On 11/10/2011 12:23, Steve Swinsburg wrote:
>> At the risk of hijacking this thread, https://jira.sakaiproject.org/browse/STAT-299
>> 
>> cheers,
>> s
>> 
>> 
>> On 11/10/2011, at 7:28 PM, Jean-Francois Leveque wrote:
>> 
>>> Could you tell us which JIRA has the Site Stats server wide stats improvement, Steve ?
>>> 
>>> J-F
>>> 
>>> On 10/10/2011 23:54, Steve Swinsburg wrote:
>>>> I think the pruning you are doing is excessive and may be causing the
>>>> issue. To compare, we have data in the SAKAI_SESSION and SAKAI_EVENT
>>>> tables going back to 2007, and we are running 2.6 without an issue in
>>>> this area[1].
>>>> 
>>>> Once we move to 2.8 we'll be cleaning it out, but not that regularly
>>>> (once a week perhaps).
>>>> 
>>>> 
>>>> 
>>>> [1] This historical data was required for the previous impl of server
>>>> wide stats in Site Stats, but isn't anymore.