[Deploying Sakai] MySQL performance issues with 2.8

[Jean-Francois Leveque]

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