Am 03.03.2016 um 22:08 schrieb Simon Buchanan:
On 3 March 2016 at 11:36:59 PM, Andrea Brancatelli (abrancate...@schema31.it <mailto: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?)
on a modern setup (MariaDB 10.0.x) they are not locked in your case - yes, they are
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
