I've got detailed logging turned on, and everything is getting stored in a separate DB, but it's getting pretty big. Is it OK simply to truncate the tables? Clearly I'll lose the data, and the ability to roll back changes, but I need to keep the size of the database under some sort of control. If so, how could I delete everything older than say, the last 3 months? This post offers some clues on that.

1 Answer 1


Yes you can delete/truncate the log tables. It's not used for anything except the change log / manual investigations.

That post you linked to answers your second question: DELETE FROM log_civicrm_XXX WHERE log_date < DATE_SUB(NOW(), INTERVAL 3 MONTH)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.