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

[Steve Swinsburg]

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> 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
> 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"