Archive campaigns delivery logs

Archive campaigns delivery logs

Since MailWizz stores a lot of data, there is one table in particular that will grow very much, that is, the table that store delivery info for each subscriber, its name is `campaign_delivery_log`.
This can be problematic for small servers since searching through a lot of data can take time and memory, and small servers can be slow at this.
We can alleviate this problem by moving the delivery logs into a separate table, in an archive table.
In order to do so, we need to run the “archive-campaigns-delivery-logs” command like:

/usr/bin/php -q /var/www/html/apps/console/console.php archive-campaigns-delivery-logs

In your case, the path to console.php file might be different.

The above command, once you run it, will take all the sent campaigns so far and copy them in the archive table.

Notes:
· This command is still experimental, and there are chances for things to break, so make sure you always have a backup before proceeding.
· Since this command moves logs in a different table, any other campaign that relies on these logs to do various actions, like sending another campaign after one campaign has been sent, etc, will not work anymore.