# Delete old rows from email\_stats table without breaking front-end

**URL:** https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201
**Category:** Product Support
**Created:** [September 23, 2019, 5:30pm UTC](https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201 "2019-09-23T17:30:49Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)
#### Post date: [September 23, 2019, 5:30pm UTC](https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201/1 "2019-09-23T17:30:49Z")

</div>

**Your software**  
My Mautic version is: 2.13.2  
My PHP version is: 7

**Your problem**  
My problem is: The email\_stats table is growing too large. I see in MySQL that the table columns are already designed/set to be compressed, not dynamic. So, can I delete old rows from the email\_stats table without breaking the front-end? I’m hoping the only issue is that Reports would not be able to show data for time frames where the rows have been deleted.

These errors are showing in the log: N/A

Steps I have tried to fix the problem: N/A

Thanks so much for any insights!

Bob H.

---

<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: [September 24, 2019, 4:22pm UTC](https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201/2 "2019-09-24T16:22:06Z")

</div>

Hi Bob,

Have you chimed in on this discussion on Github: [https://github.com/mautic/mautic/issues/7763](https://github.com/mautic/mautic/issues/7763)?

---

<div class="post-metadata">

### Author: ![bob-herman](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bob-herman/32/288_2.png) [@bob-herman](https://forum.mautic.org/u/bob-herman)
#### Post date: [September 24, 2019, 7:48pm UTC](https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201/3 "2019-09-24T19:48:10Z")

</div>

Hi Ruth:

Thanks so much for your reply. I’ve reviewed the issue as reported on GitHub. I think I’ll use the SQL Update statements as provided in that issue till hopefully a future release addresses the issue.

I think any implementation of size makes it quite costly to run given the disk space requirements to handle how it presently grows the email\_stats table. I would imagine the [mautic.com](http://mautic.com) folks are experiencing some pain on this issue, ya?

Thanks again!  
Bob H.

---

<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: [September 24, 2019, 8:04pm UTC](https://forum.mautic.org/t/delete-old-rows-from-email-stats-table-without-breaking-front-end/11201/4 "2019-09-24T20:04:51Z")

</div>

Also check out @heathdutton’s article: [https://www.linkedin.com/pulse/so-you-hit-2147483647-heath-dutton-/?trackingId=iOSEfMkE5J7yP8vQvV%2FMnA%3D%3D](https://www.linkedin.com/pulse/so-you-hit-2147483647-heath-dutton-/?trackingId=iOSEfMkE5J7yP8vQvV%2FMnA%3D%3D) which might have some useful tips for working at scale 🙂