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
Deleting old database records (from campaign_lead_event_log) due to extreme database CPU usage Product Support	2	654	August 2, 2022
Database Size 4.4GB - with campaign_lead_event_log and lead_event_log accounting for 3.7GB Product Support development	18	3546	July 5, 2022
Mautic DB Huge - Events & Import History - what can be deleted Product Support	4	1371	October 4, 2020
Mautic some table size is increasing rapidly Product Support mautic-4	8	571	October 29, 2022
Database run up to 1GB! Issue Product Support	13	1552	September 20, 2017

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

Related Topics