[Building Sakai] Site Stats Problems

[Paul Dagnall]

Thank Nuno!
I was, in fact, missing some of those indexes. We added them into production
and following a reboot both problems currently seem to be fixed. Records are
consistently being inserted and it's much faster!
Again thank you for your help!

Paul Dagnall
Web Developer
University of Dayton


On Wed, Sep 15, 2010 at 11:59 AM, Nuno Fernandes <nuno at ufp.edu.pt> wrote:

> Just a separate note that, on 2.1.x, there's a feature that may help to
> have a clue of sitestats performance impact:
> http://jira.sakaiproject.org/browse/STAT-210
>
> <http://jira.sakaiproject.org/browse/STAT-210>Nuno
>
>
> On Wed, Sep 15, 2010 at 4:48 PM, Nuno Fernandes <nuno at ufp.edu.pt> wrote:
>
>> Hi Paul,
>>
>> I would recommend to:
>>
>>    - search the tomcat logs (catalina.out) for eventual errors related
>>    with SiteStats
>>    - (double-)check table indexes accordingly to
>>    https://source.sakaiproject.org/svn/sitestats/trunk/schema/db-tables/oracle/sitestats.sql
>>    - check for DB configuration differences between the dev and
>>    production boxes. Since your test environment has almost half the data and
>>    is probably a slower machine, the speed difference makes me suspect of some
>>    sort of (db?) configuration
>>    - update to 2.0.5 (latest stable release on the 2.0.x series) or even
>>    to 2.1.5 (this is targeted for 2.7.x but is 2.6 API compatible)
>>
>> We use the real-time thread for collecting events too, and our SST_EVENT
>> table has > 4 million records however, we are on MySQL so I cannot point you
>> to any special Oracle consideration!
>>
>> Please let me know of further progress.
>>
>> Hope it helps,
>> Nuno
>>
>>
>> On Wed, Sep 15, 2010 at 3:54 PM, Paul Dagnall <dagnalpb at notes.udayton.edu
>> > wrote:
>>
>>>
>>> I forgot to mention that with the exception of the
>>> collectEventsForSiteWithToolOnly we kept all other Site Stats defaults.
>>> Our
>>> users prefer the real-time thread, so I would like to avoid having to use
>>> StatsAggregateJob quartz job if at all possible.
>>> Thanks!
>>> Paul
>>> --
>>> View this message in context:
>>> http://sakai-project-mail-list-archives.1343168.n2.nabble.com/Building-Sakai-Site-Stats-Problems-tp5534648p5534695.html
>>> Sent from the DG: Development / Buidling Sakai (
>>> sakai-dev at collab.sakaiproject.org) mailing list archive at Nabble.com.
>>> _______________________________________________
>>> 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 }
>>
>
>
>
> --
> 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/20100916/01e98787/attachment.html