Database Size 4.4GB - with campaign_lead_event_log and lead_event_log accounting for 3.7GB

sfahrenkrog1 · July 5, 2022, 11:28am

Hey Alex

I would like to recommend you this thread regarding the db cleanup:

I also published our intern db cleanup script there.

Direct link to my gist in the thread:

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

Greetings
Sebastian

Topic		Replies	Views
Deleting old database records (from campaign_lead_event_log) due to extreme database CPU usage Product Support	2	531	August 2, 2022
What Database tables can I periodically clean? Product Support	3	1046	February 2, 2020
Help understanding Campaign Schema/Data Structure? General Discussion	3	101	December 30, 2023
Log error: campaign_lead_event_failed_log - Need help please Product Support	8	192	January 15, 2024
Is it possible to break mautic database into 2 databases? Product Support	7	212	August 1, 2023

Database Size 4.4GB - with campaign_lead_event_log and lead_event_log accounting for 3.7GB

Related Topics