On 3 March 2016 at 11:36:59 PM, Andrea Brancatelli (abrancate...@schema31.it) wrote: Yes you can proceed easily with those two settings and have a first bigger improvement.
If you're switching away from dbmail I wouldn't go trough the hassle of upgrading, since the upgrade need to reparse all the message to use the de-deduplication features. Note: the ALTER TABLE will perform the OPTIMIZE TABLE, so you don't need to run the two commands, just go for the ALTER TABLE. Thanks for the reply - my thoughts with the upgrade. The issue with OPTIMISE TABLE is that it needs the same amount of space to do the optimise, plus the tables are write locked whist this happens (is this correct?). Thats going to take a while on a 650GB table :) with live data on it. Does Alter table write lock as well? PS: also - what do i alter… Simon
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
