[Building Sakai] Sakai 2.9.2 and Kernel 1.3.2 problems during load testing

[Kusnetz, Jeremy]

We are seeing a much higher increase of that event since upgrading too.  Can someone tell me what the effect of setting this parameter does?



[cid:image001.png at 01CE9214.A486EC30]



-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Beth Kirschner
Sent: Monday, August 05, 2013 5:43 PM
To: sakai-dev at collab.sakaiproject.org sakai
Subject: Re: [Building Sakai] Sakai 2.9.2 and Kernel 1.3.2 problems during load testing



We've found the source of the high db cpu load in the web portlet code - I've filed the following JIRA:

                https://jira.sakaiproject.org/browse/SAK-23841



An easy workaround for those who might see this problem is to set the following in sakai.properties:

                iframe.xframe.cachetime=0



- Beth



On Aug 1, 2013, at 6:02 PM, Steve Swinsburg <steve.swinsburg at gmail.com<mailto:steve.swinsburg at gmail.com>> wrote:



> It's possible to restructure that query to give the database a better chance at optimising. It joins everything only to discard most of it at the end. I know the execution time isn't the real issue but everywhere we can optimise for performance we should.

>

> Cheers,

> S

>

>

>

> Sent from my iPad

>

> On 02/08/2013, at 6:56, Beth Kirschner <bkirschn at umich.edu<mailto:bkirschn at umich.edu>> wrote:

>

>> Hi all,

>>

>> We're running load tests against a Sakai 2.9.2 based build, with a few kernel patches (mentioned at bottom of email) and seeing a 14 times increase with the number of executions of the SAKAI_REALM_FUNCTION query below. While we're digging into why, I thought I'd ask this esteemed audience if they had any thoughts as to what might be causing this increase.

>>

>> Thanks,

>> - Beth

>>

>> ### Results from our Sakai 2.9.2 based build:

>>

>>       Elapsed                  Elapsed Time

>>       Time (s)    Executions  per Exec (s)  %Total   %CPU    %IO    SQL Id

>> ---------------- -------------- ------------- ------ ------ ------ -------------

>>        2,676.6        748,379          0.00   17.1   99.5     .0 3ryj6azagfbwv

>> Module: JDBC Thin Client

>> select DISTINCT FUNCTION_NAME from SAKAI_REALM_FUNCTION SRF inner

>> join SAKAI_REA LM_RL_FN SRRF on SRF.FUNCTION_KEY = SRRF.FUNCTION_KEY

>> inner join SAKAI_REALM_ROL E SRR on SRRF.ROLE_KEY = SRR.ROLE_KEY

>> inner join SAKAI_REALM SR on SRRF.REALM_KE Y = SR.REALM_KEY where

>> SRR.ROLE_NAME = :1 and SR.REALM_ID IN (:2 ,:3 ,:4 )

>>

>>

>> ### Results from our Sakai 2.9.1 based build

>>

>>    176.6       53,040       0.00    1.8      177.6   99.4     .0 3ryj6azagfbwv

>> Module: JDBC Thin Client

>> select DISTINCT FUNCTION_NAME from SAKAI_REALM_FUNCTION SRF inner

>> join SAKAI_REA LM_RL_FN SRRF on SRF.FUNCTION_KEY = SRRF.FUNCTION_KEY

>> inner join SAKAI_REALM_ROL E SRR on SRRF.ROLE_KEY = SRR.ROLE_KEY

>> inner join SAKAI_REALM SR on SRRF.REALM_KE Y = SR.REALM_KEY where

>> SRR.ROLE_NAME = :1 and SR.REALM_ID IN (:2 ,:3 ,:4 )

>>

>>

>> ## Patches previously run in production

>> KNL-1056        Need more efficient caching of notifyingMemoryStore object

>> KNL-1016        Allow multiple site types for isCourseSite(), isProjectSite(), isPortfolioSite()

>>

>> ## Patches new to this build

>> KNL-989         Add tool groups

>> KNL-1060        Cache invalidation for grants isn't happening when editing a special realm

>> KNL-990         Joinable Groups

>> KNL-885         The group property to enable Site Info to see groups should be moved out of site-manage and into kernel-api

>> KNL-874         Replace getFormattedMessage array argument with a varargs

>>

>> _______________________________________________

>> sakai-dev mailing list

>> sakai-dev at collab.sakaiproject.org<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"



_______________________________________________

sakai-dev mailing list

sakai-dev at collab.sakaiproject.org<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"
This message is private and confidential. If you have received it in error, please notify the sender and remove it from your system.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130805/d82237a3/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 21485 bytes
Desc: image001.png
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130805/d82237a3/attachment.png