[Building Sakai] Site Stats Problems

[Nuno Fernandes]

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/20100915/f55dace9/attachment.html