[
http://opencast.jira.com/browse/MH-8023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=27903#comment-27903
]
Ruediger Rolf commented on MH-8023:
-----------------------------------
Logging queries and especially slow queries brought up that this query is the
most executes query currently:
SELECT t0.ID, t0.JOB_PRODUCER, t0.PATH, t0.SERVICE_TYPE, t0.ONLINE,
t0.host_reg, t1.STATUS, COUNT(t1.STATUS) FROM SERVICE_REGISTRATION t0 LEFT
OUTER JOIN JOB t1 ON (t1.processor_svc = t0.ID), HOST_REGISTRATION t2 WHERE
(((t0.ONLINE = 1) AND (t2.MAINTENANCE = 0)) AND (t2.ID = t0.host_reg)) GROUP BY
t0.ID, t0.JOB_PRODUCER, t0.PATH, t0.SERVICE_TYPE, t0.ONLINE, t0.host_reg,
t1.STATUS;
# Time: 110907 16:14:38
# User@Host: matterhorn[matterhorn] @ xxx.xx.xx.xx [xx.xx.xx.x]
# Query_time: 2 Lock_time: 0 Rows_sent: 48 Rows_examined: 45419
> MySQL is running at 100% CPU Matterhorn unresponsive and Java is sometimes
> out of heap space
> --------------------------------------------------------------------------------------------
>
> Key: MH-8023
> URL: http://opencast.jira.com/browse/MH-8023
> Project: Matterhorn Project
> Issue Type: Bug
> Components: Architecture & Services
> Affects Versions: 1.1.x (branch)
> Reporter: Ruediger Rolf
> Priority: Critical
>
--
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]
_______________________________________________