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	1068	March 18, 2022
Mautic DB Hygiene General Discussion	7	1035	March 22, 2022
Data base up to 1GB General Discussion	3	289	September 19, 2017
Database backup with cronjob Product Support	3	234	October 6, 2023
Possibilities to „clean up“ mautic to make it run faster? Product Support	5	1039	April 21, 2022

Unwieldy database. Help?

Related Topics