[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