[Building Sakai] Severe DB Performance Issues for 2.9

[Matthew Jones]

Hi Aaron,

It looks like these caches needed to be configured in EhCacheFactoryBean.
Possibly because of how they were wired?

I attached a patch to a branch on
https://jira.sakaiproject.org/browse/KNL-1118

That allows the cache values to be set. It looks like all of the caches
I've tried are working with this format now. Some review could be used. I
don't have crucible setup for branches, but it's indexing now.


On Wed, Sep 4, 2013 at 7:40 PM, Aaron Zeckoski <azeckoski at unicon.net> wrote:

> I think this can only work for caches registered with or created
> through the memory service. Maybe the issue is how that cache is
> created?
> -AZ
>
>
> On Wed, Sep 4, 2013 at 5:42 PM, Sam Ottenhoff <ottenhoff at longsight.com>
> wrote:
> >
> >
> >
> > On Wed, Sep 4, 2013 at 5:39 PM, Lydia Li <lydial at stanford.edu> wrote:
> >>
> >> Sam/Matthew,
> >>
> >> I'm a bit confused about what you said.  I just tested in my dev
> instance
> >> running 2.9.x and this syntax still seems to work.
> >>
> >>
> >>
> memory.org.sakaiproject.site.impl.SiteCacheImpl.cache=timeToLiveSeconds=303,timeToIdleSeconds=346,maxElementsInMemory=10220
> >
> >
> >
> > Yes, that's the correct form, and it works perfectly for *that* cache.
>  But
> > it doesn't seem to work correctly on the SAKAI_SITE_PAGE_PROPERTY cache:
> >
> >   org.sakaiproject.db.BaseDbFlatStorage.SAKAI_SITE_PAGE_PROPERTY
> >
> >
> > --Sam
> >
> > _______________________________________________
> > 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"
>
>
>
> --
> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130906/a86da9e7/attachment.html