# 1.6GB email\_stats

**URL:** <https://forum.mautic.org/t/1-6gb-email-stats/8754>\
**Category:** Product Support\
**Created:** [June 16, 2017, 9:17am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754 "2017-06-16T09:17:45Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![vilumoi](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@vilumoi](https://forum.mautic.org/u/vilumoi)\
**Post date:** [June 16, 2017, 9:17am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/1 "2017-06-16T09:17:45Z")

</div>

Hi i have a problem with my Mautic’s database.  
  
In the table of email\_stats i have 356.000 register inside but it weighs 1.6 GiB and i think is not possible. Someone can tell me if it’s a general problem or it’s only me.  
  
  
  
**I’m using the v2.2.1**  
  
  
  
 ![71340ff4474bc6d60d44170895ed1ee1.png](https://ci6.googleusercontent.com/proxy/4kR5gMiBYL6SFaBRBl7Z4UvIaeJnQT7ksIX-5CEZPSckfg07iJmrWZnOgB0bQPMAFUPNeeQAk_ViD-mv5rgOkH9uBWGto28SdypEauEQ=s0-d-e1-ft#https://i.gyazo.com/71340ff4474bc6d60d44170895ed1ee1.png)

---

<div class="post-metadata">

**Author:** ![vilumoi](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@vilumoi](https://forum.mautic.org/u/vilumoi)\
**Post date:** [June 16, 2017, 9:17am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/2 "2017-06-16T09:17:45Z")

</div>

Hi i have a problem with my Mautic’s database.  
In the table of email\_stats i have 356.000 register inside but it weighs 1.6 GiB and i think is not possible. Someone can tell me if it’s a general problem or it’s only me.

I’m using the v2.2.1

![](https://ci6.googleusercontent.com/proxy/4kR5gMiBYL6SFaBRBl7Z4UvIaeJnQT7ksIX-5CEZPSckfg07iJmrWZnOgB0bQPMAFUPNeeQAk_ViD-mv5rgOkH9uBWGto28SdypEauEQ=s0-d-e1-ft#https://i.gyazo.com/71340ff4474bc6d60d44170895ed1ee1.png)

---

<div class="post-metadata">

**Author:** ![ninjoan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ninjoan/32/1005_2.png) [@ninjoan](https://forum.mautic.org/u/ninjoan)\
**Post date:** [June 16, 2017, 12:28pm UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/3 "2017-06-16T12:28:38Z")

</div>

Are you doing your Mautic Maintenance?

---

<div class="post-metadata">

**Author:** ![vilumoi](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@vilumoi](https://forum.mautic.org/u/vilumoi)\
**Post date:** [June 19, 2017, 6:32am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/4 "2017-06-19T06:32:49Z")

</div>

> [@23753:@ninjoan](#):
>
> Mautic Maintenance

How i can do my Mautic Maintenance?

---

<div class="post-metadata">

**Author:** ![petertl](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/petertl/32/511_2.png) [@petertl](https://forum.mautic.org/u/petertl)\
**Post date:** [June 19, 2017, 7:04am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/5 "2017-06-19T07:04:36Z")

</div>

[quote]Cleanup Old Data

Cleanup a Mautic installation by purging old data. Note that not all data is able to be purged. Currently supported are audit log entries, visitors (anonymous contacts), and visitor page hits. Use --dry-run to view the number of records to be purged before making any changes.

This will permanently delete data! Be sure to keep database backups.

php /path/to/mautic/app/console mautic:maintenance:cleanup --days-old=365 --dry-run[/quote]  
[https://mautic.org/docs/en/setup/cron\_jobs.html](https://mautic.org/docs/en/setup/cron_jobs.html)

---

<div class="post-metadata">

**Author:** ![vilumoi](https://avatars.discourse-cdn.com/v4/letter/v/0ea827/32.png) [@vilumoi](https://forum.mautic.org/u/vilumoi)\
**Post date:** [June 19, 2017, 7:50am UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/6 "2017-06-19T07:50:49Z")

</div>

> [@23787:@PeterTL](#):
>
> [Cron jobs | Mautic](https://mautic.org/docs/en/setup/cron_jobs.html)

I have a problem with emails, Cleanup Old Data does not do anything to improve that table.

---

<div class="post-metadata">

**Author:** ![cswainhart](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cswainhart/32/353_2.png) [@cswainhart](https://forum.mautic.org/u/cswainhart)\
**Post date:** [April 10, 2020, 2:41pm UTC](https://forum.mautic.org/t/1-6gb-email-stats/8754/7 "2020-04-10T14:41:24Z")

</div>

I am surprised this is so old. I thought I would search this topic because IMO it remains a big issue. The maintenance doesn’t seem to clear it out, so I have do do so manually. I am hoping that perhaps by commenting on this it will bring it to someone’s attention.
