CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this community
I've got a civicrm database of 1.4 Go (information available in PhpMyAdmin) 1Go is used by civicrm_activity table I would like to know if have to clean, purge the database to reduce its size, cache or others maintenance actions.
I find some actions on documentation for cache files but nothing about database
Thanks for advices
civicrm_activity is a legitimate table with legitimate data. You can use the API to mass-delete activities - but only you (and/or your users) can determine what represents data that is reasonable to delete.
If it's that large, I suspect it's quite likely that you're sending frequent mailings to large groups of people - the mailing history might be reasonable thing to delete.
SHOW CREATE TABLE civicrm_mailing doesn't reveal any foreign keys - so it would have to happen at the PHP level if it happens. And frankly, I doubt it; I know deleting a Contribution Batch doesn't delete the associated activity (with disastrous results). I think someone wrote an archiver though - if you grab me on Mattermost I can tell you who to talk to.
Apr 16 '20 at 22:21