Mautic Community Forums

Delete old rows from email_stats table without breaking front-end

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.

1 Like

Hi Bob,

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

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 folks are experiencing some pain on this issue, ya?

Thanks again!
Bob H.

Also check out @heathdutton’s article: 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 :slight_smile: