[Deploying Sakai] database load

Martin B. Smith smithmb at ufl.edu
Fri Dec 3 10:46:40 PST 2010


On 12/03/2010 01:28 PM, David Haines wrote:
> Tom,
>
> Are the patches you were doing the basis of the 2.7.2 release?  Do you
> have an idea of the problems were mysql specific?
>
> Thanks - Dave
>
> David Haines
> CTools Developer
> Digital Media Commons
> University of Michigan
> dlhaines at umich.edu <mailto:dlhaines at umich.edu>
>

Howdy David,

We saw similar issues in Oracle performance with the initial 2.7 Message 
Center when it was deployed.

We ended up doing quite a few custom indices to resolve it, and at the 
time, I saw some of the same indices being put into the Sakai JIRA as a 
fix to go out with 2.7.1.

Here's the primary tables/columns that indexing helped on:

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

Good luck,
-- 
Martin B. Smith
smithmb at ufl.edu - (352) 273-1374
CNS/Open Systems Group
University of Florida

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5497 bytes
Desc: S/MIME Cryptographic Signature
Url : http://collab.sakaiproject.org/pipermail/production/attachments/20101203/5f1f31c0/attachment.bin 


More information about the production mailing list