[JAMES-3940] Set up TTL on mailbox_change and email_change

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: master
• Component/s: cassandra, JMAP
• Assignee: Antoine Duprat
• Reporter: Tran Hong Quan
• Created: 15/Sep/23 04:29
• Updated: 06/Oct/23 19:17
• Resolved: 06/Oct/23 19:17

Description

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`)

Issue Links

• links to: GitHub Pull Request #1729