[WG: Production / Deploying Sakai] jforums performance
Murthy Tanniru
murthy at etudes.org
Tue Mar 10 10:27:41 PDT 2009
Chuck,
In the earlier versions of jforum some indexes are missing. There is a
file in the jforum source at
jforum-tool/src/webapp/WEB-INF/config/database/generic/indices.sql You
can add missing indexes as per this file and drop any duplicate indexes.
I attached the file for reference.
Thanks
Murthy
Charles Hedrick wrote:
> This weekend we had serious performance problems, with mysql using 95%
> of the CPU and general system slowness. It appears to me that the
> problem was jforum. Here's what I did:
>
> create index jforum_course_categories_course_id on
> jforum_sakai_course_categories(course_id);
> create index jforum_user_sakai_user jforum_users(sakai_user_id);
>
> jforum_user is the list of users. It's got 60,000 entries at Rutgers.
> It's indexed on the jforum user ID, but the lookups were by Sakai user
> ID, which is certainly to be expected. That column wasn't indexed. Oops.
>
> There was also a complex query being done that looked up all the
> categories for a course. Unfortunately the category table wasn't
> indexed at all. You wouldn't think the list of categories would be big
> enough to be an issue, but we have 11,000 entries in that table. It
> needs to be indexed.
>
> After adding the second index, load went from 95% to 12%. Of course
> that could be coincidence.
>
> Am I missing some database setup for jforum?
>
> _______________________________________________
> 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"
>
--
Murthy Tanniru
Senior Learning Systems Developer
Etudes Inc
http://etudes.org
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: indices.sql
Url: http://collab.sakaiproject.org/pipermail/production/attachments/20090310/654b3092/attachment.pl
More information about the production
mailing list