[ 
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: server-dev-unsubscr...@james.apache.org
For additional commands, e-mail: server-dev-h...@james.apache.org

Reply via email to