[
https://issues.apache.org/jira/browse/SCB-885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
FuChenGeng updated SCB-885:
---------------------------
Summary: saga alpha event scanner delete duplicate events sql optimization
(was: saga alpha event scanner delete duplicateEventsByType sql optimization)
> saga alpha event scanner delete duplicate events sql 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
> Priority: Minor
>
> 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)
