[Deploying Sakai] MySQL performance issues with 2.8

Jean-Francois Leveque jean-francois.leveque at upmc.fr
Wed Dec 5 06:29:55 PST 2012


Hi all,

I've just checked my most frequent MySQL slow log requests.

Apart from the commits that cannot be traced by slow log only, I've 
found the tables that appear more frequently are from 3 different parts 
of the code.

msgcntr (MFR_*)
sitestats (SST_*)
kernel (SAKAI_SITE, SAKAI_SITE_USER, SAKAI_SITE_PAGE, 
CONTENT_RESOURCE_DELETE)

Have some of you done some extra indexing or other changes that improved 
performance with these?

Cheers,

J-F


More information about the production mailing list