CiviCRM 4.7.31 (upgrading today) Drupal 7.x
Our log_civicrm_group table crashed and needed repair. We had to run the repair twice from the command line for it to actually work. It's about 850MB large now. When we click the "log" tab on some contact records we're seeing some timeouts or some extremely long load times. It should also be noted we're using a MailChimp extension and there is extensive use of groups.
Does anyone have a suggestion for keeping these log tables at sane sizes (archiving?) or optimizing mysql to present them quicker despite their size?
Thank you for any suggestions. We just enabled the feature and didn't think about what to do after collecting a year of logs.