Scaling Mailcoach

On this page:

Cleanup

Some of Mailcoach’s tables can grow quite large when sending regular or large campaigns. You can configure cleanup (pruning) of data using the prune_after_days configuration array in config/mailcoach.php:

/**
 * Pruning settings determine after how many days the models should be pruned.
 * This will keep aggregated (calculated) statistics available, individual
 * subscriber rows will be deleted. Using null will disable pruning.
 * @since 8.13.0
 */
'prune_after_days' => [
    'sends' => null,
    'opens' => null,
    'clicks' => null,
    'unsubscribes' => null,
    'send_feedback_items' => null,
    'transactional_mail_log_items' => null,
],

We generally recommend deleting data older than 30 days, as you’d rarely need this data that long after sending. Aggregated (calculated) statistics will stay available in the summary views of campaigns, automation mails and transactional mails.

Make sure the php artisan mailcoach:prune command runs on a regular schedule in your application.

Campaigns
Configuration recommendations