james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raphaël Ouazana (JIRA) <j...@apache.org>
Subject [jira] [Created] (MAILBOX-306) [Cassandra] Populate the attachmentId -> messageIds table
Date Tue, 12 Sep 2017 13:00:05 GMT
Raphaël Ouazana created MAILBOX-306:
---------------------------------------

             Summary: [Cassandra] Populate the attachmentId -> messageIds table
                 Key: MAILBOX-306
                 URL: https://issues.apache.org/jira/browse/MAILBOX-306
             Project: James Mailbox
          Issue Type: Improvement
            Reporter: Raphaël Ouazana


MAILBOX-305 introduced an attachmentId -> messageIds table. We now need to migrate data
to it.

The plan :
- (Migration optimisation) compact messageV2 table.
- SELECT * on messageV2 with high timeout value (several hours?) to get the msgId -> attIds
relation. Reducing the page size can also help avoid errors (maybe ~ 100)
- For each entry, write to the new table.
- Compact new table once finished.

Tips: ensure no concurrency on writes (sequential). It's fast enough and reduce drasticly
the risk to overwhelm the cluster.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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


Mime
View raw message