Mautic Community Forums

What Database tables can I periodically clean?

I have a busy site. I was looking at my database and I have several tables north of 1.5 million records, page_hits is over 4.5 million, and the audit table is over 3.5 million. Can I clean(dump/delete) any of them on a regular basis? Or dump them once they get to be xx days old?

I have a busy site. I was looking at my database and I have several tables north of 1.5 million records, page_hits is over 4.5 million, and the audit table is over 3.5 million. Can I clean(dump/delete) any of them on a regular basis? Or dump them once they get to be xx days old?

You probably can, but you’ll loose the statistic data, lead timeline events and so on. Also the campaigns may start to work in circles (some leads might execute some campaign events multiple times since you delete the log). Some leads might receive the same email again (since you remove the information that they received it already). Mautic 1.2.3 will bring some optimizations.