james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tellier Benoit (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (MAILBOX-306) [Cassandra] Populate the attachmentId -> messageIds table
Date Tue, 19 Sep 2017 02:03:00 GMT

     [ https://issues.apache.org/jira/browse/MAILBOX-306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Tellier Benoit closed MAILBOX-306.
----------------------------------

> [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