# What Database tables can I periodically clean?

**URL:** https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020
**Category:** Product Support
**Created:** [December 18, 2015, 7:13pm UTC](https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020 "2015-12-18T19:13:42Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![healthstatus](https://avatars.discourse-cdn.com/v4/letter/h/9f8e36/32.png) [@healthstatus](https://forum.mautic.org/u/healthstatus)
#### Post date: [December 18, 2015, 7:13pm UTC](https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020/1 "2015-12-18T19:13:42Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![healthstatus](https://avatars.discourse-cdn.com/v4/letter/h/9f8e36/32.png) [@healthstatus](https://forum.mautic.org/u/healthstatus)
#### Post date: [December 18, 2015, 7:13pm UTC](https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020/2 "2015-12-18T19:13:42Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)
#### Post date: [December 21, 2015, 8:22am UTC](https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020/3 "2015-12-21T08:22:22Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)
#### Post date: [February 2, 2020, 10:56pm UTC](https://forum.mautic.org/t/what-database-tables-can-i-periodically-clean/3020/4 "2020-02-02T22:56:20Z")

</div>


