We have an instance that has been using CiviMail extensively for years. The civicrm_mailing and civicrm_activiy tables far exceed the number of records of any other tables.
It seems likely that these tables could have some ancient history removed from them and make some operations work more smoothly, faster, or less error prone. e.g. back-ups or operations in civicrm involving groups.
Are there any recommendations, best-practices, or gotcha's for archiving/deleting historic data in CiviCRM. Specifically for mailings and activities, but while we are at it: contact or other data as well?
Top database tables:
2.6G ./prod_civicrm/civicrm_mailing_recipients.ibd 2.3G ./prod_civicrm/civicrm_mailing_event_queue.ibd 1.6G ./prod_civicrm/civicrm_activity_contact.ibd 1001M ./prod_civicrm/civicrm_log.ibd 641M ./prod_civicrm/civicrm_mailing_event_delivered.ibd