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)
