On 02/13/2012 11:51 PM, Jorge Bastos wrote:
> Paul,
>
> This bug may explain why I can't apply the:
Indeed.
> CREATE UNIQUE INDEX dbmail_envelope_1 ON dbmail_envelope(physmessage_id);
>
> Of the file: 2_3_6-3_0_0.mysql
>
> What do you recommend to search & delete the duplicated info, without
> recreate the cache?
> I'm with 110GB right now, and if I can bypass the cache recreate would be
> good to not having the service down.
Do a 'truncated table dbmail_envelope' and add the above index right
away. Then run dbmail-util -by to recreate the cached envelopes.
This will only affect IMAP users.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/i...@nfg.nl/+31.85.877.99.97
________________________________________________________________
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
