[ 
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]
_______________________________________________

Reply via email to