[
https://issues.apache.org/jira/browse/JAMES-3940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Tellier closed JAMES-3940.
---------------------------------
Resolution: Fixed
> 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
> Priority: Major
> Time Spent: 40m
> Remaining Estimate: 0h
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
