Unwieldy database. Help?

miamiman · December 30, 2022, 4:01pm

I’m reviewing our cleanup cronjob:

mautic/bin/console mautic:maintenance:cleanup --days-old=365 --no-interaction

Is there a reason to keep anonymous data for so long? Could it be reduced to 90, 60, 30 days? Is there a community agreed to length of time to keep anonymous data?
Does the cronjob delete the anonymous data from the mau_leads table? I have over 8M.

Any comment and help would be much appreciated.

joeyk · December 31, 2022, 4:09pm

Check this:

gist.github.com

https://gist.github.com/sebastian-fahrenkrog/0d53ced6a50ed680383f4680c6398635

Mautic Cleanup Commands

# normal mautic cleanup up commandos (deletes only unused ips and anonymous leads which are at least 3 weeks old)
# must be called multiple times
php bin/console mautic:unusedip:delete -n --limit=99999999999
php bin/console mautic:unusedip:delete -n --limit=99999999999
php bin/console mautic:maintenance:cleanup --days-old=21 -n
php bin/console mautic:maintenance:cleanup --days-old=21 -n

# after 30 days we clear infos in email stats about specific email details => email is stil in lead profile 
php bin/console doctrine:query:sql "UPDATE email_stats SET tokens = NULL WHERE date_sent < (NOW() - INTERVAL 30 DAY);"
php bin/console doctrine:query:sql "UPDATE email_stats SET open_details = NULL WHERE date_sent < (NOW() - INTERVAL 30 DAY);"

This file has been truncated. show original

system · January 2, 2023, 4:10am

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Clean database from old entries with command line Ideas and Feature Requests	3	1208	March 18, 2022
How do you keep the data in your Mautic DB trimmed and gdpr compliant? General Discussion	9	2434	April 7, 2020
Does the cronjob mautic:maintenance:cleanup --days-old=90 remove old identified contacts? Product Support	4	1211	June 18, 2022
Mautic DB Hygiene General Discussion	7	1169	March 22, 2022
1.6GB email_stats Product Support	6	681	April 10, 2020

Unwieldy database. Help?

Related topics