Tran Hong Quan created JAMES-3940:
-------------------------------------

             Summary: Set up TTL on mailbox_change and email_change
                 Key: JAMES-3940
                 URL: https://issues.apache.org/jira/browse/JAMES-3940
             Project: James Server
          Issue Type: Improvement
          Components: cassandra, JMAP
    Affects Versions: master
            Reporter: Tran Hong Quan
            Assignee: Antoine Duprat


Why: Today the changes takes 1.8GB out of 20GB Cassandra database.
 
```
Table: email_change
SSTable count: 10
Old SSTable count: 0
Space used (live): 1458287826
 
Table: mailbox_change
SSTable count: 6
Old SSTable count: 0
Space used (live): 321767927
```
 
Changes serves resynchronisation, and is used up resonnably quickly. Once used, 
those can be discarded as not useful anylonger.
 
=> TTL value: 2 month (default value - configurable)
 
Note that if missing this is handled well (`cannotCalculateChanges`)



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org

Reply via email to