Mailwizz purge customer logs

[lifer]

We are constantly seeing heavy queries to mw_customer_action_log running in mysql and congesting everything else. The table itself is massive too. As I understand, this is a log of subscribers being added and unsubscribed.

Is there a setting to purge older records from it? And will it affect any campaign stats or in any way?

 

[laurentiu]

Is there a setting to purge older records from it?

Yes, you can use table-cleaner command from command line:
table-cleaner --table=NAME --time=EXPRESSION
--table=NAME where NAME can be any of the table listed with the tables command.
--time=EXPRESSION where EXPRESSION can be any expression parsable by php's strtotime function. ie: --time="-10 days".

Command example:

/usr/bin/php -q /home/roboset/public_html/apps/console/console.php  table-cleaner --table=mw_customer_action_log  --time="-10 days"

this command will delete all records that are older than "2023-02-03"

And will it affect any campaign stats or in any way?

This table is used for Dashboard > Recent activity.