[
http://opencast.jira.com/browse/MH-9324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32520#comment-32520
]
Adam McKenzie commented on MH-9324:
-----------------------------------
With the addition of this index load instantly went from 4 to 0.01 on a 2 core,
2 GB of RAM machine (was only using 1.2 GB of RAM) and little disk activity.
> MySQL scripts need an index for the user_action table with session_id and
> type to decrease loads on large installls
> -------------------------------------------------------------------------------------------------------------------
>
> Key: MH-9324
> URL: http://opencast.jira.com/browse/MH-9324
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Administrative Tools
> Affects Versions: Trunk, 1.4, 1.3
> Reporter: Adam McKenzie
> Assignee: Adam McKenzie
> Priority: Blocker
> Fix For: 1.4
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
http://opencast.jira.com/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
Matterhorn mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn
To unsubscribe please email
[email protected]
_______________________________________________
