[cle-release-team] Sakai 2.9 caching

[Matthew Jones]

I haven't had time to review, SAK-22786, hopefully next week. But if you
have any memory reports to add to that jira from the load tests it could be
helpful to identify settings that could be improved.
Charles Hedrick had some performance problems back a few months ago, and we
had some Mysql specific tuning suggestions as well as cache ideas. I'm not
sure what the end result that thread was.

http://collab.sakaiproject.org/pipermail/production/2012-September/001896.html



On Fri, Nov 2, 2012 at 3:45 PM, Noah Botimer <botimer at umich.edu> wrote:

> There's also KNL-934, which came out of VT originally. I reviewed the
> patches, as did Aaron. IU has been running them in production.
>
> It's related in that it caches role keys and uses an IN clause instead of
> doing joins in some cases. So, it's somewhat caching, somewhat query
> complexity.
>
> Thanks,
> -Noah
>
> On Nov 2, 2012, at 3:38 PM, Beth Kirschner wrote:
>
> > There's KNL-600 -- can anyone recall any other caching related JIRAs
> offhand? I know everyone's heads down on getting an RC03 release out, but
> if there are any quick thoughts, let me know.
> >
> > Thanks!
> > - Beth
> >
> > On Nov 2, 2012, at 2:59 PM, Beth Kirschner wrote:
> >
> >> Hi Sam,
> >>
> >>  I recall you making a comment at last week's release team meeting
> regarding caching being much improved in Sakai 2.9 -- are there any caching
> settings or JIRAs related to caching settings you can dig up that related
> to these improvements?
> >>
> >>  We've just finished updating our load test scripts for Sakai 2.9 and
> the first load test is unfortunately not encouraging. Database CPU usage is
> up and the top queries are realms queries (which is what we've always
> seen). Since this is just an initial test, I'm assuming there are
> settings/options that we can change to improve on this.
> >>
> >> Thanks,
> >> - Beth
> >>
> >
> > _______________________________________________
> > cle-release-team mailing list
> > cle-release-team at collab.sakaiproject.org
> > http://collab.sakaiproject.org/mailman/listinfo/cle-release-team
>
> _______________________________________________
> cle-release-team mailing list
> cle-release-team at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/cle-release-team
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/cle-release-team/attachments/20121102/64ee4b5d/attachment-0006.html