[Deploying Sakai] MySQL performance issues with 2.8

[Sam Ottenhoff]

Hi JFL,

Sharing the actual queries that are slow will be much more helpful than the
aggregation you have provided.  For example, based on your MsgCntr queries,
it's possible we could tell if you are missing some key performance
improvements committed after 2.8.0 was released.

--Sam


On Wed, Dec 5, 2012 at 9:29 AM, Jean-Francois Leveque <
jean-francois.leveque at upmc.fr> wrote:

> 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
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to
> production-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20121205/e4da8603/attachment.html