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: [email protected]
For additional commands, e-mail: [email protected]
