# DB database too big after first sent

**URL:** https://forum.mautic.org/t/db-database-too-big-after-first-sent/8252
**Category:** Product Support
**Created:** [April 19, 2017, 12:20pm UTC](https://forum.mautic.org/t/db-database-too-big-after-first-sent/8252 "2017-04-19T12:20:11Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![carlessebastian](https://avatars.discourse-cdn.com/v4/letter/c/aca169/32.png) [@carlessebastian](https://forum.mautic.org/u/carlessebastian)
#### Post date: [April 19, 2017, 12:20pm UTC](https://forum.mautic.org/t/db-database-too-big-after-first-sent/8252/1 "2017-04-19T12:20:11Z")

</div>

Hi,  
  
we start using mautic 2.7.1 as our software automation and we are having issues with email\_stats.tokens.  
  
After first email (channel \>\> emails) (165.000 leads), now email\_stats table is 2.5Gb size (when updating all registries to tokens = ‘’ table gets only 33 Mb).  
  
Having a look at email\_stats.tokens contains a lot of information (I have 25 links in the same email that becomes 25 links to track) , but repetitive information. If we keep going DB will become to heavy to be used.  
  
  
  
I understand that this information is useful for tracking proposes, but if stored on that way will become unusable.  
  
My question:  
  
  
  
**Is there any way to disable link tracking without modifying mautic code?**  
  
**If there isn’t, there is any plan to implement it or to improve data storage?**  
  
  
  
As an example campaign parameter (on my campaing:

Code:

ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MjQ7fXM6NToiZW1haWwiO2k6MjQ7czo0OiJzdGF0IjtzOjEzOiI1OGVmNWQxZTZlYmU5IjtzOjQ6ImxlYWQiO3M6NjoiNzE1MTQ5IjtzOjc6ImNoYW5uZWwiO2E6MTp7czo1OiJlbWFpbCI7aToyNDt9fQ%3D%3D

) is constant, but incorporated once per link on tokens field, probably could improve space a lot  
  
Many thanks,  
Carles

---

<div class="post-metadata">

### Author: ![carlessebastian](https://avatars.discourse-cdn.com/v4/letter/c/aca169/32.png) [@carlessebastian](https://forum.mautic.org/u/carlessebastian)
#### Post date: [April 19, 2017, 12:20pm UTC](https://forum.mautic.org/t/db-database-too-big-after-first-sent/8252/2 "2017-04-19T12:20:11Z")

</div>

Hi,  
we start using mautic 2.7.1 as our software automation and we are having issues with email\_stats.tokens.  
After first email (channel \>\> emails) (165.000 leads), now email\_stats table is 2.5Gb size (when updating all registries to tokens = ‘’ table gets only 33 Mb).  
Having a look at email\_stats.tokens contains a lot of information (I have 25 links in the same email that becomes 25 links to track) , but repetitive information. If we keep going DB will become to heavy to be used.

I understand that this information is useful for tracking proposes, but if stored on that way will become unusable.  
My question:

Is there any way to disable link tracking without modifying mautic code?  
If there isn’t, there is any plan to implement it or to improve data storage?

As an example campaign parameter (on my campaing: `ct=YTo1OntzOjY6InNvdXJjZSI7YToyOntpOjA7czo1OiJlbWFpbCI7aToxO2k6MjQ7fXM6NToiZW1haWwiO2k6MjQ7czo0OiJzdGF0IjtzOjEzOiI1OGVmNWQxZTZlYmU5IjtzOjQ6ImxlYWQiO3M6NjoiNzE1MTQ5IjtzOjc6ImNoYW5uZWwiO2E6MTp7czo1OiJlbWFpbCI7aToyNDt9fQ%3D%3D` ) is constant, but incorporated once per link on tokens field, probably could improve space a lot

Many thanks,  
Carles
