[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