# Huge mtemail\_stats table

**URL:** <https://forum.mautic.org/t/huge-mtemail-stats-table/2520>\
**Category:** Product Support\
**Created:** [October 15, 2015, 1:43pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520 "2015-10-15T13:43:04Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![karibu](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@karibu](https://forum.mautic.org/u/karibu)\
**Post date:** [October 15, 2015, 1:43pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/1 "2015-10-15T13:43:04Z")

</div>

Hi guys,  
  
  
  
We have been using Mautic in the past 3 weeks with some positive and negative points.  
  
We have sent around 500,000 emails to 350,000 contacts.  
  
  
  
We had some glitches with our platform and realized we were running out of space. After digging, I found that the table “mtemail\_stats” is taking around 12GB…  
  
  
  
I’m cleaning the data inside based on the sent date, but I still feel uncomfortable having such issue with Mautic that will probably arise again.  
  
  
  
Any idea why so big? (Okay 350,000 lines but still…)  
  
  
  
Thank you

---

<div class="post-metadata">

**Author:** ![karibu](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@karibu](https://forum.mautic.org/u/karibu)\
**Post date:** [October 15, 2015, 1:43pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/2 "2015-10-15T13:43:04Z")

</div>

Hi guys,

We have been using Mautic in the past 3 weeks with some positive and negative points.  
We have sent around 500,000 emails to 350,000 contacts.

We had some glitches with our platform and realized we were running out of space. After digging, I found that the table “mtemail\_stats” is taking around 12GB…

I’m cleaning the data inside based on the sent date, but I still feel uncomfortable having such issue with Mautic that will probably arise again.

Any idea why so big? (Okay 350,000 lines but still…)

Thank you

---

<div class="post-metadata">

**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\
**Post date:** [October 15, 2015, 1:47pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/3 "2015-10-15T13:47:24Z")

</div>

What’s the content of your emails sent? Do you have a lot of embedded SVGs? Mautic does keep a copy of the email sent to the lead which is used to review copies of what was sent via the web view URLs (optionally embedded in sent emails) or from the lead’s timeline. If you have a lot of images in the email, that table could get big.

We store a copy because the “template” can be changed, or an A/B test removed, or the email deleted.

---

<div class="post-metadata">

**Author:** ![karibu](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@karibu](https://forum.mautic.org/u/karibu)\
**Post date:** [October 15, 2015, 1:57pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/4 "2015-10-15T13:57:03Z")

</div>

Ah, that could come from there… I have some images in the emails indeed…times the numbers of rows…

Thanks for the fast reply. I’m deleting most of the records now.

---

<div class="post-metadata">

**Author:** ![gmillard](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gmillard/32/5_2.png) [@gmillard](https://forum.mautic.org/u/gmillard)\
**Post date:** [October 15, 2015, 1:58pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/5 "2015-10-15T13:58:50Z")

</div>

Note that if you delete the records, Mautic will not keep track of open rates as it is those rows it uses to determine what lead opened what and what campaigns, etc will use in the opens email decisions.

It would be better to just wipe out the contents of the “copy” column unless you really just don’t care about the stats and don’t use campaigns with opened email decisions.

---

<div class="post-metadata">

**Author:** ![karibu](https://avatars.discourse-cdn.com/v4/letter/k/c6cbf5/32.png) [@karibu](https://forum.mautic.org/u/karibu)\
**Post date:** [October 15, 2015, 2:02pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/6 "2015-10-15T14:02:07Z")

</div>

Thanks for the suggestion Alan!

---

<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:57pm UTC](https://forum.mautic.org/t/huge-mtemail-stats-table/2520/7 "2020-02-02T22:57:48Z")

</div>


