You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@servicecomb.apache.org by "FuChenGeng (JIRA)" <ji...@apache.org> on 2018/09/03 10:53:00 UTC

[jira] [Created] (SCB-885) saga alpha event scanner optimization

FuChenGeng created SCB-885:
------------------------------

             Summary: saga alpha event scanner optimization
                 Key: SCB-885
                 URL: https://issues.apache.org/jira/browse/SCB-885
             Project: Apache ServiceComb
          Issue Type: Improvement
          Components: Saga
    Affects Versions: saga-0.2.0
            Reporter: FuChenGeng
            Assignee: FuChenGeng


The count of txevents is about 100m. and this sql spend too much time so that the event scanner is blocked.

[SQL]DELETE FROM TxEvent t WHERE t.type = 'SagaEndedEvent' AND t.surrogateId NOT IN ( SELECT MAX(t1.surrogateId) FROM TxEvent t1  WHERE t1.type = 'SagaEndedEvent'  GROUP BY t1.globalTxId);

 

时间: 1308.376s

 

受影响的行: 5



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)