Archive campaigns delivery logs

Archive campaigns delivery logs

Since AppMail 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.

    • Related Articles

    • Available logs

      While AppMail is running, it saves a lot of logs in order for you to see what is happening under the hood, which means in case something goes wrong, these logs are also extremely useful for debugging purposes. You can view the campaigns delivery logs ...

    • How can I check my campaign delivery logs?

      Each time when a campaign is sending, AppMail keeps a log of the subscriber which received the campaigns so far so that we don’t send same email several times to same subscriber. Beside this crucial functionality, these logs can also be used to see ...

    • Delivery and Bounce logs, why you should monitor these!

      Usually, we get a certain percent of support tickets related to sending issues and first thing that I do is to look in Backend > Miscellaneous > Campaigns Delivery Logs. This area contains a lot of information that tells you exactly how your sending ...

    • Enable the use of temporary queue tables when sending campaigns

      The main issue we have with huge AppMail apps is that the campaign_delivery_log table becomes huge (I’ve seen installs with hundred GB’s of data in that table alone) and we use that table to join against when we send the campaigns so that we can see ...

    • Recurring Campaigns

      One great feature of AppMail is recurring campaigns, which means you can set it in a way that every 10th of each month you could send an RSS FEED campaign with latest blog posts. But this is not all, you can even set it to send in various days of the ...