[Deploying Sakai] Sakai 2.7.1 performance issues

[Berg, Alan]

Hi all,

I know that Sam Ottenhof has been doing some work on missing indexes for post 2.7.1, so I hope he comments on list.

Chris Kretler (UMICH) is the QA lead for performance during the 2.8 QA cycle and will be stress testing (with the support of Steve Giffens)  high risk area's to limit the risk of missing index's.  I notice Wiley had performed a series of stress tests and found similar missing indexes during the 2.5 cycle. Expert support is always welcome in this area if anyone has time to volunteer.

Charles Hendrick from Rutgers has suggested that one of the significant risks is updating from one version of Sakai to another and forgetting one index or an other. I expect that when 2.8 is released we will also publish in the documentation the expected end schema.

Feedback always welcome,

Alan

Alan Berg
QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg

________________________________________
From: Berg, Alan
Sent: 27 September 2010 08:45
To: Tom Hall; sakai-dev Developers; production at collab.sakaiproject.org
Subject: RE: [Deploying Sakai] Sakai 2.7.1 performance issues

Alan

Alan Berg
QA Director - The Sakai Foundation

Senior Developer / Quality Assurance
Group Education and Research Services
Central Computer Services
University of Amsterdam

http://home.uva.nl/a.m.berg

________________________________________
From: production-bounces at collab.sakaiproject.org [production-bounces at collab.sakaiproject.org] on behalf of Tom Hall [thall at brocku.ca]
Sent: 25 September 2010 20:39
To: sakai-dev Developers; production at collab.sakaiproject.org
Subject: [Deploying Sakai] Sakai 2.7.1 performance issues

  Good day everyone

We are having some severe performance issues on our Sakai 2.7.1 system.
We are using MySQL and Java 1.6

The load averages on the database server are in the area of 10 (usually
under 3) and all users no matter what site or tool are experiencing
problems.  We had the same problem yesterday and a restart appeared to
clear it, Today, a restart has helped but we are still  having problems.

About the only thing we are seeing in a process list are queries like

select count(*) as col_0_0_ from MFR_TOPIC_T topicimpl0_ inner join
MFR_OPEN_FORUM_T openforumi2_ on
topicimpl0_.of_surrogateKey=openforumi2_.ID inner join MFR_AREA_T
areaimpl3_ on openforumi2_.surrogateKey=areaimpl3_.ID inner join
MFR_MEMBERSHIP_ITEM_T membership4_ on
topicimpl0_.ID=membership4_.t_surrogateKey, MFR_PERMISSION_LEVEL_T
permission1_ where areaimpl3_.CONTEXT_ID='ADED4F32D02FW2010WWW001' and
topicimpl0_.MODERATED=1 and (membership4_.NAME in ('Student' ,
'ADED4F32D02FW2010WWW001')) and permission1_.MODERATE_POSTINGS=1 and
(permission1_.TYPE_UUID<>'6db07323-5783-4d8d-b744-2a988d91749d' and
permission1_.NAME=membership4_.PERMISSION_LEVEL_NAME or
membership4_.PERMISSION_LEVEL=permission1_.ID)

These queries are taking long periods of time (>2 minutes).

Has anyone seen anything like this in 2.7.1?

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