[Deploying Sakai] Performance issues at 2.6.x

[Mike De Simone]

there are a few things I would check:
- RAM usage on the app servers.  make sure there is no swapping.
- check thread usage, make sure you are not out of tomcat threads
(MaxThreads settings in serverl.xml).  Check this with a thread dump:  kill
-3 <tomcat-pid>
- if tomcat memory usage indicated by 'ps' (RSS column) is close to or over
that which is specified in -Xmx you may be having excessive garbage
collection.  Turn on gc logging with something like this added to
setenv.sh: JAVA_OPTS="$JAVA_OPTS -verbose:gc -XX:+PrintGCTimeStamps
-XX:+PrintGCDetails"
- check database logs for slow queries and apply indexes if applicable.  I
know there have been some for message center (but v2.7), but at any rate,
here are indexes that others have applied that have helped:
SAKAI.MFR_MESSAGE_T (SURROGATEKEY , DELETED , DRAFT );
SAKAI.MFR_TOPIC_T("OF_SURROGATEKEY");
SAKAI.MFR_MEMBERSHIP_ITEM_T("T_SURROGATEKEY");
SAKAI.MFR_OPEN_FORUM_T("SURROGATEKEY");
SAKAI.MFR_AREA_T("CONTEXT_ID","ID");
SAKAI.MFR_PRIVATE_FORUM_T("OWNER","SURROGATEKEY","ID");
SAKAI.MFR_TOPIC_T("PF_SURROGATEKEY");
SAKAI.MFR_TOPIC_T("PT_SURROGATEKEY");
SAKAI.MFR_TOPIC_T("TOPIC_DTYPE","TITLE","PF_SURROGATEKEY","UUID") ;

 there was a thread titled "[Deploying Sakai] database load" on 1-dec-10
with this info.   you could search gmane for it.

Hope this helps a little!

Thanks,

-------------------------------
Mike DeSimone
Lead Systems Engineer
*r**Smart* | 602-490-0473


On Thu, Feb 17, 2011 at 02:06, DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es
> wrote:

>      Hi all,
>
>      We are suffering serious performance issues and we don't know why. We
> haven't make any configuration change or Sakai code update and, suddenly,
> our servers are under very high load conditions.
>
>       We are running a 2.6.x. Does anybody know if there is a list of JIRA
> to be apply in order to improve performance in a 2.6.x installation?
>
>        Thank you very much in advance.
>
>        Cheers,
>          DRM
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to
> production-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20110217/170a765f/attachment.html