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

[John Bush]

I'd take a look at http://www.appdynamics.com/, even the lite version
is a huge help.  Its like YourKit but you can run it in production.
Its the most amazing production java profiling tool I've ever seen, it
doesn't require any instrumentation, you just attach it to the vm and
it uses byte injection to discover and analyze everything.  They claim
only a 2% hit in performance, which is well worth it in man hours
saved, if you ask me.

On Thu, Feb 17, 2011 at 6:12 AM, DAVID ROLDAN MARTINEZ
<darolmar at upvnet.upv.es> wrote:
> Thanks for the remark. I'll be careful (even more than usually).
>
> ________________________________________
> De: azeckoski at gmail.com [azeckoski at gmail.com] En nombre de Aaron Zeckoski [azeckoski at unicon.net]
> Enviado el: jueves, 17 de febrero de 2011 14:05
> Para: DAVID ROLDAN MARTINEZ
> CC: production at collab.sakaiproject.org; sakai-dev at collab.sakaiproject.org; mt at collab.sakaiproject.org
> Asunto: Re: [Building Sakai] [Deploying Sakai] Performance issues at 2.6.x
>
> I would be careful about turning on GC logging actually. That will
> increase the load and actually slow down your server (just a little)
> making a bad situation just a little bit worse. Probably better to
> just monitor the JVM remotely as this will give you just as much info
> and can be easily switched on and off.
>
> -AZ
>
>
> On Thu, Feb 17, 2011 at 7:47 AM, Mike De Simone
> <michael.desimone at rsmart.com> wrote:
>> 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> 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"
>>
>>
>> _______________________________________________
>> 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 Engineer - http://tinyurl.com/azprofile
> _______________________________________________
> mt mailing list
> mt at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/mt
>



-- 
John Bush
602-490-0470