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	661	August 2, 2022
Mautic database is huge, can I manually delete old records? Product Support	34	4658	March 5, 2024
Mautic some table size is increasing rapidly Product Support mautic-4	8	574	October 29, 2022
Mautic DB Huge - Events & Import History - what can be deleted Product Support	4	1376	October 4, 2020
Mautic DB Hygiene General Discussion	7	1169	March 22, 2022

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

Related topics