Mautic database is huge, can I manually delete old records?

sfahrenkrog1 · February 15, 2022, 2:23pm

Hey Instamaker

You could do this commands on the shell (backup + on your own risk!)

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

We do them regularly but I could give you no garanty.

There is a new plugin which does some campaign_lead_event_log cleanups:
https://github.com/Leuchtfeuer/mautic-housekeeping-bundle

**Update: **
Sorry made a mistake in the audit log statement. Fixed it in the gist.

Greetings
Sebastian

Topic		Replies	Views
Mautic DB Huge - Events & Import History - what can be deleted Product Support	4	1252	October 4, 2020
Mautic some table size is increasing rapidly Product Support mautic-4	8	456	October 29, 2022
Issue deleting data Product Support	1	165	January 18, 2023
How do you keep the data in your Mautic DB trimmed and gdpr compliant? General Discussion	9	2255	April 7, 2020
Best way for deleting 26.000 contacts of Mautic? Product Support	8	1053	August 16, 2021

Mautic database is huge, can I manually delete old records?

Related Topics