[Deploying Sakai] 2.7 load

[Hedrick Charles]

The students just got back for the Fall, so this is the first time we've run 2.7 under a realistic load. It looks to me like the CPU usage on both front ends and database is significantly higher, by at least a factor of 2. This is probably not going to kill us, but it worries me.

I took a very brief snapshot of database queries during the day yesterday. Here's the tables it was querying. The scripts were pretty simple-minded, so this isn't perfect. But it should give an indication. The top queries seem to be simple lookups on single tables, so caching should work very well. I see no evidence that this data is actually being cached.


   2561 SAKAI_SITE_TOOL_PROPERTY 
   2196 SAKAI_SITE_TOOL 
   1237 SAKAI_REALM_RL_FN,SAKAI_REALM 
   1053 SAKAI_SITE_PAGE_PROPERTY 
    253 SAKAI_SITE_PAGE 
    237  
    181 SAKAI_REALM_ROLE 
    108 SAKAI_PRIVACY_RECORD 
     89 SAKAI_SITE,SAKAI_SITE_USER 
     84 CONTENT_COLLECTION 
     70 SAKAI_SITE_PROPERTY 
     64 SAKAI_SITE 
     63 CONTENT_RESOURCE 
     48 SAKAI_REALM_ROLE_DESC 
     48 SAKAI_REALM_RL_GR 
     48 SAKAI_REALM_RL_FN 
     47 rutgers_user 
     33 SAKAI_ALIAS 
     30 SAKAI_SYLLABUS_ITEM 
     24 SAKAI_SESSION 
     24 SAKAI_REALM_FUNCTION 
     22 SAKAI_SITE_GROUP_PROPERTY 
     22 SAKAI_SITE_GROUP 
     20 ANNOUNCEMENT_CHANNEL 
     19 ANNOUNCEMENT_MESSAGE 
     15 SST_EVENTS 
     15 SAKAI_USER_ID_MAP 
     15 SAKAI_USER 
     13 SAKAI_PRESENCE 
     12 melete_resource 
     12 jforum_posts 
     11 SAKAI_REALM_PROPERTY 
     10 SAKAI_PREFERENCES 
     10 CM_MEMBER_CONTAINER_T 
      8 CALENDAR_CALENDAR 
      7 SAM_ASSESSMENTGRADING_T 
      7 CALENDAR_EVENT 
      6 the 
      6 identifications 
      5 melete_section 
      5 SST_SITEVISITS 
      5 SST_SITEACTIVITY 
      4 rutgers_user_section 
      4 osp_site_tool 
      4 osp_presentation_template 
      4 osp_authz_simple 
      4 magazines 
      4 jforum_import 
      3 steps 
      3 jforum_topics_mark 
      3 content_resource_lock 
      3 CHAT2_CHANNEL 
      2 osp_template_file_ref 
      2 osp_presentation_item_def 
      2 metaobj_form_def 
      2 melete_module 
      2 melete_course_module 
      2 jforum_users 
      2 jforum_sakai_sessions 
      2 a 
      2 SST_RESOURCES 
      2 SAM_PUBLISHEDEVALUATION_T 
      2 SAKAI_SITE_USER 
      2 SAKAI_REALM_PROVIDER 
      2 SAKAI_REALM 
      2 SAKAI_EVENT_DELAY 
      2 CONTENT_TYPE_REGISTRY 
      2 CM_ACADEMIC_SESSION_T 
      2 CHAT2_MESSAGE 
      2 ASSIGNMENT_CONTENT 
      2 ASSIGNMENT_ASSIGNMENT 
      1 osp_presentation_item 
      1 osp_presentation_comment 
      1 osp_presentation 
      1 melete_site_preference 
      1 melete_section_resource 
      1 melete_module_shdates 
      1 jforum_topics 
      1 jforum_sessions 
      1 jforum_sakai_course_initvalues 
      1 jforum_sakai_course_categories 
      1 jforum_privmsgs 
      1 jforum_categories 
      1 SITEASSOC_CONTEXT_ASSOCIATION 
      1 SAM_STUDENTGRADINGSUMMARY_T 
      1 SAM_PUBLISHEDSECTION_T 
      1 SAM_PUBLISHEDFEEDBACK_T 
      1 SAM_PUBLISHEDASSESSMENT_T 
      1 SAKAI_SYLLABUS_DATA 
      1 SAKAI_REALM, 
      1 QRTZ_TRIGGERS 
      1 CM_SEC_CATEGORY_T