[Building Sakai] [Deploying Sakai] Performance issues at 2.6.x

[DAVID ROLDAN MARTINEZ]

Thank you very much, Mike. I'll do the checks you suggest. I suspect that the problem is not Oracle but in Tomcat. The strange issue with this is that the problem has arrived unexpectedly because we haven't made any change in configuration or in code (at least, as far as I know).

________________________________
De: Mike De Simone [michael.desimone at rsmart.com]
Enviado el: jueves, 17 de febrero de 2011 13:47
Para: DAVID ROLDAN MARTINEZ
CC: production at collab.sakaiproject.org; mt at collab.sakaiproject.org; sakai-dev at collab.sakaiproject.org
Asunto: Re: [Deploying Sakai] Performance issues at 2.6.x

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
rSmart | 602-490-0473


On Thu, Feb 17, 2011 at 02:06, DAVID ROLDAN MARTINEZ <darolmar at upvnet.upv.es<mailto: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<mailto:production at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/production

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org<mailto:production-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"